Query Metrics
1
Database Queries
1
Different statements
3.95 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.95 ms (100.00%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, priorite_19 FROM (SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.numero AS numero_2, p0_.voie AS voie_3, p0_.complement AS complement_4, p0_.boite_postal AS boite_postal_5, p0_.commune AS commune_6, p0_.image AS image_7, p0_.description AS description_8, p0_.analyse AS analyse_9, p0_.pc_salarie AS pc_salarie_10, p0_.date_livraison_text AS date_livraison_text_11, p0_.date_livraison_date AS date_livraison_date_12, p0_.id_programme_promoteur AS id_programme_promoteur_13, p0_.actif AS actif_14, p0_.lat AS lat_15, p0_.lng AS lng_16, p0_.regle_prix AS regle_prix_17, p0_.visible AS visible_18, p0_.priorite AS priorite_19, p0_.regle_prix_allotement AS regle_prix_allotement_20, p0_.creer_le AS creer_le_21, l1_.id AS id_22, l1_.numero_lot AS numero_lot_23, l1_.piece AS piece_24, l1_.surface AS surface_25, l1_.surface_ponderee AS surface_ponderee_26, l1_.etage AS etage_27, l1_.exposition AS exposition_28, l1_.type_bien AS type_bien_29, l1_.prix_ttc AS prix_ttc_30, l1_.prix_ht AS prix_ht_31, l1_.loyer AS loyer_32, l1_.nb_option AS nb_option_33, l1_.allotement AS allotement_34, l1_.imported_at AS imported_at_35, l1_.actif AS actif_36, r2_.code_postal AS code_postal_37, r2_.code_departement AS code_departement_38, r2_.nom_departement AS nom_departement_39, r2_.code_region AS code_region_40, r2_.nom_region AS nom_region_41 FROM Programme p0_ LEFT JOIN Lot l1_ ON p0_.id = l1_.programme_id LEFT JOIN RegionDepCP r2_ ON p0_.code_postal_id = r2_.code_postal INNER JOIN Promoteur p3_ ON p0_.promoteur_id = p3_.id LEFT JOIN lot_annexe l5_ ON l1_.id = l5_.lot_id LEFT JOIN Annexe a4_ ON a4_.id = l5_.annexe_id LEFT JOIN lot_fiscalite l7_ ON l1_.id = l7_.lot_id LEFT JOIN Fiscalite f6_ ON f6_.id = l7_.fiscalite_id LEFT JOIN lot_options l8_ ON l1_.active_option = l8_.id WHERE (p0_.actif = ? AND l1_.actif = ?) AND l1_.allotement = ? AND p0_.priorite >= ? AND r2_.code_postal IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result_inner ORDER BY priorite_19 DESC) dctrn_result LIMIT 50 OFFSET 100
Parameters:
[ 1 1 0 1 "31100" "31200" "31300" "31400" "31500" "31000" "31770" "31170" "31600" "31700" "31830" "31270" "31130" "31520" "31240" "31470" "31800" "31650" "31320" "31240" "31250" "31120" "31190" "31780" "31270" "31470" "31490" "31820" "31270" "31330" "31140" "31600" "31140" "31880" "31840" "31750" "31700" "31140" "31340" "31620" "31620" "31600" "31790" "31700" "31390" "31150" "31150" "31860" "31330" "31470" "31220" "31860" "31700" "31620" "31290" "31670" "31120" "31140" "31180" "31120" "31320" "31850" "31150" "31600" "31370" "31660" "31590" "31380" "31560" "31450" "31310" "31840" "31150" "31210" "31140" "31370" "31140" "31410" "31180" "31110" "31410" "31490" "31410" "31550" "31810" "31120" "31310" "31150" "31280" "31870" "31450" "31660" "31460" "31810" "31220" "31560" "31600" "31180" "31190" "31450" "31450" "31570" "31120" "31470" "31700" "31260" "31320" "31530" "31600" "31230" "31410" "31180" "31620" "31790" "31140" "31380" "31410" "31130" "31430" "31570" "31350" "31800" "31620" "31380" "31530" "31870" "31280" "31330" "31210" "31650" "31620" "31800" "31600" "31530" "31290" "31290" "31540" "31340" "31650" "31290" "31450" "31850" "31330" "31550" "31420" "31380" "31450" "31600" "31410" "31560" "31320" "31530" "31380" "31280" ] |
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Programme | No errors. |
| App\Entity\Lot | No errors. |
| App\Entity\RegionDepCP | No errors. |
| App\Entity\Promoteur | No errors. |
| App\Entity\Annexe | No errors. |
| App\Entity\Fiscalite | No errors. |
| App\Entity\Option | No errors. |