https://lk1.test.genesii.fr/public/jhx7g9/lot?id=2249

Query Metrics

19 Database Queries
13 Different statements
8.11 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 ms
SELECT t0.id AS id_1, t0.dateheure AS dateheure_2, t0.date_derniere_modification AS date_derniere_modification_3, t0.apporteur AS apporteur_4, t0.societe AS societe_5, t0.emprunteur_nom AS emprunteur_nom_6, t0.emprunteur_prenom AS emprunteur_prenom_7, t0.emprunteur_date_naissance AS emprunteur_date_naissance_8, t0.emprunteur_adresse AS emprunteur_adresse_9, t0.emprunteur_tel_fr AS emprunteur_tel_fr_10, t0.emprunteur_tel_ch AS emprunteur_tel_ch_11, t0.emprunteur_email AS emprunteur_email_12, t0.emprunteur_lieu_travail AS emprunteur_lieu_travail_13, t0.co_emprunteur_nom AS co_emprunteur_nom_14, t0.co_emprunteur_prenom AS co_emprunteur_prenom_15, t0.co_emprunteur_date_naissance AS co_emprunteur_date_naissance_16, t0.co_emprunteur_adresse AS co_emprunteur_adresse_17, t0.co_emprunteur_tel_fr AS co_emprunteur_tel_fr_18, t0.co_emprunteur_tel_ch AS co_emprunteur_tel_ch_19, t0.co_emprunteur_email AS co_emprunteur_email_20, t0.co_emprunteur_lieu_travail AS co_emprunteur_lieu_travail_21, t0.is_rp AS is_rp_22, t0.is_locatif AS is_locatif_23, t0.is_terrain AS is_terrain_24, t0.is_construction AS is_construction_25, t0.is_lmnp AS is_lmnp_26, t0.budget_approximatif AS budget_approximatif_27, t0.mensualite_souhaitee AS mensualite_souhaitee_28, t0.description_projet_global AS description_projet_global_29, t0.rdv_date_heure1 AS rdv_date_heure1_30, t0.rdv_date_heure2 AS rdv_date_heure2_31, t0.rdv_dateheure3 AS rdv_dateheure3_32, t0.rdv_date_heure4 AS rdv_date_heure4_33, t0.rdv_date_heure5 AS rdv_date_heure5_34, t0.rdv_date_heure6 AS rdv_date_heure6_35, t0.description_denonciations AS description_denonciations_36, t0.description_secteur AS description_secteur_37, t0.description_criteres_particuliers AS description_criteres_particuliers_38, t0.description_criteres_generaux AS description_criteres_generaux_39, t0.description_situation_actuelle AS description_situation_actuelle_40, t0.description_programmes_proposes AS description_programmes_proposes_41, t0.emprunteur_ville AS emprunteur_ville_42, t0.emprunteur_code_postal AS emprunteur_code_postal_43, t0.coemprunteur_ville AS coemprunteur_ville_44, t0.coemprunteur_code_postal AS coemprunteur_code_postal_45, t0.token AS token_46, t0.type AS type_47, t0.statut AS statut_48, t0.afficher_nom_co_emprunteur AS afficher_nom_co_emprunteur_49, t0.afficher_nom_emprunteur AS afficher_nom_emprunteur_50, t0.auteur_id AS auteur_id_51, t0.entreprise_id AS entreprise_id_52 FROM prospect t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "jhx7g9"
]
2 0.37 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.type AS type_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.code_postal AS code_postal_6, t0.prix AS prix_7, t0.date_livraison AS date_livraison_8, t0.titre AS titre_9, t0.description AS description_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.etage AS etage_13, t0.superficie AS superficie_14, t0.terrasse AS terrasse_15, t0.orientation AS orientation_16, t0.annexes AS annexes_17, t0.livraison AS livraison_18, t0.promoteur AS promoteur_19, t0.programme AS programme_20, t0.image AS image_21, t0.jardin AS jardin_22, t0.terrasse2 AS terrasse2_23, t0.frais_notaire_type AS frais_notaire_type_24, t0.frais_notaire_inclus AS frais_notaire_inclus_25, t0.brochure AS brochure_26, t0.plan_masse AS plan_masse_27, t0.statut AS statut_28, t0.nature AS nature_29, t0.type_moteur_recherche AS type_moteur_recherche_30, t0.etage_moteur_recherche AS etage_moteur_recherche_31, t0.etat_lot AS etat_lot_32, t0.pj_progression AS pj_progression_33, t0.programme_parent_id AS programme_parent_id_34 FROM lot t0 WHERE t0.id = ?
Parameters:
[
  2249
]
3 0.25 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.description_courte AS description_courte_3, t0.ordre AS ordre_4, t0.show_public AS show_public_5, t0.est_un_plan AS est_un_plan_6, t0.est_image_admin AS est_image_admin_7, t0.lot_id AS lot_id_8, t0.programme_id AS programme_id_9, t0.piece_jointe_mere_id AS piece_jointe_mere_id_10 FROM piece_jointe t0 WHERE t0.lot_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  2249
]
4 0.21 ms
SELECT t0.id AS id_1, t0.active_proposition AS active_proposition_2, t0.dateheure AS dateheure_3, t0.lot_id AS lot_id_4, t0.prospect_id AS prospect_id_5 FROM proposition t0 WHERE t0.prospect_id = ? ORDER BY t0.dateheure DESC
Parameters:
[
  795
]
5 0.17 ms
SELECT t0.id AS id_1, t0.mode_envoi AS mode_envoi_2, t0.dateheure AS dateheure_3, t0.contenu AS contenu_4, t0.visite AS visite_5, t0.prospect_id AS prospect_id_6, t0.expediteur_id AS expediteur_id_7, t0.entreprise_id AS entreprise_id_8 FROM historique t0 WHERE t0.prospect_id = ?
Parameters:
[
  795
]
6 0.15 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.notification AS notification_5, t0.hide_account AS hide_account_6, t0.hide_entreprise AS hide_entreprise_7, t0.all_programmes AS all_programmes_8, t0.couleur AS couleur_9, t0.telephone AS telephone_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13, t0.peut_modifier AS peut_modifier_14, t0.entreprise_id AS entreprise_id_15 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
  43
]
7 0.42 ms
SELECT DATABASE()
Parameters:
[]
8 0.80 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "4y9ac_test_lk1"
]
9 0.22 ms
SELECT DATABASE()
Parameters:
[]
10 0.54 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "4y9ac_test_lk1"
]
11 0.22 ms
SELECT DATABASE()
Parameters:
[]
12 0.68 ms
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "4y9ac_test_lk1"
  "doctrine_migration_versions"
]
13 0.22 ms
SELECT DATABASE()
Parameters:
[]
14 0.73 ms
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = '4y9ac_test_lk1' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "4y9ac_test_lk1"
  "doctrine_migration_versions"
]
15 1.32 ms
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "4y9ac_test_lk1"
  "4y9ac_test_lk1"
  "doctrine_migration_versions"
]
16 0.16 ms
SELECT DATABASE()
Parameters:
[]
17 0.31 ms
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "4y9ac_test_lk1"
  "doctrine_migration_versions"
]
18 0.21 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
19 0.29 ms
SELECT DATABASE()
Parameters:
[]

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\Prospect No errors.
App\Entity\Utilisateur No errors.
App\Entity\Entreprise No errors.
App\Entity\Demande No errors.
App\Entity\Proposition No errors.
App\Entity\Impression No errors.
App\Entity\Historique
  • The association App\Entity\Historique#entreprise refers to the inverse side field App\Entity\Entreprise#historiques which does not exist.
App\Entity\Denonciation No errors.
App\Entity\InfosSuivi No errors.
App\Entity\ActionTrace No errors.
App\Entity\Typologie No errors.
App\Entity\SecteurGeographique No errors.
App\Entity\Etage No errors.
App\Entity\VilleProgramme No errors.
App\Entity\Lot No errors.
App\Entity\Programme No errors.
App\Entity\PieceJointe No errors.
App\Entity\Visite No errors.
App\Entity\Documents No errors.
App\Entity\AdresseGeocodee No errors.
App\Entity\Departement No errors.
App\Entity\Ville No errors.
Vich\UploaderBundle\Entity\File No errors.