Symfony Profiler

Query Metrics

32 Database Queries
10 Different statements
19.30 ms Query time
0 Invalid entities
Queries


SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.service AS service_7, t0.is_active AS is_active_8, t0.next_id AS next_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.responsable_id AS responsable_id_15 FROM `user` t0 WHERE t0.id = ?
SELECT COUNT(d0_.id) AS sclr_0 FROM demande d0_ WHERE d0_.status = ? AND (d0_.date_signal_panne BETWEEN ? AND ?) AND d0_.user_id = ?
SELECT COUNT(b0_.id) AS sclr_0 FROM bon b0_ WHERE b0_.statut = ? AND (b0_.date_emission BETWEEN ? AND ?) AND b0_.user_id = ?
SELECT 
            MONTH(date_signal_panne) AS mois,
            COUNT(id) AS total,
            SUM(CASE WHEN status = 'VALIDEE' THEN 1 ELSE 0 END) AS validees,
            SUM(CASE WHEN status = 'REJETEE' THEN 1 ELSE 0 END) AS rejetees
        FROM demande
        WHERE YEAR(date_signal_panne) = :annee
     AND date_signal_panne BETWEEN :startDate AND :endDate AND user_id = :userId
        GROUP BY mois
        ORDER BY mois ASC
SELECT d0_.id AS id_0, d0_.description_panne AS description_panne_1, d0_.motif_rejet AS motif_rejet_2, d0_.status AS status_3, d0_.date_constat AS date_constat_4, d0_.date_signal_panne AS date_signal_panne_5, d0_.service_concerne AS service_concerne_6, d0_.quantite AS quantite_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9, d0_.deleted_at AS deleted_at_10, d0_.created_by AS created_by_11, d0_.updated_by AS updated_by_12, d0_.validateur_realisee_id AS validateur_realisee_id_13, d0_.validateur_pris_en_compte_id AS validateur_pris_en_compte_id_14, d0_.rejeter_par_id AS rejeter_par_id_15, d0_.user_id AS user_id_16, d0_.equipement_id AS equipement_id_17, d0_.produit_id AS produit_id_18 FROM demande d0_ WHERE d0_.user_id = ? AND (d0_.created_at BETWEEN ? AND ?) ORDER BY d0_.created_at DESC LIMIT 3
SELECT b0_.id AS id_0, b0_.date_emission AS date_emission_1, b0_.motif_decaissement AS motif_decaissement_2, b0_.service AS service_3, b0_.montant_total AS montant_total_4, b0_.motif_rejet AS motif_rejet_5, b0_.statut AS statut_6, b0_.is_priority AS is_priority_7, b0_.objet AS objet_8, b0_.montant_restitue AS montant_restitue_9, b0_.date_restitution AS date_restitution_10, b0_.statut_restitution AS statut_restitution_11, b0_.is_facture_recue AS is_facture_recue_12, b0_.chemin_facture AS chemin_facture_13, b0_.nom_original_facture AS nom_original_facture_14, b0_.date_reception_facture AS date_reception_facture_15, b0_.montant_rejet AS montant_rejet_16, b0_.is_dispatch AS is_dispatch_17, b0_.date_decaissement AS date_decaissement_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.deleted_at AS deleted_at_21, b0_.created_by AS created_by_22, b0_.updated_by AS updated_by_23, b0_.chef_service_id AS chef_service_id_24, b0_.direction_generale_id AS direction_generale_id_25, b0_.rejeter_par_id AS rejeter_par_id_26, b0_.receptionnaire_sous_id AS receptionnaire_sous_id_27, b0_.depensier_id AS depensier_id_28, b0_.receptionnaire_facture_id AS receptionnaire_facture_id_29, b0_.demande_id AS demande_id_30, b0_.caissiere_id AS caissiere_id_31, b0_.user_id AS user_id_32, b0_.direction_financiere_id AS direction_financiere_id_33, b0_.compte_syscohada_id AS compte_syscohada_id_34, b0_.restituteur_id AS restituteur_id_35, b0_.objet_bon_id AS objet_bon_id_36 FROM bon b0_ WHERE b0_.user_id = ? AND (b0_.created_at BETWEEN ? AND ?) ORDER BY b0_.created_at DESC LIMIT 3
SELECT 
            DATE_FORMAT(date_emission, '%Y-%m') AS mois,
            SUM(CASE WHEN statut IN ('DECAISSE', 'RECEPTION DES FONDS', 'DEPENSE EFFECTUEE', 'FACTURE RECU') 
                THEN montant_total ELSE 0 END) AS decaissements,
            COUNT(*) AS totalBons,
            SUM(montant_total) AS montantTotal
        FROM bon
        WHERE date_emission BETWEEN :dateDebut AND :dateFin
         AND user_id = :userId
        GROUP BY mois
        ORDER BY mois DESC
SELECT SUM(b0_.montant_total) AS sclr_0 FROM bon b0_ WHERE b0_.statut = 'VALIDE PAR LA COMPTABILITE' AND b0_.service = ?
SELECT SUM(CASE WHEN b0_.statut IN (?, ?, ?, ?) THEN b0_.montant_total ELSE 0 END) AS sclr_0 FROM bon b0_ WHERE (b0_.date_emission BETWEEN ? AND ?) AND b0_.service = ?
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = ? AND t0.entity = ? AND t0.action = ? LIMIT 1
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Demande	No errors.
App\Entity\Bon	No errors.
App\Entity\Assignation	No errors.
App\Entity\Operation	No errors.
App\Entity\Permission	No errors.
App\Entity\OperationCaisse	No errors.
App\Entity\BonDispatch	No errors.
App\Entity\BonRestitution	No errors.
App\Entity\MoyensRoulant	No errors.
App\Entity\Produit	No errors.
App\Entity\CompteSyscohada	No errors.
App\Entity\ObjetBon	No errors.
Symfony Profiler

GET https://tc-logistic.topcrono.com/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
