Symfony Profiler

SELECT
  portfolio.id
FROM
  portfolio
  LEFT JOIN salon ON salon.id = portfolio.salon_id
WHERE
  (active_periods ->> ?):: integer & (
    1 << (3 - ?)
  ) <> 0
  AND (
    (
      portfolio.salon_id IS NULL
      AND portfolio.status IN('enabled', 're-moderation')
    )
    OR (
      salon.status IN('enabled', 're-moderation')
      AND portfolio.status IN('enabled', 're-moderation')
    )
  )
  AND portfolio.is_paid = true

SELECT portfolio.id FROM portfolio
                LEFT JOIN salon ON salon.id = portfolio.salon_id WHERE (active_periods->>'monday')::integer & (1 << (3 - 0)) <> 0
                AND ((portfolio.salon_id IS NULL AND portfolio.status IN('enabled', 're-moderation')) OR (salon.status IN('enabled', 're-moderation') AND portfolio.status IN('enabled', 're-moderation')))
                AND portfolio.is_paid = true;

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,
  p0_.account_id AS account_id_36,
  p0_.main_photo_id AS main_photo_id_37,
  p0_.area_id AS area_id_38,
  p0_.metro_id AS metro_id_39,
  p0_.salon_id AS salon_id_40,
  p0_.verification_photo_id AS verification_photo_id_41,
  p0_.verification_photo2_id AS verification_photo2_id_42,
  p0_.video_id AS video_id_43,
  p0_.city_id AS city_id_44,
  p0_.video2_id AS video2_id_45,
  p0_.video3_id AS video3_id_46,
  p0_.video_cover_id AS video_cover_id_47,
  p0_.video_cover2_id AS video_cover2_id_48,
  p0_.video_cover3_id AS video_cover3_id_49
FROM
  portfolio p0_
  INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id
WHERE
  o1_.active_from <= ?
  AND (
    o1_.active_from + (o1_.duration || ' HOUR'):: interval
  ) >= ?

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, p0_.account_id AS account_id_36, p0_.main_photo_id AS main_photo_id_37, p0_.area_id AS area_id_38, p0_.metro_id AS metro_id_39, p0_.salon_id AS salon_id_40, p0_.verification_photo_id AS verification_photo_id_41, p0_.verification_photo2_id AS verification_photo2_id_42, p0_.video_id AS video_id_43, p0_.city_id AS city_id_44, p0_.video2_id AS video2_id_45, p0_.video3_id AS video3_id_46, p0_.video_cover_id AS video_cover_id_47, p0_.video_cover2_id AS video_cover2_id_48, p0_.video_cover3_id AS video_cover3_id_49 FROM portfolio p0_ INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id WHERE o1_.active_from <= '2026-01-12 07:44:24' AND (o1_.active_from + (o1_.duration || ' HOUR')::interval) >= '2026-01-12 07:44:24';

SELECT
  portfolio.id
FROM
  portfolio
  LEFT JOIN salon ON salon.id = portfolio.salon_id
WHERE
  (active_periods ->> ?):: integer & (
    1 << (3 - ?)
  ) <> 0
  AND (
    (
      portfolio.salon_id IS NULL
      AND portfolio.status IN('enabled', 're-moderation')
    )
    OR (
      salon.status IN('enabled', 're-moderation')
      AND portfolio.status IN('enabled', 're-moderation')
    )
  )
  AND portfolio.is_paid = true

SELECT portfolio.id FROM portfolio
                LEFT JOIN salon ON salon.id = portfolio.salon_id WHERE (active_periods->>'monday')::integer & (1 << (3 - 0)) <> 0
                AND ((portfolio.salon_id IS NULL AND portfolio.status IN('enabled', 're-moderation')) OR (salon.status IN('enabled', 're-moderation') AND portfolio.status IN('enabled', 're-moderation')))
                AND portfolio.is_paid = true;

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,
  p0_.account_id AS account_id_36,
  p0_.main_photo_id AS main_photo_id_37,
  p0_.area_id AS area_id_38,
  p0_.metro_id AS metro_id_39,
  p0_.salon_id AS salon_id_40,
  p0_.verification_photo_id AS verification_photo_id_41,
  p0_.verification_photo2_id AS verification_photo2_id_42,
  p0_.video_id AS video_id_43,
  p0_.city_id AS city_id_44,
  p0_.video2_id AS video2_id_45,
  p0_.video3_id AS video3_id_46,
  p0_.video_cover_id AS video_cover_id_47,
  p0_.video_cover2_id AS video_cover2_id_48,
  p0_.video_cover3_id AS video_cover3_id_49
FROM
  portfolio p0_
  INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id
