Symfony Profiler

SELECT
  c0_.name AS name_0,
  COUNT(a1_.id) AS sclr_1,
  c0_.img AS img_2
FROM
  advertisement a1_
  INNER JOIN city c0_ ON a1_.city_id = c0_.id
  LEFT JOIN package p2_ ON a1_.id = p2_.advertisement_id
  LEFT JOIN transaction t3_ ON p2_.transaction_id = t3_.id
WHERE
  (
    a1_.is_admin = 1
    AND a1_.date_of_expiration > ?
    AND a1_.is_visible = 1
    AND a1_.draft = 0
    AND a1_.approved = 1
  )
  OR (
    (
      t3_.payment_status_id = 2
      OR t3_.payment_status_id = 3
    )
    AND a1_.date_of_expiration > ?
    AND a1_.is_visible = 1
    AND a1_.draft = 0
    AND a1_.approved = 1
  )
GROUP BY
  c0_.id
ORDER BY
  sclr_1 DESC
LIMIT
  4

SELECT c0_.name AS name_0, COUNT(a1_.id) AS sclr_1, c0_.img AS img_2 FROM advertisement a1_ INNER JOIN city c0_ ON a1_.city_id = c0_.id LEFT JOIN package p2_ ON a1_.id = p2_.advertisement_id LEFT JOIN transaction t3_ ON p2_.transaction_id = t3_.id WHERE (a1_.is_admin = 1 AND a1_.date_of_expiration > '2025-08-23 06:56:31' AND a1_.is_visible = 1 AND a1_.draft = 0 AND a1_.approved = 1) OR ((t3_.payment_status_id = 2 OR t3_.payment_status_id = 3) AND a1_.date_of_expiration > '2025-08-23 06:56:31' AND a1_.is_visible = 1 AND a1_.draft = 0 AND a1_.approved = 1) GROUP BY c0_.id ORDER BY sclr_1 DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.ipaddress AS ipaddress_2
FROM
  black_list_ip t0
WHERE
  t0.ipaddress = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ipaddress AS ipaddress_2 FROM black_list_ip t0 WHERE t0.ipaddress = '108.162.241.67' LIMIT 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_homepage > ?
  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
    )
  )
ORDER BY
  a1_.date_created DESC

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_homepage > '2025-08-23 06:56:31' 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-08-23 06:56:31' AND a1_.is_visible = 1)) ORDER BY a1_.date_created DESC;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.url AS url_3,
  t0.main AS main_4,
  t0.position AS position_5,
  t0.is_visible AS is_visible_6,
  t0.advertisement_id AS advertisement_id_7
FROM
  advertisement_image t0
WHERE
  t0.advertisement_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.url AS url_3, t0.main AS main_4, t0.position AS position_5, t0.is_visible AS is_visible_6, t0.advertisement_id AS advertisement_id_7 FROM advertisement_image t0 WHERE t0.advertisement_id = 24536;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  advertisement_disposition t0
  INNER JOIN advertisement_advertisement_disposition ON t0.id = advertisement_advertisement_disposition.advertisement_disposition_id
WHERE
  advertisement_advertisement_disposition.advertisement_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM advertisement_disposition t0 INNER JOIN advertisement_advertisement_disposition ON t0.id = advertisement_advertisement_disposition.advertisement_disposition_id WHERE advertisement_advertisement_disposition.advertisement_id = 24536;

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.need_check AS need_check_38,
  t0.property_type_id AS property_type_id_39,
  t0.advertisement_type_id AS advertisement_type_id_40,
  t0.user_id AS user_id_41,
  t0.advertisement_status_id AS advertisement_status_id_42,
  t0.offering_type_id AS offering_type_id_43,
  t0.building_type_id AS building_type_id_44,
  t0.building_materials_id AS building_materials_id_45,
  t0.property_equipment_description_id AS property_equipment_description_id_46,
  t0.property_time_of_rent_id AS property_time_of_rent_id_47,
  t0.heating_id AS heating_id_48,
  t0.land_type_id AS land_type_id_49,
  t0.type_of_ownership_id AS type_of_ownership_id_50,
  t0.floor_in_house_id AS floor_in_house_id_51,
  t0.world_orientation_id AS world_orientation_id_52,
  t0.property_condition_id AS property_condition_id_53,
  t0.property_age_id AS property_age_id_54,
  t0.visibility_id AS visibility_id_55,
  t0.city_id AS city_id_56,
  t0.category_id AS category_id_57
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.need_check AS need_check_38, t0.property_type_id AS property_type_id_39, t0.advertisement_type_id AS advertisement_type_id_40, t0.user_id AS user_id_41, t0.advertisement_status_id AS advertisement_status_id_42, t0.offering_type_id AS offering_type_id_43, t0.building_type_id AS building_type_id_44, t0.building_materials_id AS building_materials_id_45, t0.property_equipment_description_id AS property_equipment_description_id_46, t0.property_time_of_rent_id AS property_time_of_rent_id_47, t0.heating_id AS heating_id_48, t0.land_type_id AS land_type_id_49, t0.type_of_ownership_id AS type_of_ownership_id_50, t0.floor_in_house_id AS floor_in_house_id_51, t0.world_orientation_id AS world_orientation_id_52, t0.property_condition_id AS property_condition_id_53, t0.property_age_id AS property_age_id_54, t0.visibility_id AS visibility_id_55, t0.city_id AS city_id_56, t0.category_id AS category_id_57 FROM advertisement t0 WHERE t0.id IN (154917, 25139, 24536);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.content AS content_4,
  t0.created_at AS created_at_5,
  t0.edited_at AS edited_at_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.image AS image_9,
  t0.is_blog AS is_blog_10,
  t0.blog_preview AS blog_preview_11,
  t0.is_visible AS is_visible_12,
  t0.blog_category_id AS blog_category_id_13
FROM
  page t0
WHERE
  t0.is_blog = ?
  AND t0.is_visible = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.title AS title_7, t0.description AS description_8, t0.image AS image_9, t0.is_blog AS is_blog_10, t0.blog_preview AS blog_preview_11, t0.is_visible AS is_visible_12, t0.blog_category_id AS blog_category_id_13 FROM page t0 WHERE t0.is_blog = 1 AND t0.is_visible = 1;

SELECT
  t0.id AS id_1,
  t0.key AS key_2,
  t0.name AS name_3,
  t0.value AS value_4
FROM
  term t0
WHERE
  t0.key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.value AS value_4 FROM term t0 WHERE t0.key = 'home_page_seo_title' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  advertisement_disposition t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM advertisement_disposition t0;

SELECT
  t0.id AS id_1,
  t0.body AS body_2,
  t0.author AS author_3,
  t0.summary AS summary_4
FROM
  testimonial t0

SELECT t0.id AS id_1, t0.body AS body_2, t0.author AS author_3, t0.summary AS summary_4 FROM testimonial t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5 FROM blog_category t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.seo_description AS seo_description_3,
  t0.seo_title AS seo_title_4,
  t0.description AS description_5
FROM
  property_type t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.seo_description AS seo_description_3, t0.seo_title AS seo_title_4, t0.description AS description_5 FROM property_type t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  advertisement_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM advertisement_status t0 WHERE t0.id = 2;