Symfony Profiler

SELECT
  l0_.id AS id_0,
  l0_.token AS token_1
FROM
  lang_token l0_

SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_;

SELECT
  t0.homepage AS homepage_1,
  t0.documents_order AS documents_order_2,
  t0.doc_files_order AS doc_files_order_3,
  t0.id AS id_4,
  t0.sort AS sort_5,
  t0.files_order AS files_order_6,
  t0.media_updated AS media_updated_7,
  t0.img_files_order AS img_files_order_8,
  t0.parent AS parent_9,
  t0.seo_id AS seo_id_10,
  t0.template_id AS template_id_11,
  t0.page_file_id AS page_file_id_12,
  t0.file_id AS file_id_13,
  t0.img_file_id AS img_file_id_14,
  t0.doc_file_id AS doc_file_id_15
FROM
  web_page t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = 4 LIMIT 1;

SELECT
  t0.entity_class AS entity_class_1,
  t0.request_id AS request_id_2,
  t0.property AS property_3,
  t0.media_order AS media_order_4,
  t0.created AS created_5,
  t0.entity_id AS entity_id_6,
  t0.id AS id_7
FROM
  media_order_record t0
WHERE
  t0.request_id = ?

SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = '4f69282f27_6807ff5ae5a648.29656702';

SELECT
  t0.name AS name_1,
  t0.disabled AS disabled_2,
  t0.id AS id_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  web_menu_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM web_menu_translation t0 WHERE t0.translatable_id = 6;

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.keywords AS keywords_3,
  t0.name AS name_4,
  t0.url AS url_5,
  t0.`generated` AS generated_6,
  t0.id AS id_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  web_seo_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.name AS name_4, t0.url AS url_5, t0.`generated` AS generated_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM web_seo_translation t0 WHERE t0.translatable_id = 4;

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.files_order AS files_order_5,
  t0.media_updated AS media_updated_6,
  t0.seo_id AS seo_id_7,
  t0.category_file_id AS category_file_id_8,
  t0.file_id AS file_id_9
FROM
  category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 WHERE t0.id = 2 LIMIT 1;

SELECT
  t0.trans_value AS trans_value_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  setting_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = 11;

SELECT
  t0.path AS path_1,
  t0.type AS type_2,
  t0.template AS template_3,
  t0.upload_form AS upload_form_4,
  t0.data_sources AS data_sources_5,
  t0.only_once AS only_once_6,
  t0.id AS id_7,
  t0.updated_at AS updated_at_8,
  t0.upload AS upload_9
FROM
  web_template t0
WHERE
  t0.id = ?

SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = 40;

SELECT
  t0.noindex AS noindex_1,
  t0.module AS module_2,
  t0.anchor AS anchor_3,
  t0.suffix AS suffix_4,
  t0.entity AS entity_5,
  t0.id AS id_6
FROM
  web_seo t0
WHERE
  t0.id = ?

SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6 FROM web_seo t0 WHERE t0.id = 4;

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
WHERE
  t0.active = ?

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = 1;

SELECT
  t0.alias AS alias_1,
  t0.value AS value_2,
  t0.id AS id_3
FROM
  setting t0

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0;

SELECT
  t0.alias AS alias_1,
  t0.active AS active_2,
  t0.api AS api_3,
  t0.display AS display_4,
  t0.script AS script_5,
  t0.category AS category_6,
  t0.position AS position_7,
  t0.code1 AS code1_8,
  t0.code2 AS code2_9,
  t0.id AS id_10,
  t0.sort AS sort_11
FROM
  web_code t0
WHERE
  t0.active = ?

SELECT t0.alias AS alias_1, t0.active AS active_2, t0.api AS api_3, t0.display AS display_4, t0.script AS script_5, t0.category AS category_6, t0.position AS position_7, t0.code1 AS code1_8, t0.code2 AS code2_9, t0.id AS id_10, t0.sort AS sort_11 FROM web_code t0 WHERE t0.active = 1;

SELECT
  t0.published AS published_1,
  t0.expired AS expired_2,
  t0.documents_order AS documents_order_3,
  t0.doc_files_order AS doc_files_order_4,
  t0.id AS id_5,
  t0.sort AS sort_6,
  t0.files_order AS files_order_7,
  t0.media_updated AS media_updated_8,
  t0.img_files_order AS img_files_order_9,
  t0.author_id AS author_id_10,
  t0.seo_id AS seo_id_11,
  t0.news_file_id AS news_file_id_12,
  t0.file_id AS file_id_13,
  t0.img_file_id AS img_file_id_14,
  t0.doc_file_id AS doc_file_id_15