WHERE
  o1_.active_from <= ?
  AND (
    o1_.active_from + (o1_.duration || ' HOUR'):: interval
  ) >= ?

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, p0_.account_id AS account_id_36, p0_.main_photo_id AS main_photo_id_37, p0_.area_id AS area_id_38, p0_.metro_id AS metro_id_39, p0_.salon_id AS salon_id_40, p0_.verification_photo_id AS verification_photo_id_41, p0_.verification_photo2_id AS verification_photo2_id_42, p0_.video_id AS video_id_43, p0_.city_id AS city_id_44, p0_.video2_id AS video2_id_45, p0_.video3_id AS video3_id_46, p0_.video_cover_id AS video_cover_id_47, p0_.video_cover2_id AS video_cover2_id_48, p0_.video_cover3_id AS video_cover3_id_49 FROM portfolio p0_ INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id WHERE o1_.active_from <= '2026-01-12 07:44:25' AND (o1_.active_from + (o1_.duration || ' HOUR')::interval) >= '2026-01-12 07:44:25';

SELECT
  portfolio.id
FROM
  portfolio
  LEFT JOIN salon ON salon.id = portfolio.salon_id
WHERE
  (active_periods ->> ?):: integer & (
    1 << (3 - ?)
  ) <> 0
  AND (
    (
      portfolio.salon_id IS NULL
      AND portfolio.status IN('enabled', 're-moderation')
    )
    OR (
      salon.status IN('enabled', 're-moderation')
      AND portfolio.status IN('enabled', 're-moderation')
    )
  )
  AND portfolio.is_paid = true

SELECT portfolio.id FROM portfolio
                LEFT JOIN salon ON salon.id = portfolio.salon_id WHERE (active_periods->>'monday')::integer & (1 << (3 - 0)) <> 0
                AND ((portfolio.salon_id IS NULL AND portfolio.status IN('enabled', 're-moderation')) OR (salon.status IN('enabled', 're-moderation') AND portfolio.status IN('enabled', 're-moderation')))
                AND portfolio.is_paid = true;

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,
  p0_.account_id AS account_id_36,
  p0_.main_photo_id AS main_photo_id_37,
  p0_.area_id AS area_id_38,
  p0_.metro_id AS metro_id_39,
  p0_.salon_id AS salon_id_40,
  p0_.verification_photo_id AS verification_photo_id_41,
  p0_.verification_photo2_id AS verification_photo2_id_42,
  p0_.video_id AS video_id_43,
  p0_.city_id AS city_id_44,
  p0_.video2_id AS video2_id_45,
  p0_.video3_id AS video3_id_46,
  p0_.video_cover_id AS video_cover_id_47,
  p0_.video_cover2_id AS video_cover2_id_48,
  p0_.video_cover3_id AS video_cover3_id_49
FROM
  portfolio p0_
  INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id
WHERE
  o1_.active_from <= ?
  AND (
    o1_.active_from + (o1_.duration || ' HOUR'):: interval
  ) >= ?

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, p0_.account_id AS account_id_36, p0_.main_photo_id AS main_photo_id_37, p0_.area_id AS area_id_38, p0_.metro_id AS metro_id_39, p0_.salon_id AS salon_id_40, p0_.verification_photo_id AS verification_photo_id_41, p0_.verification_photo2_id AS verification_photo2_id_42, p0_.video_id AS video_id_43, p0_.city_id AS city_id_44, p0_.video2_id AS video2_id_45, p0_.video3_id AS video3_id_46, p0_.video_cover_id AS video_cover_id_47, p0_.video_cover2_id AS video_cover2_id_48, p0_.video_cover3_id AS video_cover3_id_49 FROM portfolio p0_ INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id WHERE o1_.active_from <= '2026-01-12 07:44:25' AND (o1_.active_from + (o1_.duration || ' HOUR')::interval) >= '2026-01-12 07:44:25';

SELECT
  portfolio.id
FROM
  portfolio
  LEFT JOIN salon ON salon.id = portfolio.salon_id
WHERE
  (active_periods ->> ?):: integer & (
    1 << (3 - ?)
  ) <> 0
  AND (
    (
      portfolio.salon_id IS NULL
      AND portfolio.status IN('enabled', 're-moderation')
    )
    OR (
      salon.status IN('enabled', 're-moderation')
      AND portfolio.status IN('enabled', 're-moderation')
    )
  )
  AND portfolio.is_paid = true

