Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.phone AS phone_2,
          p0_.whatsapp AS whatsapp_3,
          p0_.telegram AS telegram_4,
          p0_.address AS address_5,
          p0_.about AS about_6,
          p0_.age AS age_7,
          p0_.weight AS weight_8,
          p0_.height AS height_9,
          p0_.leg_size AS leg_size_10,
          p0_.bust_size AS bust_size_11,
          p0_.shape AS shape_12,
          p0_.hair_color AS hair_color_13,
          p0_.is_meeting_at_my_place AS is_meeting_at_my_place_14,
          p0_.is_visit_to_client_available AS is_visit_to_client_available_15,
          p0_.visit_to_client_price AS visit_to_client_price_16,
          p0_.is_client_paid_taxi AS is_client_paid_taxi_17,
          p0_.standart_program_price AS standart_program_price_18,
          p0_.status AS status_19,
          p0_.programs AS programs_20,
          p0_.decline_reason AS decline_reason_21,
          p0_.is_photo_with_face AS is_photo_with_face_22,
          p0_.reject_reason AS reject_reason_23,
          p0_.additional_programs AS additional_programs_24,
          p0_.address_coordinates AS address_coordinates_25,
          p0_.schedule AS schedule_26,
          p0_.meta_title AS meta_title_27,
          p0_.h1 AS h1_28,
          p0_.meta_description AS meta_description_29,
          p0_.is_indexed AS is_indexed_30,
          p0_.created_at AS created_at_31,
          p0_.active_periods AS active_periods_32,
          p0_.ordering AS ordering_33,
          p0_.is_paid AS is_paid_34,
          p0_.is_remoderation_required AS is_remoderation_required_35
        FROM
          portfolio p0_
          INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id
          INNER JOIN order_top o2_ ON p0_.id = o2_.portfolio_id
          INNER JOIN order_top o3_ ON p0_.id = o3_.portfolio_id
          INNER JOIN order_top o4_ ON p0_.id = o4_.portfolio_id
          LEFT JOIN salon s5_ ON p0_.salon_id = s5_.id
          LEFT JOIN salon s6_ ON p0_.salon_id = s6_.id
          LEFT JOIN salon s7_ ON p0_.salon_id = s7_.id
          LEFT JOIN salon s8_ ON p0_.salon_id = s8_.id
          LEFT JOIN city c9_ ON p0_.city_id = c9_.id
        WHERE
          p0_.id IN (
            SELECT
              p10_.id
            FROM
              portfolio p10_
              INNER JOIN order_top o11_ ON p10_.id = o11_.portfolio_id
              INNER JOIN order_top o12_ ON p10_.id = o12_.portfolio_id
              INNER JOIN order_top o13_ ON p10_.id = o13_.portfolio_id
              INNER JOIN order_top o14_ ON p10_.id = o14_.portfolio_id
              LEFT JOIN salon s15_ ON p10_.salon_id = s15_.id
              LEFT JOIN salon s16_ ON p10_.salon_id = s16_.id
              LEFT JOIN salon s17_ ON p10_.salon_id = s17_.id
              LEFT JOIN salon s18_ ON p10_.salon_id = s18_.id
              LEFT JOIN city c19_ ON p10_.city_id = c19_.id
            WHERE
              o11_.active_from <= ?
              AND (
                o11_.active_from + (o11_.duration || ' HOUR'):: interval
              ) >= ?
              AND o12_.active_from <= ?
              AND (
                o12_.active_from + (o12_.duration || ' HOUR'):: interval
              ) >= ?
              AND o13_.active_from <= ?
              AND (
                o13_.active_from + (o13_.duration || ' HOUR'):: interval
              ) >= ?
              AND o14_.active_from <= ?
              AND (
                o14_.active_from + (o14_.duration || ' HOUR'):: interval
              ) >= ?
              AND (
                (
                  p10_.salon_id IS NULL
                  AND p10_.status IN ('enabled')
                )
                OR s15_.status IN ('enabled')
              )
              AND (
                (
                  p10_.salon_id IS NULL
                  AND p10_.status IN ('enabled')
                )
                OR s16_.status IN ('enabled')
              )
              AND (
                (
                  p10_.salon_id IS NULL
                  AND p10_.status IN ('enabled')
                )
                OR s17_.status IN ('enabled')
              )
              AND (
                (
                  p10_.salon_id IS NULL
                  AND p10_.status IN ('enabled')
                )
                OR s18_.status IN ('enabled')
              )
              AND p10_.status = ?
              AND c19_.is_enabled = ?
          )
        ORDER BY
          o4_.active_from DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.phone AS phone_2, p0_.whatsapp AS whatsapp_3, p0_.telegram AS telegram_4, p0_.address AS address_5, p0_.about AS about_6, p0_.age AS age_7, p0_.weight AS weight_8, p0_.height AS height_9, p0_.leg_size AS leg_size_10, p0_.bust_size AS bust_size_11, p0_.shape AS shape_12, p0_.hair_color AS hair_color_13, p0_.is_meeting_at_my_place AS is_meeting_at_my_place_14, p0_.is_visit_to_client_available AS is_visit_to_client_available_15, p0_.visit_to_client_price AS visit_to_client_price_16, p0_.is_client_paid_taxi AS is_client_paid_taxi_17, p0_.standart_program_price AS standart_program_price_18, p0_.status AS status_19, p0_.programs AS programs_20, p0_.decline_reason AS decline_reason_21, p0_.is_photo_with_face AS is_photo_with_face_22, p0_.reject_reason AS reject_reason_23, p0_.additional_programs AS additional_programs_24, p0_.address_coordinates AS address_coordinates_25, p0_.schedule AS schedule_26, p0_.meta_title AS meta_title_27, p0_.h1 AS h1_28, p0_.meta_description AS meta_description_29, p0_.is_indexed AS is_indexed_30, p0_.created_at AS created_at_31, p0_.active_periods AS active_periods_32, p0_.ordering AS ordering_33, p0_.is_paid AS is_paid_34, p0_.is_remoderation_required AS is_remoderation_required_35 FROM portfolio p0_ INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id INNER JOIN order_top o2_ ON p0_.id = o2_.portfolio_id INNER JOIN order_top o3_ ON p0_.id = o3_.portfolio_id INNER JOIN order_top o4_ ON p0_.id = o4_.portfolio_id LEFT JOIN salon s5_ ON p0_.salon_id = s5_.id LEFT JOIN salon s6_ ON p0_.salon_id = s6_.id LEFT JOIN salon s7_ ON p0_.salon_id = s7_.id LEFT JOIN salon s8_ ON p0_.salon_id = s8_.id LEFT JOIN city c9_ ON p0_.city_id = c9_.id WHERE p0_.id IN (SELECT p10_.id FROM portfolio p10_ INNER JOIN order_top o11_ ON p10_.id = o11_.portfolio_id INNER JOIN order_top o12_ ON p10_.id = o12_.portfolio_id INNER JOIN order_top o13_ ON p10_.id = o13_.portfolio_id INNER JOIN order_top o14_ ON p10_.id = o14_.portfolio_id LEFT JOIN salon s15_ ON p10_.salon_id = s15_.id LEFT JOIN salon s16_ ON p10_.salon_id = s16_.id LEFT JOIN salon s17_ ON p10_.salon_id = s17_.id LEFT JOIN salon s18_ ON p10_.salon_id = s18_.id LEFT JOIN city c19_ ON p10_.city_id = c19_.id WHERE o11_.active_from <= '2026-01-12 07:34:33' AND (o11_.active_from + (o11_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND o12_.active_from <= '2026-01-12 07:34:33' AND (o12_.active_from + (o12_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND o13_.active_from <= '2026-01-12 07:34:33' AND (o13_.active_from + (o13_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND o14_.active_from <= '2026-01-12 07:34:33' AND (o14_.active_from + (o14_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s15_.status IN ('enabled')) AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s16_.status IN ('enabled')) AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s17_.status IN ('enabled')) AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s18_.status IN ('enabled')) AND p10_.status = 'enabled' AND c19_.is_enabled = 'true') ORDER BY o4_.active_from DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_36) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.name AS name_1,
      p0_.phone AS phone_2,
      p0_.whatsapp AS whatsapp_3,
      p0_.telegram AS telegram_4,
      p0_.address AS address_5,
      p0_.about AS about_6,
      p0_.age AS age_7,
      p0_.weight AS weight_8,
      p0_.height AS height_9,
      p0_.leg_size AS leg_size_10,
      p0_.bust_size AS bust_size_11,
      p0_.shape AS shape_12,
      p0_.hair_color AS hair_color_13,
      p0_.is_meeting_at_my_place AS is_meeting_at_my_place_14,
      p0_.is_visit_to_client_available AS is_visit_to_client_available_15,
      p0_.visit_to_client_price AS visit_to_client_price_16,
      p0_.is_client_paid_taxi AS is_client_paid_taxi_17,
      p0_.standart_program_price AS standart_program_price_18,
      p0_.status AS status_19,
      p0_.programs AS programs_20,
      p0_.decline_reason AS decline_reason_21,
      p0_.is_photo_with_face AS is_photo_with_face_22,
      p0_.reject_reason AS reject_reason_23,
      p0_.additional_programs AS additional_programs_24,
      p0_.address_coordinates AS address_coordinates_25,
      p0_.schedule AS schedule_26,
      p0_.meta_title AS meta_title_27,
      p0_.h1 AS h1_28,
      p0_.meta_description AS meta_description_29,
      p0_.is_indexed AS is_indexed_30,
      p0_.created_at AS created_at_31,
      p0_.active_periods AS active_periods_32,
      p0_.ordering AS ordering_33,
      p0_.is_paid AS is_paid_34,
      p0_.is_remoderation_required AS is_remoderation_required_35,
      ROW_NUMBER() OVER(
        ORDER BY
          o1_.active_from DESC
      ) AS sclr_36
    FROM
      portfolio p0_
      INNER JOIN order_top o2_ ON p0_.id = o2_.portfolio_id
      INNER JOIN order_top o3_ ON p0_.id = o3_.portfolio_id
      INNER JOIN order_top o4_ ON p0_.id = o4_.portfolio_id
      INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id
      LEFT JOIN salon s5_ ON p0_.salon_id = s5_.id
      LEFT JOIN salon s6_ ON p0_.salon_id = s6_.id
      LEFT JOIN salon s7_ ON p0_.salon_id = s7_.id
      LEFT JOIN salon s8_ ON p0_.salon_id = s8_.id
      LEFT JOIN city c9_ ON p0_.city_id = c9_.id
    WHERE
      p0_.id IN (
        SELECT
          p10_.id
        FROM
          portfolio p10_
          INNER JOIN order_top o11_ ON p10_.id = o11_.portfolio_id
          INNER JOIN order_top o12_ ON p10_.id = o12_.portfolio_id
          INNER JOIN order_top o13_ ON p10_.id = o13_.portfolio_id
          INNER JOIN order_top o14_ ON p10_.id = o14_.portfolio_id
          LEFT JOIN salon s15_ ON p10_.salon_id = s15_.id
          LEFT JOIN salon s16_ ON p10_.salon_id = s16_.id
          LEFT JOIN salon s17_ ON p10_.salon_id = s17_.id
          LEFT JOIN salon s18_ ON p10_.salon_id = s18_.id
          LEFT JOIN city c19_ ON p10_.city_id = c19_.id
        WHERE
          o11_.active_from <= ?
          AND (
            o11_.active_from + (o11_.duration || ' HOUR'):: interval
          ) >= ?
          AND o12_.active_from <= ?
          AND (
            o12_.active_from + (o12_.duration || ' HOUR'):: interval
          ) >= ?
          AND o13_.active_from <= ?
          AND (
            o13_.active_from + (o13_.duration || ' HOUR'):: interval
          ) >= ?
          AND o14_.active_from <= ?
          AND (
            o14_.active_from + (o14_.duration || ' HOUR'):: interval
          ) >= ?
          AND (
            (
              p10_.salon_id IS NULL
              AND p10_.status IN ('enabled')
            )
            OR s15_.status IN ('enabled')
          )
          AND (
            (
              p10_.salon_id IS NULL
              AND p10_.status IN ('enabled')
            )
            OR s16_.status IN ('enabled')
          )
          AND (
            (
              p10_.salon_id IS NULL
              AND p10_.status IN ('enabled')
            )
            OR s17_.status IN ('enabled')
          )
          AND (
            (
              p10_.salon_id IS NULL
              AND p10_.status IN ('enabled')
            )
            OR s18_.status IN ('enabled')
          )
          AND p10_.status = ?
          AND c19_.is_enabled = ?
      )
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  1000

SELECT DISTINCT id_0, MIN(sclr_36) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.phone AS phone_2, p0_.whatsapp AS whatsapp_3, p0_.telegram AS telegram_4, p0_.address AS address_5, p0_.about AS about_6, p0_.age AS age_7, p0_.weight AS weight_8, p0_.height AS height_9, p0_.leg_size AS leg_size_10, p0_.bust_size AS bust_size_11, p0_.shape AS shape_12, p0_.hair_color AS hair_color_13, p0_.is_meeting_at_my_place AS is_meeting_at_my_place_14, p0_.is_visit_to_client_available AS is_visit_to_client_available_15, p0_.visit_to_client_price AS visit_to_client_price_16, p0_.is_client_paid_taxi AS is_client_paid_taxi_17, p0_.standart_program_price AS standart_program_price_18, p0_.status AS status_19, p0_.programs AS programs_20, p0_.decline_reason AS decline_reason_21, p0_.is_photo_with_face AS is_photo_with_face_22, p0_.reject_reason AS reject_reason_23, p0_.additional_programs AS additional_programs_24, p0_.address_coordinates AS address_coordinates_25, p0_.schedule AS schedule_26, p0_.meta_title AS meta_title_27, p0_.h1 AS h1_28, p0_.meta_description AS meta_description_29, p0_.is_indexed AS is_indexed_30, p0_.created_at AS created_at_31, p0_.active_periods AS active_periods_32, p0_.ordering AS ordering_33, p0_.is_paid AS is_paid_34, p0_.is_remoderation_required AS is_remoderation_required_35, ROW_NUMBER() OVER(ORDER BY o1_.active_from DESC) AS sclr_36 FROM portfolio p0_ INNER JOIN order_top o2_ ON p0_.id = o2_.portfolio_id INNER JOIN order_top o3_ ON p0_.id = o3_.portfolio_id INNER JOIN order_top o4_ ON p0_.id = o4_.portfolio_id INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id LEFT JOIN salon s5_ ON p0_.salon_id = s5_.id LEFT JOIN salon s6_ ON p0_.salon_id = s6_.id LEFT JOIN salon s7_ ON p0_.salon_id = s7_.id LEFT JOIN salon s8_ ON p0_.salon_id = s8_.id LEFT JOIN city c9_ ON p0_.city_id = c9_.id WHERE p0_.id IN (SELECT p10_.id FROM portfolio p10_ INNER JOIN order_top o11_ ON p10_.id = o11_.portfolio_id INNER JOIN order_top o12_ ON p10_.id = o12_.portfolio_id INNER JOIN order_top o13_ ON p10_.id = o13_.portfolio_id INNER JOIN order_top o14_ ON p10_.id = o14_.portfolio_id LEFT JOIN salon s15_ ON p10_.salon_id = s15_.id LEFT JOIN salon s16_ ON p10_.salon_id = s16_.id LEFT JOIN salon s17_ ON p10_.salon_id = s17_.id LEFT JOIN salon s18_ ON p10_.salon_id = s18_.id LEFT JOIN city c19_ ON p10_.city_id = c19_.id WHERE o11_.active_from <= '2026-01-12 07:34:33' AND (o11_.active_from + (o11_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND o12_.active_from <= '2026-01-12 07:34:33' AND (o12_.active_from + (o12_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND o13_.active_from <= '2026-01-12 07:34:33' AND (o13_.active_from + (o13_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND o14_.active_from <= '2026-01-12 07:34:33' AND (o14_.active_from + (o14_.duration || ' HOUR')::interval) >= '2026-01-12 07:34:33' AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s15_.status IN ('enabled')) AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s16_.status IN ('enabled')) AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s17_.status IN ('enabled')) AND ((p10_.salon_id IS NULL AND p10_.status IN ('enabled')) OR s18_.status IN ('enabled')) AND p10_.status = 'enabled' AND c19_.is_enabled = 'true')) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 1000;