FROM
  web_news t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.published AS published_1, t0.expired AS expired_2, t0.documents_order AS documents_order_3, t0.doc_files_order AS doc_files_order_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.img_files_order AS img_files_order_9, t0.author_id AS author_id_10, t0.seo_id AS seo_id_11, t0.news_file_id AS news_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_news t0 WHERE t0.id = 3 LIMIT 1;

SELECT
  t0.entity AS entity_1,
  t0.controller AS controller_2,
  t0.bundle AS bundle_3,
  t0.action AS action_4,
  t0.id AS id_5
FROM
  web_module t0
WHERE
  t0.id = ?

SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5 FROM web_module t0 WHERE t0.id = 2;

SELECT
  w0_.link_id AS link_id_0,
  w0_.url AS url_1,
  w0_.active AS active_2,
  w0_.id AS id_3,
  w0_.sort AS sort_4,
  w0_.parent AS parent_5,
  w0_.module_id AS module_id_6,
  w0_.file_id AS file_id_7,
  w0_.img_file_id AS img_file_id_8
FROM
  web_menu w0_
  INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id
  INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id
WHERE
  w1_.id = 1
  AND w0_.active = 1
ORDER BY
  w0_.sort ASC

SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.sort ASC;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.longDescription AS longDescription_3,
  t0.price_comment AS price_comment_4,
  t0.agent_id AS agent_id_5,
  t0.external_url AS external_url_6,
  t0.id AS id_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  estate_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.longDescription AS longDescription_3, t0.price_comment AS price_comment_4, t0.agent_id AS agent_id_5, t0.external_url AS external_url_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM estate_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.name AS name_1,
  t0.text AS text_2,
  t0.title AS title_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.text AS text_2, t0.title AS title_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM category_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.api_id AS api_id_3,
  t0.affiliate_id AS affiliate_id_4,
  t0.stamp AS stamp_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.area_floor AS area_floor_10,
  t0.area_use AS area_use_11,
  t0.area_of_lot AS area_of_lot_12,
  t0.area_of_balcony AS area_of_balcony_13,
  t0.balcony AS balcony_14,
  t0.area_of_loggia AS area_of_loggia_15,
  t0.loggia AS loggia_16,
  t0.area_of_terrace AS area_of_terrace_17,
  t0.terrace AS terrace_18,
  t0.elevator AS elevator_19,
  t0.cellar AS cellar_20,
  t0.area_of_cellar AS area_of_cellar_21,
  t0.area_of_garden AS area_of_garden_22,
  t0.garden AS garden_23,
  t0.dont_advertise_price AS dont_advertise_price_24,
  t0.image AS image_25,
  t0.images AS images_26,
  t0.region AS region_27,
  t0.district AS district_28,
  t0.village AS village_29,
  t0.part_of_village AS part_of_village_30,
  t0.psc AS psc_31,
  t0.catastral_area AS catastral_area_32,
  t0.type_of_estate AS type_of_estate_33,
  t0.subtype_of_estate AS subtype_of_estate_34,
  t0.floor AS floor_35,
  t0.type_of_ownership AS type_of_ownership_36,
  t0.parking AS parking_37,
  t0.disposition AS disposition_38,
  t0.youtube AS youtube_39,
  t0.energy_performance_rating AS energy_performance_rating_40,
  t0.electricity AS electricity_41,
  t0.electricity_on_lot AS electricity_on_lot_42,
  t0.internet_connection AS internet_connection_43,
  t0.structure_of_building AS structure_of_building_44,
  t0.canalization AS canalization_45,
  t0.water AS water_46,
  t0.show_external_url_button AS show_external_url_button_47,
  t0.show_banner AS show_banner_48,
  t0.price_type AS price_type_49,
  t0.id AS id_50,
  t0.sort AS sort_51,
  t0.files_order AS files_order_52,
  t0.media_updated AS media_updated_53,
  t0.seo_id AS seo_id_54,
  t0.estate_file_id AS estate_file_id_55,
  t0.category_id AS category_id_56,
  t0.file_id AS file_id_57
FROM
  estate t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 WHERE t0.category_id = 2 ORDER BY t0.sort ASC;

