Symfony Profiler

SELECT
  a0_.advertisement_id AS sclr_0
FROM
  advertisement_premium a0_
  INNER JOIN advertisement a1_ ON a0_.advertisement_id = a1_.id
  LEFT JOIN package p2_ ON a1_.id = p2_.advertisement_id
  LEFT JOIN transaction t3_ ON p2_.transaction_id = t3_.id
WHERE
  a0_.expiration > ?
  AND (
    (
      a1_.is_admin = 1
      AND a1_.is_visible = 1
    )
    OR (
      (
        t3_.payment_status_id = 2
        OR t3_.payment_status_id = 3
      )
      AND a1_.date_of_expiration > ?
      AND a1_.is_visible = 1
    )
  )

SELECT a0_.advertisement_id AS sclr_0 FROM advertisement_premium a0_ INNER JOIN advertisement a1_ ON a0_.advertisement_id = a1_.id LEFT JOIN package p2_ ON a1_.id = p2_.advertisement_id LEFT JOIN transaction t3_ ON p2_.transaction_id = t3_.id WHERE a0_.expiration > '2025-05-18 07:47:23' AND ((a1_.is_admin = 1 AND a1_.is_visible = 1) OR ((t3_.payment_status_id = 2 OR t3_.payment_status_id = 3) AND a1_.date_of_expiration > '2025-05-18 07:47:23' AND a1_.is_visible = 1));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.price AS price_4,
  t0.charge AS charge_5,
  t0.deposit AS deposit_6,
  t0.address AS address_7,
  t0.floor_area AS floor_area_8,
  t0.floor AS floor_9,
  t0.floors_of_property AS floors_of_property_10,
  t0.energy_class AS energy_class_11,
  t0.activities_nearby AS activities_nearby_12,
  t0.date_of_expiration AS date_of_expiration_13,
  t0.contact AS contact_14,
  t0.page_type AS page_type_15,
  t0.keywords AS keywords_16,
  t0.description AS description_17,
  t0.latitude AS latitude_18,
  t0.longitude AS longitude_19,
  t0.seo_title AS seo_title_20,
  t0.seo_description AS seo_description_21,
  t0.land_size AS land_size_22,
  t0.balcony_area AS balcony_area_23,
  t0.video AS video_24,
  t0.vrtour AS vrtour_25,
  t0.is_admin AS is_admin_26,
  t0.is_visible AS is_visible_27,
  t0.uniqid AS uniqid_28,
  t0.ip_address AS ip_address_29,
  t0.date_created AS date_created_30,
  t0.external_url AS external_url_31,
  t0.approved AS approved_32,
  t0.deleted_by_user AS deleted_by_user_33,
  t0.draft AS draft_34,
  t0.deleted_from_external AS deleted_from_external_35,
  t0.last_check AS last_check_36,
  t0.contact_disabled AS contact_disabled_37,
  t0.property_type_id AS property_type_id_38,
  t0.advertisement_type_id AS advertisement_type_id_39,
  t0.user_id AS user_id_40,
  t0.advertisement_status_id AS advertisement_status_id_41,
  t0.offering_type_id AS offering_type_id_42,
  t0.building_type_id AS building_type_id_43,
  t0.building_materials_id AS building_materials_id_44,
  t0.property_equipment_description_id AS property_equipment_description_id_45,
  t0.property_time_of_rent_id AS property_time_of_rent_id_46,
  t0.heating_id AS heating_id_47,
  t0.land_type_id AS land_type_id_48,
  t0.type_of_ownership_id AS type_of_ownership_id_49,
  t0.floor_in_house_id AS floor_in_house_id_50,
  t0.world_orientation_id AS world_orientation_id_51,
  t0.property_condition_id AS property_condition_id_52,
  t0.property_age_id AS property_age_id_53,
  t0.visibility_id AS visibility_id_54,
  t0.city_id AS city_id_55,
  t0.category_id AS category_id_56
