Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 13
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• JMS Serializer 0 + 0
• Configuration

Query Metrics

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 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 >= ?) dctrn_result_inner ORDER BY priorite_19 DESC) dctrn_result LIMIT 50 OFFSET 800

[
  1
  1
  0
  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
        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 >= ?
      ) dctrn_result_inner
    ORDER BY
      priorite_19 DESC
  ) dctrn_result
LIMIT
  50
OFFSET
  800

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 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 = 1 AND l1_.actif = 1) AND l1_.allotement = 0 AND p0_.priorite >= 1) dctrn_result_inner ORDER BY priorite_19 DESC) dctrn_result LIMIT 50 OFFSET 800;