Symfony Profiler

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.url = ?
LIMIT
  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.url = 'podkrovni-prostor-s-projektem-na-vestavbu-31-k-prodeji' LIMIT 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
WHERE
  t0.id = ?

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 WHERE t0.id = 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_.property_type_id = ?
  AND a0_.advertisement_type_id = ?
  AND a0_.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
  ABS(a0_.latitude - ?) + ABS(a0_.longitude - ?) ASC
LIMIT
  10

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_.property_type_id = 1 AND a0_.advertisement_type_id = 1 AND a0_.id <> 18467 AND ((a0_.is_admin = 1 AND a0_.date_of_expiration > '2025-05-16 18:22:08' 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-16 18:22:08' AND a0_.is_visible = 1 AND a0_.draft = 0 AND a0_.approved = 1)) ORDER BY ABS(a0_.latitude - '50.083538') + ABS(a0_.longitude - '14.451385') ASC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.created_at AS created_at_4,
  t0.active AS active_5,
  t0.description AS description_6,
  t0.original_price AS original_price_7,
  t0.category_id AS category_id_8
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.created_at AS created_at_4, t0.active AS active_5, t0.description AS description_6, t0.original_price AS original_price_7, t0.category_id AS category_id_8 FROM product t0 WHERE t0.id = 11;

SELECT
  a0_.id AS id_0,
  a0_.date AS date_1,
  a0_.count AS count_2,
  a0_.advertisement_id AS advertisement_id_3
FROM
  advertisement_display a0_
WHERE
  a0_.date >= ?
  AND a0_.date <= ?
  AND a0_.advertisement_id = ?

SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.count AS count_2, a0_.advertisement_id AS advertisement_id_3 FROM advertisement_display a0_ WHERE a0_.date >= '2025-05-16 00:00:00' AND a0_.date <= '2025-05-16 23:59:00' AND a0_.advertisement_id = 18467;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO advertisement_display (date, count, advertisement_id)
VALUES
  (?, ?, ?)

INSERT INTO advertisement_display (date, count, advertisement_id) VALUES ('2025-05-16 18:22:08', 1, 18467);

"COMMIT"

"COMMIT";

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 = 'advertisement_page_seo_title' 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 = ?
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 = 'advertisement_page_seo_description' LIMIT 1;

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.advertisement_id AS advertisement_id_6
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.advertisement_id AS advertisement_id_6 FROM advertisement_image t0 WHERE t0.advertisement_id = 18467;

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 = 1;

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 = 18467;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  reconstruction t0
  INNER JOIN advertisement_reconstruction ON t0.id = advertisement_reconstruction.reconstruction_id
WHERE
  advertisement_reconstruction.advertisement_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM reconstruction t0 INNER JOIN advertisement_reconstruction ON t0.id = advertisement_reconstruction.reconstruction_id WHERE advertisement_reconstruction.advertisement_id = 18467;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  property_equipment t0
  INNER JOIN advertisement_property_equipment ON t0.id = advertisement_property_equipment.property_equipment_id
WHERE
  advertisement_property_equipment.advertisement_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM property_equipment t0 INNER JOIN advertisement_property_equipment ON t0.id = advertisement_property_equipment.property_equipment_id WHERE advertisement_property_equipment.advertisement_id = 18467;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  features t0
  INNER JOIN advertisement_features ON t0.id = advertisement_features.features_id
WHERE
  advertisement_features.advertisement_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM features t0 INNER JOIN advertisement_features ON t0.id = advertisement_features.features_id WHERE advertisement_features.advertisement_id = 18467;

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.advertisement_id AS advertisement_id_6
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.advertisement_id AS advertisement_id_6 FROM advertisement_image t0 WHERE t0.advertisement_id = 24745;

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 = 24745;

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.advertisement_id AS advertisement_id_6
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.advertisement_id AS advertisement_id_6 FROM advertisement_image t0 WHERE t0.advertisement_id = 20917;

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 = 20917;

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.advertisement_id AS advertisement_id_6
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.advertisement_id AS advertisement_id_6 FROM advertisement_image t0 WHERE t0.advertisement_id = 20551;

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 = 20551;