SELECT portfolio.id FROM portfolio
                LEFT JOIN salon ON salon.id = portfolio.salon_id WHERE (active_periods->>'monday')::integer & (1 << (3 - 0)) <> 0
                AND ((portfolio.salon_id IS NULL AND portfolio.status IN('enabled', 're-moderation')) OR (salon.status IN('enabled', 're-moderation') AND portfolio.status IN('enabled', 're-moderation')))
                AND portfolio.is_paid = true;

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,
  p0_.account_id AS account_id_36,
  p0_.main_photo_id AS main_photo_id_37,
  p0_.area_id AS area_id_38,
  p0_.metro_id AS metro_id_39,
  p0_.salon_id AS salon_id_40,
  p0_.verification_photo_id AS verification_photo_id_41,
  p0_.verification_photo2_id AS verification_photo2_id_42,
  p0_.video_id AS video_id_43,
  p0_.city_id AS city_id_44,
  p0_.video2_id AS video2_id_45,
  p0_.video3_id AS video3_id_46,
  p0_.video_cover_id AS video_cover_id_47,
  p0_.video_cover2_id AS video_cover2_id_48,
  p0_.video_cover3_id AS video_cover3_id_49
FROM
  portfolio p0_
  INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id
WHERE
  o1_.active_from <= ?
  AND (
    o1_.active_from + (o1_.duration || ' HOUR'):: interval
  ) >= ?

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, p0_.account_id AS account_id_36, p0_.main_photo_id AS main_photo_id_37, p0_.area_id AS area_id_38, p0_.metro_id AS metro_id_39, p0_.salon_id AS salon_id_40, p0_.verification_photo_id AS verification_photo_id_41, p0_.verification_photo2_id AS verification_photo2_id_42, p0_.video_id AS video_id_43, p0_.city_id AS city_id_44, p0_.video2_id AS video2_id_45, p0_.video3_id AS video3_id_46, p0_.video_cover_id AS video_cover_id_47, p0_.video_cover2_id AS video_cover2_id_48, p0_.video_cover3_id AS video_cover3_id_49 FROM portfolio p0_ INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id WHERE o1_.active_from <= '2026-01-12 07:44:25' AND (o1_.active_from + (o1_.duration || ' HOUR')::interval) >= '2026-01-12 07:44:25';

SELECT
  portfolio.id
FROM
  portfolio
  LEFT JOIN salon ON salon.id = portfolio.salon_id
WHERE
  (active_periods ->> ?):: integer & (
    1 << (3 - ?)
  ) <> 0
  AND (
    (
      portfolio.salon_id IS NULL
      AND portfolio.status IN('enabled', 're-moderation')
    )
    OR (
      salon.status IN('enabled', 're-moderation')
      AND portfolio.status IN('enabled', 're-moderation')
    )
  )
  AND portfolio.is_paid = true

SELECT portfolio.id FROM portfolio
                LEFT JOIN salon ON salon.id = portfolio.salon_id WHERE (active_periods->>'monday')::integer & (1 << (3 - 0)) <> 0
                AND ((portfolio.salon_id IS NULL AND portfolio.status IN('enabled', 're-moderation')) OR (salon.status IN('enabled', 're-moderation') AND portfolio.status IN('enabled', 're-moderation')))
                AND portfolio.is_paid = true;

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,
  p0_.account_id AS account_id_36,
  p0_.main_photo_id AS main_photo_id_37,
  p0_.area_id AS area_id_38,
  p0_.metro_id AS metro_id_39,
  p0_.salon_id AS salon_id_40,
  p0_.verification_photo_id AS verification_photo_id_41,
  p0_.verification_photo2_id AS verification_photo2_id_42,
  p0_.video_id AS video_id_43,
  p0_.city_id AS city_id_44,
  p0_.video2_id AS video2_id_45,
  p0_.video3_id AS video3_id_46,
  p0_.video_cover_id AS video_cover_id_47,
  p0_.video_cover2_id AS video_cover2_id_48,
  p0_.video_cover3_id AS video_cover3_id_49
FROM
  portfolio p0_
  INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id
WHERE
  o1_.active_from <= ?
  AND (
    o1_.active_from + (o1_.duration || ' HOUR'):: interval
  ) >= ?

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, p0_.account_id AS account_id_36, p0_.main_photo_id AS main_photo_id_37, p0_.area_id AS area_id_38, p0_.metro_id AS metro_id_39, p0_.salon_id AS salon_id_40, p0_.verification_photo_id AS verification_photo_id_41, p0_.verification_photo2_id AS verification_photo2_id_42, p0_.video_id AS video_id_43, p0_.city_id AS city_id_44, p0_.video2_id AS video2_id_45, p0_.video3_id AS video3_id_46, p0_.video_cover_id AS video_cover_id_47, p0_.video_cover2_id AS video_cover2_id_48, p0_.video_cover3_id AS video_cover3_id_49 FROM portfolio p0_ INNER JOIN order_top o1_ ON p0_.id = o1_.portfolio_id WHERE o1_.active_from <= '2026-01-12 07:44:26' AND (o1_.active_from + (o1_.duration || ' HOUR')::interval) >= '2026-01-12 07:44:26';