Symfony Profiler

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 = '172.70.111.175' 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.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 = ?

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 = '104966';

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,
  t0.seo_description AS seo_description_3,
  t0.seo_title AS seo_title_4,
  t0.description AS description_5
FROM
  advertisement_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 advertisement_type t0;

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

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

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.name AS name_2
FROM
  type_of_ownership t0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.expiration AS expiration_2,
  t0.expiration_homepage AS expiration_homepage_3,
  t0.position AS position_4,
  t0.advertisement_id AS advertisement_id_5
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.position AS position_4, t0.advertisement_id AS advertisement_id_5 FROM advertisement_premium t0 WHERE t0.advertisement_id = 104966;

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 = 'default_advertisement_seo_title' 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.id = ?

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.id = 361;

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

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

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

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