Query Metrics
11
Database Queries
7
Different statements
43.08 ms
Query time
4
Invalid entities
931
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.73 ms |
SELECT t0.id_tc_structure AS id_tc_structure_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.code_territoire_wastreet_eu AS code_territoire_wastreet_eu_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.logo AS logo_7, t0.tc_agence_id AS tc_agence_id_8, t0.simplicity_vehicle_category_id AS simplicity_vehicle_category_id_9, t10.id_tc_signalement AS id_tc_signalement_11, t10.titre AS titre_12, t10.origine AS origine_13, t10.contrat AS contrat_14, t10.source AS source_15, t10.numero_voie AS numero_voie_16, t10.adresse_complement AS adresse_complement_17, t10.numero_bac AS numero_bac_18, t10.date_incident AS date_incident_19, t10.commentaire AS commentaire_20, t10.suite_a_donner AS suite_a_donner_21, t10.information AS information_22, t10.info_supp AS info_supp_23, t10.date_creation AS date_creation_24, t10.gpso_flux_ou_prestation AS gpso_flux_ou_prestation_25, t10.gpso_chantier AS gpso_chantier_26, t10.is_new_message AS is_new_message_27, t10.is_new_message_by AS is_new_message_by_28, t10.is_new_signalement AS is_new_signalement_29, t10.is_resp_sepure AS is_resp_sepure_30, t10.sygom_email AS sygom_email_31, t10.sygom_name AS sygom_name_32, t10.sygom_firstname AS sygom_firstname_33, t10.sygom_phone AS sygom_phone_34, t10.sygom_type AS sygom_type_35, t10.sygom_productor AS sygom_productor_36, t10.sygom_is_contact_usager AS sygom_is_contact_usager_37, t10.is_sygom AS is_sygom_38, t10.sygom_commentaire AS sygom_commentaire_39, t10.is_from_simplicity AS is_from_simplicity_40, t10.id_simplicity_anomaly AS id_simplicity_anomaly_41, t10.priorite AS priorite_42, t10.lat AS lat_43, t10.lon AS lon_44, t10.icon AS icon_45, t10.simplicity_file_parsed AS simplicity_file_parsed_46, t10.voie AS voie_47, t10.id_tc_ville AS id_tc_ville_48, t10.id_tc_structure AS id_tc_structure_49, t10.id_administre AS id_administre_50, t10.description AS description_51, t10.complement AS complement_52, t10.statut AS statut_53 FROM tc_structure t0 LEFT JOIN tc_signalements t10 ON t10.id_tc_structure = t0.id_tc_structure WHERE t0.id_tc_structure = ?
Parameters:
[
102
]
|
||||||||||||||||||||||||||||
| 2 | 5.56 ms |
SELECT t0.id AS id_1, t0.commentaire_action_a_mener AS commentaire_action_a_mener_2, t0.tc_signalement_id AS tc_signalement_id_3 FROM tc_signalements_traitements t0 WHERE t0.tc_signalement_id = ?
Parameters:
[
89105
]
|
||||||||||||||||||||||||||||
| 3 | 9.27 ms |
SELECT t0.id AS id_1, t0.server_name AS server_name_2, t0.name AS name_3, t0.extension AS extension_4, t0.mimetype AS mimetype_5, t0.size AS size_6, t0.structure AS structure_7, t0.signalement AS signalement_8 FROM tc_signalements_files t0 WHERE t0.signalement IN (?)
Parameters:
[
89105
]
|
||||||||||||||||||||||||||||
| 4 | 0.96 ms |
SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.libelle AS libelle_1 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = ?
Parameters:
[
102
]
|
||||||||||||||||||||||||||||
| 5 | 1.68 ms |
SELECT d0_.id_decheterie AS id_decheterie_0, d0_.nom AS nom_1, d0_.adresse AS adresse_2, d0_.latitude AS latitude_3, d0_.longitude AS longitude_4, d0_.telephone AS telephone_5, d0_.open_lun_matin AS open_lun_matin_6, d0_.open_lun_aprem AS open_lun_aprem_7, d0_.open_mar_matin AS open_mar_matin_8, d0_.open_mar_aprem AS open_mar_aprem_9, d0_.open_mer_matin AS open_mer_matin_10, d0_.open_mer_aprem AS open_mer_aprem_11, d0_.open_jeu_matin AS open_jeu_matin_12, d0_.open_jeu_aprem AS open_jeu_aprem_13, d0_.open_ven_matin AS open_ven_matin_14, d0_.open_ven_aprem AS open_ven_aprem_15, d0_.open_sam_matin AS open_sam_matin_16, d0_.open_sam_aprem AS open_sam_aprem_17, d0_.open_dim_matin AS open_dim_matin_18, d0_.open_dim_aprem AS open_dim_aprem_19, d0_.icon AS icon_20, d0_.conditions_acces AS conditions_acces_21, d0_.informations AS informations_22, d0_.photo_1 AS photo_1_23, d0_.photo_2 AS photo_2_24, d0_.photo_3 AS photo_3_25, d0_.visible AS visible_26, t1_.id_tc_ville AS id_tc_ville_27, t1_.insee AS insee_28, t1_.code_postal AS code_postal_29, t1_.nom_ville AS nom_ville_30, t1_.is_active AS is_active_31, g2_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_32, g2_.code AS code_33, g2_.libelle AS libelle_34, g2_.fa_icon AS fa_icon_35, g2_.color AS color_36, g2_.is_active AS is_active_37, d0_.id_tc_flux AS id_tc_flux_38, d0_.id_tc_ville AS id_tc_ville_39, t1_.id_tc_structure AS id_tc_structure_40, g2_.structure AS structure_41 FROM decheterie d0_ INNER JOIN tc_ville t1_ ON d0_.id_tc_ville = t1_.id_tc_ville AND (t1_.id_tc_structure = ?) INNER JOIN gpso_flux_ou_prestation g2_ ON d0_.id_tc_flux = g2_.id_gpso_flux_ou_prestation AND (t1_.id_tc_structure = ?) WHERE t1_.id_tc_structure = ?
Parameters:
[ 102 102 102 ]
|
||||||||||||||||||||||||||||
| 6 | 4.49 ms |
SELECT p0_.id_pavs AS id_pavs_0, p0_.nom AS nom_1, p0_.adresse AS adresse_2, p0_.latitude AS latitude_3, p0_.longitude AS longitude_4, p0_.icon AS icon_5, p0_.photo_1 AS photo_1_6, p0_.photo_2 AS photo_2_7, p0_.photo_3 AS photo_3_8, p0_.display_name AS display_name_9, t1_.id_tc_ville AS id_tc_ville_10, t1_.insee AS insee_11, t1_.code_postal AS code_postal_12, t1_.nom_ville AS nom_ville_13, t1_.is_active AS is_active_14, g2_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_15, g2_.code AS code_16, g2_.libelle AS libelle_17, g2_.fa_icon AS fa_icon_18, g2_.color AS color_19, g2_.is_active AS is_active_20, p0_.id_tc_flux AS id_tc_flux_21, p0_.id_tc_ville AS id_tc_ville_22, t1_.id_tc_structure AS id_tc_structure_23, g2_.structure AS structure_24 FROM pavs p0_ INNER JOIN tc_ville t1_ ON p0_.id_tc_ville = t1_.id_tc_ville AND (t1_.id_tc_structure = ?) INNER JOIN gpso_flux_ou_prestation g2_ ON p0_.id_tc_flux = g2_.id_gpso_flux_ou_prestation AND (t1_.id_tc_structure = ?)
Parameters:
[ 102 102 ]
|
||||||||||||||||||||||||||||
| 7 | 0.94 ms |
SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = ?
Parameters:
[
444
]
|
||||||||||||||||||||||||||||
| 8 | 1.25 ms |
SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = ?
Parameters:
[
447
]
|
||||||||||||||||||||||||||||
| 9 | 4.61 ms |
SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = ?
Parameters:
[
452
]
|
||||||||||||||||||||||||||||
| 10 | 5.92 ms |
SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = ?
Parameters:
[
443
]
|
||||||||||||||||||||||||||||
| 11 | 6.67 ms |
SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = ?
Parameters:
[
456
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Pav | 677 |
| App\Entity\TcVille | 231 |
| App\Entity\Decheterie | 11 |
| App\Entity\Flux | 6 |
| App\Entity\Tc_structure | 1 |
| App\Entity\TcSignalements | 1 |
| App\Entity\ZonesVoies | 1 |
| App\Entity\TcSignalementsDescriptions | 1 |
| App\Entity\TcSignalementsComplements | 1 |
| App\Entity\TcSignalementsFiles | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Tc_structure |
|
| App\Entity\Flux |
|
| App\Entity\Decheterie | No errors. |
| App\Entity\Pav | No errors. |
| App\Entity\TcSignalements | No errors. |
| App\Entity\ZonesVoies | No errors. |
| App\Entity\TcVille | No errors. |
| App\Entity\Administre | No errors. |
| App\Entity\TcSignalementsDescriptions | No errors. |
| App\Entity\TcSignalementsComplements | No errors. |
| App\Entity\TcSignalementsStatuts | No errors. |
| App\Entity\Cout | No errors. |
| App\Entity\Objectif | No errors. |
| App\Entity\Tonnage | No errors. |
| App\Entity\Valorisation | No errors. |
| App\Entity\TcSignalementsFiles |
|
| App\Entity\TcSignalementsStatutsType | No errors. |
| App\Entity\TcSignalementsTraitements | No errors. |
| App\Entity\Ramassage | No errors. |
| App\Entity\Actualite |
|