SELECT
  w0_.active AS active_0,
  w0_.only_image AS only_image_1,
  w0_.created AS created_2,
  w0_.entity_id AS entity_id_3,
  w0_.id AS id_4,
  w0_.sort AS sort_5,
  w0_.link_id AS link_id_6,
  w0_.page_id AS page_id_7,
  w0_.author_id AS author_id_8,
  w0_.file_tablet_id AS file_tablet_id_9,
  w0_.file_phone_id AS file_phone_id_10,
  w0_.video_id AS video_id_11,
  w0_.dms_file_tablet_id AS dms_file_tablet_id_12,
  w0_.dms_file_phone_id AS dms_file_phone_id_13,
  w0_.dms_video_id AS dms_video_id_14,
  w0_.file_id AS file_id_15,
  w0_.img_file_id AS img_file_id_16
FROM
  web_slider w0_
  INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id
  INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id
WHERE
  w1_.id = 1
  AND w0_.active = 1
ORDER BY
  w0_.page_id ASC,
  w0_.sort ASC

SELECT w0_.active AS active_0, w0_.only_image AS only_image_1, w0_.created AS created_2, w0_.entity_id AS entity_id_3, w0_.id AS id_4, w0_.sort AS sort_5, w0_.link_id AS link_id_6, w0_.page_id AS page_id_7, w0_.author_id AS author_id_8, w0_.file_tablet_id AS file_tablet_id_9, w0_.file_phone_id AS file_phone_id_10, w0_.video_id AS video_id_11, w0_.dms_file_tablet_id AS dms_file_tablet_id_12, w0_.dms_file_phone_id AS dms_file_phone_id_13, w0_.dms_video_id AS dms_video_id_14, w0_.file_id AS file_id_15, w0_.img_file_id AS img_file_id_16 FROM web_slider w0_ INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.page_id ASC, w0_.sort ASC;

SELECT
  w0_.link_id AS link_id_0,
  w0_.url AS url_1,
  w0_.active AS active_2,
  w0_.id AS id_3,
  w0_.sort AS sort_4,
  w0_.parent AS parent_5,
  w0_.module_id AS module_id_6,
  w0_.file_id AS file_id_7,
  w0_.img_file_id AS img_file_id_8
FROM
  web_menu w0_
  INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id
  INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id
WHERE
  w1_.id = 4
  AND w0_.active = 1
ORDER BY
  w0_.sort ASC

SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 4 AND w0_.active = 1 ORDER BY w0_.sort ASC;

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.api_id AS api_id_3,
  t0.affiliate_id AS affiliate_id_4,
  t0.stamp AS stamp_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.area_floor AS area_floor_10,
  t0.area_use AS area_use_11,
  t0.area_of_lot AS area_of_lot_12,
  t0.area_of_balcony AS area_of_balcony_13,
  t0.balcony AS balcony_14,
  t0.area_of_loggia AS area_of_loggia_15,
  t0.loggia AS loggia_16,
  t0.area_of_terrace AS area_of_terrace_17,
  t0.terrace AS terrace_18,
  t0.elevator AS elevator_19,
  t0.cellar AS cellar_20,
  t0.area_of_cellar AS area_of_cellar_21,
  t0.area_of_garden AS area_of_garden_22,
  t0.garden AS garden_23,
  t0.dont_advertise_price AS dont_advertise_price_24,
  t0.image AS image_25,
  t0.images AS images_26,
  t0.region AS region_27,
  t0.district AS district_28,
  t0.village AS village_29,
  t0.part_of_village AS part_of_village_30,
  t0.psc AS psc_31,
  t0.catastral_area AS catastral_area_32,
  t0.type_of_estate AS type_of_estate_33,
  t0.subtype_of_estate AS subtype_of_estate_34,
  t0.floor AS floor_35,
  t0.type_of_ownership AS type_of_ownership_36,
  t0.parking AS parking_37,
  t0.disposition AS disposition_38,
  t0.youtube AS youtube_39,
  t0.energy_performance_rating AS energy_performance_rating_40,
  t0.electricity AS electricity_41,
  t0.electricity_on_lot AS electricity_on_lot_42,
  t0.internet_connection AS internet_connection_43,
  t0.structure_of_building AS structure_of_building_44,
  t0.canalization AS canalization_45,
  t0.water AS water_46,
  t0.show_external_url_button AS show_external_url_button_47,
  t0.show_banner AS show_banner_48,
  t0.price_type AS price_type_49,
  t0.id AS id_50,
  t0.sort AS sort_51,
  t0.files_order AS files_order_52,
  t0.media_updated AS media_updated_53,
  t0.seo_id AS seo_id_54,
  t0.estate_file_id AS estate_file_id_55,
  t0.category_id AS category_id_56,
  t0.file_id AS file_id_57
FROM
  estate t0
ORDER BY
  t0.sort ASC