FROM
  advertisement t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.price AS price_4, t0.charge AS charge_5, t0.deposit AS deposit_6, t0.address AS address_7, t0.floor_area AS floor_area_8, t0.floor AS floor_9, t0.floors_of_property AS floors_of_property_10, t0.energy_class AS energy_class_11, t0.activities_nearby AS activities_nearby_12, t0.date_of_expiration AS date_of_expiration_13, t0.contact AS contact_14, t0.page_type AS page_type_15, t0.keywords AS keywords_16, t0.description AS description_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.seo_title AS seo_title_20, t0.seo_description AS seo_description_21, t0.land_size AS land_size_22, t0.balcony_area AS balcony_area_23, t0.video AS video_24, t0.vrtour AS vrtour_25, t0.is_admin AS is_admin_26, t0.is_visible AS is_visible_27, t0.uniqid AS uniqid_28, t0.ip_address AS ip_address_29, t0.date_created AS date_created_30, t0.external_url AS external_url_31, t0.approved AS approved_32, t0.deleted_by_user AS deleted_by_user_33, t0.draft AS draft_34, t0.deleted_from_external AS deleted_from_external_35, t0.last_check AS last_check_36, t0.contact_disabled AS contact_disabled_37, t0.property_type_id AS property_type_id_38, t0.advertisement_type_id AS advertisement_type_id_39, t0.user_id AS user_id_40, t0.advertisement_status_id AS advertisement_status_id_41, t0.offering_type_id AS offering_type_id_42, t0.building_type_id AS building_type_id_43, t0.building_materials_id AS building_materials_id_44, t0.property_equipment_description_id AS property_equipment_description_id_45, t0.property_time_of_rent_id AS property_time_of_rent_id_46, t0.heating_id AS heating_id_47, t0.land_type_id AS land_type_id_48, t0.type_of_ownership_id AS type_of_ownership_id_49, t0.floor_in_house_id AS floor_in_house_id_50, t0.world_orientation_id AS world_orientation_id_51, t0.property_condition_id AS property_condition_id_52, t0.property_age_id AS property_age_id_53, t0.visibility_id AS visibility_id_54, t0.city_id AS city_id_55, t0.category_id AS category_id_56 FROM advertisement t0 WHERE t0.id IN (24536, 25139, 106384, 131767, 151354, 154882, 154883);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.description AS description_5,
  t0.img AS img_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8,
  t0.slug AS slug_9
FROM
  city t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.description AS description_5, t0.img AS img_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.slug AS slug_9 FROM city t0 WHERE t0.slug = 'praha' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.url AS url_2,
  a0_.price AS price_3,
  a0_.charge AS charge_4,
  a0_.deposit AS deposit_5,
  a0_.address AS address_6,
  a0_.floor_area AS floor_area_7,
  a0_.floor AS floor_8,
  a0_.floors_of_property AS floors_of_property_9,
  a0_.energy_class AS energy_class_10,
  a0_.activities_nearby AS activities_nearby_11,
  a0_.date_of_expiration AS date_of_expiration_12,
  a0_.contact AS contact_13,
  a0_.page_type AS page_type_14,
  a0_.keywords AS keywords_15,
  a0_.description AS description_16,
  a0_.latitude AS latitude_17,
  a0_.longitude AS longitude_18,
  a0_.seo_title AS seo_title_19,
  a0_.seo_description AS seo_description_20,
  a0_.land_size AS land_size_21,
  a0_.balcony_area AS balcony_area_22,
  a0_.video AS video_23,
  a0_.vrtour AS vrtour_24,
  a0_.is_admin AS is_admin_25,
  a0_.is_visible AS is_visible_26,
  a0_.uniqid AS uniqid_27,
  a0_.ip_address AS ip_address_28,
  a0_.date_created AS date_created_29,
  a0_.external_url AS external_url_30,
  a0_.approved AS approved_31,
  a0_.deleted_by_user AS deleted_by_user_32,
  a0_.draft AS draft_33,
  a0_.deleted_from_external AS deleted_from_external_34,
  a0_.last_check AS last_check_35,
  a0_.contact_disabled AS contact_disabled_36,
  a0_.property_type_id AS property_type_id_37,
  a0_.advertisement_type_id AS advertisement_type_id_38,
  a0_.user_id AS user_id_39,
  a0_.advertisement_status_id AS advertisement_status_id_40,
  a0_.offering_type_id AS offering_type_id_41,
  a0_.building_type_id AS building_type_id_42,
  a0_.building_materials_id AS building_materials_id_43,
  a0_.property_equipment_description_id AS property_equipment_description_id_44,
  a0_.property_time_of_rent_id AS property_time_of_rent_id_45,
  a0_.heating_id AS heating_id_46,
  a0_.land_type_id AS land_type_id_47,
  a0_.type_of_ownership_id AS type_of_ownership_id_48,
  a0_.floor_in_house_id AS floor_in_house_id_49,
  a0_.world_orientation_id AS world_orientation_id_50,
  a0_.property_condition_id AS property_condition_id_51,
  a0_.property_age_id AS property_age_id_52,
  a0_.visibility_id AS visibility_id_53,
  a0_.city_id AS city_id_54,
  a0_.category_id AS category_id_55
