Redirect 301 redirect from GET @app_map (7c82f4)

GET http://demo-app.wastreet.app/map?point_recyclage_id=10&type=decheterie

Query Metrics

11 Database Queries
7 Different statements
13.60 ms Query time
4 Invalid entities
931 Managed entities

Queries

Group similar statements

# Time Info
1 1.69 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 0.68 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 0.74 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.59 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.32 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.53 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.82 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 0.65 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 0.84 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 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:
[
  443
]
11 0.80 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
  • The mappings App\Entity\Tc_structure#TcSignalementFile and App\Entity\TcSignalementsFiles#tcStructure are inconsistent with each other.
App\Entity\Flux
  • The association App\Entity\Flux#valorisations refers to the owning side field App\Entity\Valorisation#flux which does not exist.
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
  • The association App\Entity\TcSignalementsFiles#tcStructure refers to the inverse side field App\Entity\Tc_structure#TcSignalement which does not exist.
App\Entity\TcSignalementsStatutsType No errors.
App\Entity\TcSignalementsTraitements No errors.
App\Entity\Ramassage No errors.
App\Entity\Actualite
  • The association App\Entity\Actualite#villesRattachees refers to the inverse side field App\Entity\TcVille#actualitesRattachees which does not exist.