FROM
  advertisement a0_
  LEFT JOIN package p1_ ON a0_.id = p1_.advertisement_id
  LEFT JOIN transaction t2_ ON p1_.transaction_id = t2_.id
WHERE
  a0_.city_id = ?
  AND (
    (
      a0_.is_admin = 1
      AND a0_.date_of_expiration > ?
      AND a0_.is_visible = 1
      AND a0_.draft = 0
      AND a0_.approved = 1
    )
    OR (
      (
        t2_.payment_status_id = 2
        OR t2_.payment_status_id = 3
      )
      AND a0_.date_of_expiration > ?
      AND a0_.is_visible = 1
      AND a0_.draft = 0
      AND a0_.approved = 1
    )
  )
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.url AS url_2, a0_.price AS price_3, a0_.charge AS charge_4, a0_.deposit AS deposit_5, a0_.address AS address_6, a0_.floor_area AS floor_area_7, a0_.floor AS floor_8, a0_.floors_of_property AS floors_of_property_9, a0_.energy_class AS energy_class_10, a0_.activities_nearby AS activities_nearby_11, a0_.date_of_expiration AS date_of_expiration_12, a0_.contact AS contact_13, a0_.page_type AS page_type_14, a0_.keywords AS keywords_15, a0_.description AS description_16, a0_.latitude AS latitude_17, a0_.longitude AS longitude_18, a0_.seo_title AS seo_title_19, a0_.seo_description AS seo_description_20, a0_.land_size AS land_size_21, a0_.balcony_area AS balcony_area_22, a0_.video AS video_23, a0_.vrtour AS vrtour_24, a0_.is_admin AS is_admin_25, a0_.is_visible AS is_visible_26, a0_.uniqid AS uniqid_27, a0_.ip_address AS ip_address_28, a0_.date_created AS date_created_29, a0_.external_url AS external_url_30, a0_.approved AS approved_31, a0_.deleted_by_user AS deleted_by_user_32, a0_.draft AS draft_33, a0_.deleted_from_external AS deleted_from_external_34, a0_.last_check AS last_check_35, a0_.contact_disabled AS contact_disabled_36, a0_.property_type_id AS property_type_id_37, a0_.advertisement_type_id AS advertisement_type_id_38, a0_.user_id AS user_id_39, a0_.advertisement_status_id AS advertisement_status_id_40, a0_.offering_type_id AS offering_type_id_41, a0_.building_type_id AS building_type_id_42, a0_.building_materials_id AS building_materials_id_43, a0_.property_equipment_description_id AS property_equipment_description_id_44, a0_.property_time_of_rent_id AS property_time_of_rent_id_45, a0_.heating_id AS heating_id_46, a0_.land_type_id AS land_type_id_47, a0_.type_of_ownership_id AS type_of_ownership_id_48, a0_.floor_in_house_id AS floor_in_house_id_49, a0_.world_orientation_id AS world_orientation_id_50, a0_.property_condition_id AS property_condition_id_51, a0_.property_age_id AS property_age_id_52, a0_.visibility_id AS visibility_id_53, a0_.city_id AS city_id_54, a0_.category_id AS category_id_55 FROM advertisement a0_ LEFT JOIN package p1_ ON a0_.id = p1_.advertisement_id LEFT JOIN transaction t2_ ON p1_.transaction_id = t2_.id WHERE a0_.city_id = 79 AND ((a0_.is_admin = 1 AND a0_.date_of_expiration > '2025-05-18 07:47:23' AND a0_.is_visible = 1 AND a0_.draft = 0 AND a0_.approved = 1) OR ((t2_.payment_status_id = 2 OR t2_.payment_status_id = 3) AND a0_.date_of_expiration > '2025-05-18 07:47:23' AND a0_.is_visible = 1 AND a0_.draft = 0 AND a0_.approved = 1)) ORDER BY a0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 20827;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154883;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 17983;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154873;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154872;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154870;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154746;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154745;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154744;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154743;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154742;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154739;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154738;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154736;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154734;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154694;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154686;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154622;

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.advertisement_id AS advertisement_id_4
FROM
  advertisement_premium t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.expiration_homepage AS expiration_homepage_3, t0.advertisement_id AS advertisement_id_4 FROM advertisement_premium t0 WHERE t0.advertisement_id = 154618;