Symfony Profiler

SELECT
  t0.header_logo AS header_logo_1,
  t0.header_phone1_show AS header_phone1_show_2,
  t0.header_phone1_number AS header_phone1_number_3,
  t0.header_phone2_show AS header_phone2_show_4,
  t0.header_phone2_number AS header_phone2_number_5,
  t0.header_filter_btn_show AS header_filter_btn_show_6,
  t0.header_filter_btn_text AS header_filter_btn_text_7,
  t0.header_filter_city_text AS header_filter_city_text_8,
  t0.header_filter_type_text AS header_filter_type_text_9,
  t0.header_pay_btn_show AS header_pay_btn_show_10,
  t0.header_pay_btn_text AS header_pay_btn_text_11,
  t0.header_pay_btn_url AS header_pay_btn_url_12,
  t0.header_map_btn_show AS header_map_btn_show_13,
  t0.header_map_btn_text AS header_map_btn_text_14,
  t0.header_contact_btn_show AS header_contact_btn_show_15,
  t0.header_contact_btn_text AS header_contact_btn_text_16,
  t0.menu_logo AS menu_logo_17,
  t0.menu_links AS menu_links_18,
  t0.footer_logo AS footer_logo_19,
  t0.footer_ruc AS footer_ruc_20,
  t0.footer_company_name AS footer_company_name_21,
  t0.footer_links AS footer_links_22,
  t0.footer_contact_show AS footer_contact_show_23,
  t0.footer_contact_text AS footer_contact_text_24,
  t0.footer_contact_phone_show AS footer_contact_phone_show_25,
  t0.footer_contact_phone_number AS footer_contact_phone_number_26,
  t0.footer_contact_address_show AS footer_contact_address_show_27,
  t0.footer_contact_address_text AS footer_contact_address_text_28,
  t0.footer_claim_show AS footer_claim_show_29,
  t0.footer_claim_text AS footer_claim_text_30,
  t0.footer_claim_url AS footer_claim_url_31,
  t0.footer_claim_icon AS footer_claim_icon_32,
  t0.footer_legal_show AS footer_legal_show_33,
  t0.footer_legal_text AS footer_legal_text_34,
  t0.footer_legal_links AS footer_legal_links_35,
  t0.footer_info_show AS footer_info_show_36,
  t0.footer_info_text AS footer_info_text_37,
  t0.footer_info_links AS footer_info_links_38,
  t0.region_info_show AS region_info_show_39,
  t0.region_button_show AS region_button_show_40,
  t0.region_button_text AS region_button_text_41,
  t0.counter_show AS counter_show_42,
  t0.counter_show_all_pages AS counter_show_all_pages_43,
  t0.counter_footer AS counter_footer_44,
  t0.counter_text AS counter_text_45,
  t0.counter_show_text_in_responsive AS counter_show_text_in_responsive_46,
  t0.counter_date AS counter_date_47,
  t0.counter_show_days AS counter_show_days_48,
  t0.counter_banner_image_responsive AS counter_banner_image_responsive_49,
  t0.counter_backgroundcolor AS counter_backgroundcolor_50,
  t0.counter_color_text AS counter_color_text_51,
  t0.counter_banner_texto AS counter_banner_texto_52,
  t0.counter_banner_color AS counter_banner_color_53,
  t0.counter_banner_opacity AS counter_banner_opacity_54,
  t0.counter_banner_image AS counter_banner_image_55,
  t0.counter_link AS counter_link_56,
  t0.counter_link_blank AS counter_link_blank_57,
  t0.social_show AS social_show_58,
  t0.social_text AS social_text_59,
  t0.social_youtube_show AS social_youtube_show_60,
  t0.social_youtube_url AS social_youtube_url_61,
  t0.social_facebook_show AS social_facebook_show_62,
  t0.social_facebook_url AS social_facebook_url_63,
  t0.social_instagram_show AS social_instagram_show_64,
  t0.social_instagram_url AS social_instagram_url_65,
  t0.seo_show AS seo_show_66,
  t0.seo_domain AS seo_domain_67,
  t0.seo_show_items AS seo_show_items_68,
  t0.seo_favicon AS seo_favicon_69,
  t0.seo_title AS seo_title_70,
  t0.seo_description AS seo_description_71,
  t0.blog_show AS blog_show_72,
  t0.blog_url AS blog_url_73,
  t0.blog_qty AS blog_qty_74,
  t0.account_show AS account_show_75,
  t0.account_url AS account_url_76,
  t0.outlet_show AS outlet_show_77,
  t0.outlet_url AS outlet_url_78,
  t0.whatsapp_show AS whatsapp_show_79,
  t0.whatsapp_button AS whatsapp_button_80,
  t0.whatsapp_image AS whatsapp_image_81,
  t0.whatsapp_number AS whatsapp_number_82,
  t0.whatsapp_message AS whatsapp_message_83,
  t0.whatsapp_consultants_show AS whatsapp_consultants_show_84,
  t0.whatsapp_title AS whatsapp_title_85,
  t0.whatsapp_text AS whatsapp_text_86,
  t0.whatsapp_help AS whatsapp_help_87,
  t0.whatsapp_consultants_items AS whatsapp_consultants_items_88,
  t0.copyright_text AS copyright_text_89,
  t0.terms_show AS terms_show_90,
  t0.terms_text AS terms_text_91,
  t0.custom_scripts AS custom_scripts_92,
  t0.map_api_key AS map_api_key_93,
  t0.custom_script_header AS custom_script_header_94,
  t0.custom_script_body AS custom_script_body_95,
  t0.custom_script_footer AS custom_script_footer_96,
  t0.map_api_key1 AS map_api_key1_97,
  t0.custom_script_header1 AS custom_script_header1_98,
  t0.custom_script_body1 AS custom_script_body1_99,
  t0.custom_script_footer1 AS custom_script_footer1_100,
  t0.call_let AS call_let_101,
  t0.call_days AS call_days_102,
  t0.call_start_time AS call_start_time_103,
  t0.call_end_time AS call_end_time_104,
  t0.dni_blacklist AS dni_blacklist_105,
  t0.email_blacklist AS email_blacklist_106,
  t0.phone_blacklist AS phone_blacklist_107,
  t0.link_supplier_code_show AS link_supplier_code_show_108,
  t0.link_supplier_code_text AS link_supplier_code_text_109,
  t0.link_supplier_code_target AS link_supplier_code_target_110,
  t0.id AS id_111,
  t0.created AS created_112,
  t0.modified AS modified_113,
  t0.created_user AS created_user_114,
  t0.modified_user AS modified_user_115
FROM
  info t0
WHERE
  t0.id = ?

SELECT t0.header_logo AS header_logo_1, t0.header_phone1_show AS header_phone1_show_2, t0.header_phone1_number AS header_phone1_number_3, t0.header_phone2_show AS header_phone2_show_4, t0.header_phone2_number AS header_phone2_number_5, t0.header_filter_btn_show AS header_filter_btn_show_6, t0.header_filter_btn_text AS header_filter_btn_text_7, t0.header_filter_city_text AS header_filter_city_text_8, t0.header_filter_type_text AS header_filter_type_text_9, t0.header_pay_btn_show AS header_pay_btn_show_10, t0.header_pay_btn_text AS header_pay_btn_text_11, t0.header_pay_btn_url AS header_pay_btn_url_12, t0.header_map_btn_show AS header_map_btn_show_13, t0.header_map_btn_text AS header_map_btn_text_14, t0.header_contact_btn_show AS header_contact_btn_show_15, t0.header_contact_btn_text AS header_contact_btn_text_16, t0.menu_logo AS menu_logo_17, t0.menu_links AS menu_links_18, t0.footer_logo AS footer_logo_19, t0.footer_ruc AS footer_ruc_20, t0.footer_company_name AS footer_company_name_21, t0.footer_links AS footer_links_22, t0.footer_contact_show AS footer_contact_show_23, t0.footer_contact_text AS footer_contact_text_24, t0.footer_contact_phone_show AS footer_contact_phone_show_25, t0.footer_contact_phone_number AS footer_contact_phone_number_26, t0.footer_contact_address_show AS footer_contact_address_show_27, t0.footer_contact_address_text AS footer_contact_address_text_28, t0.footer_claim_show AS footer_claim_show_29, t0.footer_claim_text AS footer_claim_text_30, t0.footer_claim_url AS footer_claim_url_31, t0.footer_claim_icon AS footer_claim_icon_32, t0.footer_legal_show AS footer_legal_show_33, t0.footer_legal_text AS footer_legal_text_34, t0.footer_legal_links AS footer_legal_links_35, t0.footer_info_show AS footer_info_show_36, t0.footer_info_text AS footer_info_text_37, t0.footer_info_links AS footer_info_links_38, t0.region_info_show AS region_info_show_39, t0.region_button_show AS region_button_show_40, t0.region_button_text AS region_button_text_41, t0.counter_show AS counter_show_42, t0.counter_show_all_pages AS counter_show_all_pages_43, t0.counter_footer AS counter_footer_44, t0.counter_text AS counter_text_45, t0.counter_show_text_in_responsive AS counter_show_text_in_responsive_46, t0.counter_date AS counter_date_47, t0.counter_show_days AS counter_show_days_48, t0.counter_banner_image_responsive AS counter_banner_image_responsive_49, t0.counter_backgroundcolor AS counter_backgroundcolor_50, t0.counter_color_text AS counter_color_text_51, t0.counter_banner_texto AS counter_banner_texto_52, t0.counter_banner_color AS counter_banner_color_53, t0.counter_banner_opacity AS counter_banner_opacity_54, t0.counter_banner_image AS counter_banner_image_55, t0.counter_link AS counter_link_56, t0.counter_link_blank AS counter_link_blank_57, t0.social_show AS social_show_58, t0.social_text AS social_text_59, t0.social_youtube_show AS social_youtube_show_60, t0.social_youtube_url AS social_youtube_url_61, t0.social_facebook_show AS social_facebook_show_62, t0.social_facebook_url AS social_facebook_url_63, t0.social_instagram_show AS social_instagram_show_64, t0.social_instagram_url AS social_instagram_url_65, t0.seo_show AS seo_show_66, t0.seo_domain AS seo_domain_67, t0.seo_show_items AS seo_show_items_68, t0.seo_favicon AS seo_favicon_69, t0.seo_title AS seo_title_70, t0.seo_description AS seo_description_71, t0.blog_show AS blog_show_72, t0.blog_url AS blog_url_73, t0.blog_qty AS blog_qty_74, t0.account_show AS account_show_75, t0.account_url AS account_url_76, t0.outlet_show AS outlet_show_77, t0.outlet_url AS outlet_url_78, t0.whatsapp_show AS whatsapp_show_79, t0.whatsapp_button AS whatsapp_button_80, t0.whatsapp_image AS whatsapp_image_81, t0.whatsapp_number AS whatsapp_number_82, t0.whatsapp_message AS whatsapp_message_83, t0.whatsapp_consultants_show AS whatsapp_consultants_show_84, t0.whatsapp_title AS whatsapp_title_85, t0.whatsapp_text AS whatsapp_text_86, t0.whatsapp_help AS whatsapp_help_87, t0.whatsapp_consultants_items AS whatsapp_consultants_items_88, t0.copyright_text AS copyright_text_89, t0.terms_show AS terms_show_90, t0.terms_text AS terms_text_91, t0.custom_scripts AS custom_scripts_92, t0.map_api_key AS map_api_key_93, t0.custom_script_header AS custom_script_header_94, t0.custom_script_body AS custom_script_body_95, t0.custom_script_footer AS custom_script_footer_96, t0.map_api_key1 AS map_api_key1_97, t0.custom_script_header1 AS custom_script_header1_98, t0.custom_script_body1 AS custom_script_body1_99, t0.custom_script_footer1 AS custom_script_footer1_100, t0.call_let AS call_let_101, t0.call_days AS call_days_102, t0.call_start_time AS call_start_time_103, t0.call_end_time AS call_end_time_104, t0.dni_blacklist AS dni_blacklist_105, t0.email_blacklist AS email_blacklist_106, t0.phone_blacklist AS phone_blacklist_107, t0.link_supplier_code_show AS link_supplier_code_show_108, t0.link_supplier_code_text AS link_supplier_code_text_109, t0.link_supplier_code_target AS link_supplier_code_target_110, t0.id AS id_111, t0.created AS created_112, t0.modified AS modified_113, t0.created_user AS created_user_114, t0.modified_user AS modified_user_115 FROM info t0 WHERE t0.id = 1;

SELECT
  t0.title AS title_1,
  t0.text AS text_2,
  t0.image AS image_3,
  t0.colour_btn_text AS colour_btn_text_4,
  t0.colour_btn_url AS colour_btn_url_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.modified AS modified_8,
  t0.created_user AS created_user_9,
  t0.modified_user AS modified_user_10
FROM
  info_error t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.text AS text_2, t0.image AS image_3, t0.colour_btn_text AS colour_btn_text_4, t0.colour_btn_url AS colour_btn_url_5, t0.id AS id_6, t0.created AS created_7, t0.modified AS modified_8, t0.created_user AS created_user_9, t0.modified_user AS modified_user_10 FROM info_error t0 WHERE t0.id = 1;

SELECT
  DISTINCT p0_.slug AS slug_0,
  p0_.title AS title_1,
  p0_.sequence AS sequence_2,
  p0_.image AS image_3,
  p0_.logo AS logo_4,
  p0_.color AS color_5,
  p0_.open_in_list AS open_in_list_6
FROM
  property_type p0_
  INNER JOIN property p1_ ON p0_.id = p1_.property_type_id
  INNER JOIN location l2_ ON p1_.location_id = l2_.id
WHERE
  p0_.active = ?
  AND p1_.active = ?
  AND l2_.active = ?
  AND p1_.is_only_landing = ?
ORDER BY
  p0_.sequence ASC

SELECT DISTINCT p0_.slug AS slug_0, p0_.title AS title_1, p0_.sequence AS sequence_2, p0_.image AS image_3, p0_.logo AS logo_4, p0_.color AS color_5, p0_.open_in_list AS open_in_list_6 FROM property_type p0_ INNER JOIN property p1_ ON p0_.id = p1_.property_type_id INNER JOIN location l2_ ON p1_.location_id = l2_.id WHERE p0_.active = 1 AND p1_.active = 1 AND l2_.active = 1 AND p1_.is_only_landing = 0 ORDER BY p0_.sequence ASC;

SELECT
  DISTINCT l0_.slug AS slug_0,
  l0_.title AS title_1,
  l0_.sequence AS sequence_2
FROM
  location l0_
  INNER JOIN property p1_ ON l0_.id = p1_.location_id
  INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id
WHERE
  l0_.active = ?
  AND p1_.active = ?
  AND p2_.active = ?
  AND p1_.is_only_landing = ?
ORDER BY
  l0_.sequence ASC

SELECT DISTINCT l0_.slug AS slug_0, l0_.title AS title_1, l0_.sequence AS sequence_2 FROM location l0_ INNER JOIN property p1_ ON l0_.id = p1_.location_id INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id WHERE l0_.active = 1 AND p1_.active = 1 AND p2_.active = 1 AND p1_.is_only_landing = 0 ORDER BY l0_.sequence ASC;

SELECT
  DISTINCT p0_.title AS title_0,
  p1_.title AS title_1,
  IFNULL(p1_.titlecontacto, l2_.title) AS sclr_2,
  l2_.title AS title_3,
  p1_.slug AS slug_4,
  IFNULL(p1_.program, '##') AS sclr_5
FROM
  property p1_
  INNER JOIN property_type p0_ ON p1_.property_type_id = p0_.id
  INNER JOIN location l2_ ON p1_.location_id = l2_.id
WHERE
  p0_.active = ?
  AND p1_.active = ?
  AND l2_.active = ?
  AND p1_.is_only_landing = ?
ORDER BY
  p1_.sequence ASC

SELECT DISTINCT p0_.title AS title_0, p1_.title AS title_1, IFNULL(p1_.titlecontacto, l2_.title) AS sclr_2, l2_.title AS title_3, p1_.slug AS slug_4, IFNULL(p1_.program, '##') AS sclr_5 FROM property p1_ INNER JOIN property_type p0_ ON p1_.property_type_id = p0_.id INNER JOIN location l2_ ON p1_.location_id = l2_.id WHERE p0_.active = 1 AND p1_.active = 1 AND l2_.active = 1 AND p1_.is_only_landing = 0 ORDER BY p1_.sequence ASC;

SELECT
  l0_.slug AS slug_0,
  COUNT(p1_.id) AS sclr_1,
  p1_.slug AS slug_2
FROM
  property p1_
  INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id
  INNER JOIN location l0_ ON p1_.location_id = l0_.id
  INNER JOIN stage s3_ ON p1_.stage_id = s3_.id
WHERE
  p1_.active = ?
  AND p2_.active = ?
  AND l0_.active = ?
  AND s3_.active = ?
  AND p1_.is_only_landing = ?
GROUP BY
  l0_.slug
ORDER BY
  p1_.sequence ASC,
  p1_.title ASC

SELECT l0_.slug AS slug_0, COUNT(p1_.id) AS sclr_1, p1_.slug AS slug_2 FROM property p1_ INNER JOIN property_type p2_ ON p1_.property_type_id = p2_.id INNER JOIN location l0_ ON p1_.location_id = l0_.id INNER JOIN stage s3_ ON p1_.stage_id = s3_.id WHERE p1_.active = 1 AND p2_.active = 1 AND l0_.active = 1 AND s3_.active = 1 AND p1_.is_only_landing = 0 GROUP BY l0_.slug ORDER BY p1_.sequence ASC, p1_.title ASC;

SELECT
  p0_.title AS title_0,
  p0_.titlecontacto AS titlecontacto_1,
  p0_.sap_zone AS sap_zone_2,
  p0_.sap_zone_inmobiliario AS sap_zone_inmobiliario_3,
  p0_.sap_code AS sap_code_4,
  p0_.sap_project AS sap_project_5,
  p0_.slug AS slug_6,
  p0_.template AS template_7,
  p0_.program AS program_8,
  p0_.image_list_only_image AS image_list_only_image_9,
  p0_.image_list_desktop AS image_list_desktop_10,
  p0_.image_list_mobile AS image_list_mobile_11,
  p0_.image_map AS image_map_12,
  p0_.logo_desktop AS logo_desktop_13,
  p0_.logo_mobile AS logo_mobile_14,
  p0_.image_list_url AS image_list_url_15,
  p0_.image_features_detail_show AS image_features_detail_show_16,
  p0_.image_features_detail_img_desktop AS image_features_detail_img_desktop_17,
  p0_.image_features_detail_img_mobile AS image_features_detail_img_mobile_18,
  p0_.fee_show AS fee_show_19,
  p0_.fee_image AS fee_image_20,
  p0_.fee_preffix AS fee_preffix_21,
  p0_.fee_price AS fee_price_22,
  p0_.fee_suffix AS fee_suffix_23,
  p0_.cash_show AS cash_show_24,
  p0_.cash_image AS cash_image_25,
  p0_.cash_preffix AS cash_preffix_26,
  p0_.cash_price AS cash_price_27,
  p0_.cash_suffix AS cash_suffix_28,
  p0_.list_btn_text AS list_btn_text_29,
  p0_.address_show AS address_show_30,
  p0_.address_preffix AS address_preffix_31,
  p0_.address_value AS address_value_32,
  p0_.month_show AS month_show_33,
  p0_.month_preffix AS month_preffix_34,
  p0_.month_value AS month_value_35,
  p0_.sequence AS sequence_36,
  p0_.active AS active_37,
  p0_.is_only_landing AS is_only_landing_38,
  p0_.popup_video_show AS popup_video_show_39,
  p0_.popup_video_hide_close_button AS popup_video_hide_close_button_40,
  p0_.popup_video_link AS popup_video_link_41,
  p0_.popup_video_duration AS popup_video_duration_42,
  p0_.popup_video_skip_duration AS popup_video_skip_duration_43,
  p0_.banners AS banners_44,
  p0_.banner_opacity_show AS banner_opacity_show_45,
  p0_.banner_embed_video_show AS banner_embed_video_show_46,
  p0_.banner_embed_video_type AS banner_embed_video_type_47,
  p0_.banner_embed_video_url AS banner_embed_video_url_48,
  p0_.banner_embed_video_cover AS banner_embed_video_cover_49,
  p0_.banner_embed_image_desktop AS banner_embed_image_desktop_50,
  p0_.banner_embed_image_mobile AS banner_embed_image_mobile_51,
  p0_.banner_embed_preffix AS banner_embed_preffix_52,
  p0_.banner_embed_title AS banner_embed_title_53,
  p0_.banner_embed_suffix AS banner_embed_suffix_54,
  p0_.banner_embed_logo1_show AS banner_embed_logo1_show_55,
  p0_.banner_embed_logo1_img AS banner_embed_logo1_img_56,
  p0_.banner_embed_logo2_show AS banner_embed_logo2_show_57,
  p0_.banner_embed_logo2_img AS banner_embed_logo2_img_58,
  p0_.banner_embed_btn_show AS banner_embed_btn_show_59,
  p0_.banner_embed_btn_text AS banner_embed_btn_text_60,
  p0_.banner_video_show AS banner_video_show_61,
  p0_.banner_video_url AS banner_video_url_62,
  p0_.banner_video_title AS banner_video_title_63,
  p0_.banner_video_preffix AS banner_video_preffix_64,
  p0_.banner_video_suffix AS banner_video_suffix_65,
  p0_.banner_video_text AS banner_video_text_66,
  p0_.banner_video_img AS banner_video_img_67,
  p0_.terms_show AS terms_show_68,
  p0_.terms_title AS terms_title_69,
  p0_.terms_text AS terms_text_70,
  p0_.form_show AS form_show_71,
  p0_.form_title AS form_title_72,
  p0_.form_email AS form_email_73,
  p0_.thank_image_show AS thank_image_show_74,
  p0_.thank_image AS thank_image_75,
  p0_.fucsia_bar_show AS fucsia_bar_show_76,
  p0_.common_section_show AS common_section_show_77,
  p0_.common_show AS common_show_78,
  p0_.common_title AS common_title_79,
  p0_.common_text AS common_text_80,
  p0_.gallery_show AS gallery_show_81,
  p0_.gallery_title AS gallery_title_82,
  p0_.gallery_items AS gallery_items_83,
  p0_.benefit_show AS benefit_show_84,
  p0_.benefit_show_in_map AS benefit_show_in_map_85,
  p0_.benefit_image AS benefit_image_86,
  p0_.benefit_item_image_show AS benefit_item_image_show_87,
  p0_.benefit_item_image AS benefit_item_image_88,
  p0_.benefit_title AS benefit_title_89,
  p0_.benefit_items AS benefit_items_90,
  p0_.block_video_show AS block_video_show_91,
  p0_.block_video_background AS block_video_background_92,
  p0_.block_video_image AS block_video_image_93,
  p0_.block_video_logo AS block_video_logo_94,
  p0_.block_video_title AS block_video_title_95,
  p0_.block_video_url AS block_video_url_96,
  p0_.map_show AS map_show_97,
  p0_.map_show_start AS map_show_start_98,
  p0_.map_title AS map_title_99,
  p0_.map_items AS map_items_100,
  p0_.testimonials_show AS testimonials_show_101,
  p0_.testimonials_title AS testimonials_title_102,
  p0_.testimonials_items AS testimonials_items_103,
  p0_.discount_show AS discount_show_104,
  p0_.discount_show_start AS discount_show_start_105,
  p0_.discount_title AS discount_title_106,
  p0_.discount_image_desktop AS discount_image_desktop_107,
  p0_.discount_image_mobile AS discount_image_mobile_108,
  p0_.discount_items AS discount_items_109,
  p0_.quote_show AS quote_show_110,
  p0_.quote_show_in_popup AS quote_show_in_popup_111,
  p0_.quote_image AS quote_image_112,
  p0_.quote_popup_image AS quote_popup_image_113,
  p0_.quote_title AS quote_title_114,
  p0_.quote_text AS quote_text_115,
  p0_.related_show AS related_show_116,
  p0_.related_title AS related_title_117,
  p0_.related_btn_text AS related_btn_text_118,
  p0_.popup_show AS popup_show_119,
  p0_.popup_image_desktop AS popup_image_desktop_120,
  p0_.popup_image_mobile AS popup_image_mobile_121,
  p0_.popup_url AS popup_url_122,
  p0_.popup_blank AS popup_blank_123,
  p0_.alert_show AS alert_show_124,
  p0_.alert_image_desktop AS alert_image_desktop_125,
  p0_.alert_image_mobile AS alert_image_mobile_126,
  p0_.alert_url AS alert_url_127,
  p0_.alert_blank AS alert_blank_128,
  p0_.share_whatsapp_show AS share_whatsapp_show_129,
  p0_.share_facebook_show AS share_facebook_show_130,
  p0_.share_email_show AS share_email_show_131,
  p0_.mailing_show AS mailing_show_132,
  p0_.mailing_logo AS mailing_logo_133,
  p0_.mailing_banner AS mailing_banner_134,
  p0_.mailing_greeting_title AS mailing_greeting_title_135,
  p0_.mailing_greeting_text AS mailing_greeting_text_136,
  p0_.mailing_contact_title AS mailing_contact_title_137,
  p0_.mailing_contact_btn_text AS mailing_contact_btn_text_138,
  p0_.mailing_contact_btn_image AS mailing_contact_btn_image_139,
  p0_.mailing_contact_btn_url AS mailing_contact_btn_url_140,
  p0_.mailing_disclaimer AS mailing_disclaimer_141,
  p0_.child_number AS child_number_142,
  p0_.let_send_crm AS let_send_crm_143,
  p0_.crm_send_to_salesforce AS crm_send_to_salesforce_144,
  p0_.crm_origin_lead AS crm_origin_lead_145,
  p0_.seo_script_show AS seo_script_show_146,
  p0_.seo_script_generate AS seo_script_generate_147,
  p0_.seo_script_text AS seo_script_text_148,
  p0_.whatsapp_show AS whatsapp_show_149,
  p0_.whatsapp_replace AS whatsapp_replace_150,
  p0_.whatsapp_button AS whatsapp_button_151,
  p0_.whatsapp_image AS whatsapp_image_152,
  p0_.whatsapp_number AS whatsapp_number_153,
  p0_.whatsapp_message AS whatsapp_message_154,
  p0_.whatsapp_consultants_show AS whatsapp_consultants_show_155,
  p0_.whatsapp_title AS whatsapp_title_156,
  p0_.whatsapp_text AS whatsapp_text_157,
  p0_.whatsapp_help AS whatsapp_help_158,
  p0_.whatsapp_consultants_items AS whatsapp_consultants_items_159,
  p0_.id AS id_160,
  p0_.created AS created_161,
  p0_.modified AS modified_162,
  p0_.created_user AS created_user_163,
  p0_.modified_user AS modified_user_164,
  p1_.title AS title_165,
  p1_.slug AS slug_166,
  p1_.image AS image_167,
  p1_.logo AS logo_168,
  p1_.color AS color_169,
  p1_.sequence AS sequence_170,
  p1_.active AS active_171,
  p1_.open_in_list AS open_in_list_172,
  p1_.id AS id_173,
  p1_.created AS created_174,
  p1_.modified AS modified_175,
  p1_.created_user AS created_user_176,
  p1_.modified_user AS modified_user_177,
  l2_.title AS title_178,
  l2_.slug AS slug_179,
  l2_.image AS image_180,
  l2_.latitude AS latitude_181,
  l2_.longitude AS longitude_182,
  l2_.sequence AS sequence_183,
  l2_.active AS active_184,
  l2_.showtypes AS showtypes_185,
  l2_.id AS id_186,
  l2_.created AS created_187,
  l2_.modified AS modified_188,
  l2_.created_user AS created_user_189,
  l2_.modified_user AS modified_user_190,
  s3_.title AS title_191,
  s3_.slug AS slug_192,
  s3_.colour AS colour_193,
  s3_.sequence AS sequence_194,
  s3_.active AS active_195,
  s3_.id AS id_196,
  s3_.created AS created_197,
  s3_.modified AS modified_198,
  s3_.created_user AS created_user_199,
  s3_.modified_user AS modified_user_200,
  p0_.api_sap_zone_id AS api_sap_zone_id_201,
  p0_.stage_id AS stage_id_202,
  p0_.property_type_id AS property_type_id_203,
  p0_.location_id AS location_id_204,
  p0_.mother_id AS mother_id_205
FROM
  property p0_
  INNER JOIN property_type p1_ ON p0_.property_type_id = p1_.id
  INNER JOIN location l2_ ON p0_.location_id = l2_.id
  INNER JOIN stage s3_ ON p0_.stage_id = s3_.id
WHERE
  p0_.active = ?
  AND p1_.active = ?
  AND l2_.active = ?
  AND s3_.active = ?
  AND p0_.slug = ?
ORDER BY
  p0_.sequence ASC,
  p0_.title ASC

SELECT p0_.title AS title_0, p0_.titlecontacto AS titlecontacto_1, p0_.sap_zone AS sap_zone_2, p0_.sap_zone_inmobiliario AS sap_zone_inmobiliario_3, p0_.sap_code AS sap_code_4, p0_.sap_project AS sap_project_5, p0_.slug AS slug_6, p0_.template AS template_7, p0_.program AS program_8, p0_.image_list_only_image AS image_list_only_image_9, p0_.image_list_desktop AS image_list_desktop_10, p0_.image_list_mobile AS image_list_mobile_11, p0_.image_map AS image_map_12, p0_.logo_desktop AS logo_desktop_13, p0_.logo_mobile AS logo_mobile_14, p0_.image_list_url AS image_list_url_15, p0_.image_features_detail_show AS image_features_detail_show_16, p0_.image_features_detail_img_desktop AS image_features_detail_img_desktop_17, p0_.image_features_detail_img_mobile AS image_features_detail_img_mobile_18, p0_.fee_show AS fee_show_19, p0_.fee_image AS fee_image_20, p0_.fee_preffix AS fee_preffix_21, p0_.fee_price AS fee_price_22, p0_.fee_suffix AS fee_suffix_23, p0_.cash_show AS cash_show_24, p0_.cash_image AS cash_image_25, p0_.cash_preffix AS cash_preffix_26, p0_.cash_price AS cash_price_27, p0_.cash_suffix AS cash_suffix_28, p0_.list_btn_text AS list_btn_text_29, p0_.address_show AS address_show_30, p0_.address_preffix AS address_preffix_31, p0_.address_value AS address_value_32, p0_.month_show AS month_show_33, p0_.month_preffix AS month_preffix_34, p0_.month_value AS month_value_35, p0_.sequence AS sequence_36, p0_.active AS active_37, p0_.is_only_landing AS is_only_landing_38, p0_.popup_video_show AS popup_video_show_39, p0_.popup_video_hide_close_button AS popup_video_hide_close_button_40, p0_.popup_video_link AS popup_video_link_41, p0_.popup_video_duration AS popup_video_duration_42, p0_.popup_video_skip_duration AS popup_video_skip_duration_43, p0_.banners AS banners_44, p0_.banner_opacity_show AS banner_opacity_show_45, p0_.banner_embed_video_show AS banner_embed_video_show_46, p0_.banner_embed_video_type AS banner_embed_video_type_47, p0_.banner_embed_video_url AS banner_embed_video_url_48, p0_.banner_embed_video_cover AS banner_embed_video_cover_49, p0_.banner_embed_image_desktop AS banner_embed_image_desktop_50, p0_.banner_embed_image_mobile AS banner_embed_image_mobile_51, p0_.banner_embed_preffix AS banner_embed_preffix_52, p0_.banner_embed_title AS banner_embed_title_53, p0_.banner_embed_suffix AS banner_embed_suffix_54, p0_.banner_embed_logo1_show AS banner_embed_logo1_show_55, p0_.banner_embed_logo1_img AS banner_embed_logo1_img_56, p0_.banner_embed_logo2_show AS banner_embed_logo2_show_57, p0_.banner_embed_logo2_img AS banner_embed_logo2_img_58, p0_.banner_embed_btn_show AS banner_embed_btn_show_59, p0_.banner_embed_btn_text AS banner_embed_btn_text_60, p0_.banner_video_show AS banner_video_show_61, p0_.banner_video_url AS banner_video_url_62, p0_.banner_video_title AS banner_video_title_63, p0_.banner_video_preffix AS banner_video_preffix_64, p0_.banner_video_suffix AS banner_video_suffix_65, p0_.banner_video_text AS banner_video_text_66, p0_.banner_video_img AS banner_video_img_67, p0_.terms_show AS terms_show_68, p0_.terms_title AS terms_title_69, p0_.terms_text AS terms_text_70, p0_.form_show AS form_show_71, p0_.form_title AS form_title_72, p0_.form_email AS form_email_73, p0_.thank_image_show AS thank_image_show_74, p0_.thank_image AS thank_image_75, p0_.fucsia_bar_show AS fucsia_bar_show_76, p0_.common_section_show AS common_section_show_77, p0_.common_show AS common_show_78, p0_.common_title AS common_title_79, p0_.common_text AS common_text_80, p0_.gallery_show AS gallery_show_81, p0_.gallery_title AS gallery_title_82, p0_.gallery_items AS gallery_items_83, p0_.benefit_show AS benefit_show_84, p0_.benefit_show_in_map AS benefit_show_in_map_85, p0_.benefit_image AS benefit_image_86, p0_.benefit_item_image_show AS benefit_item_image_show_87, p0_.benefit_item_image AS benefit_item_image_88, p0_.benefit_title AS benefit_title_89, p0_.benefit_items AS benefit_items_90, p0_.block_video_show AS block_video_show_91, p0_.block_video_background AS block_video_background_92, p0_.block_video_image AS block_video_image_93, p0_.block_video_logo AS block_video_logo_94, p0_.block_video_title AS block_video_title_95, p0_.block_video_url AS block_video_url_96, p0_.map_show AS map_show_97, p0_.map_show_start AS map_show_start_98, p0_.map_title AS map_title_99, p0_.map_items AS map_items_100, p0_.testimonials_show AS testimonials_show_101, p0_.testimonials_title AS testimonials_title_102, p0_.testimonials_items AS testimonials_items_103, p0_.discount_show AS discount_show_104, p0_.discount_show_start AS discount_show_start_105, p0_.discount_title AS discount_title_106, p0_.discount_image_desktop AS discount_image_desktop_107, p0_.discount_image_mobile AS discount_image_mobile_108, p0_.discount_items AS discount_items_109, p0_.quote_show AS quote_show_110, p0_.quote_show_in_popup AS quote_show_in_popup_111, p0_.quote_image AS quote_image_112, p0_.quote_popup_image AS quote_popup_image_113, p0_.quote_title AS quote_title_114, p0_.quote_text AS quote_text_115, p0_.related_show AS related_show_116, p0_.related_title AS related_title_117, p0_.related_btn_text AS related_btn_text_118, p0_.popup_show AS popup_show_119, p0_.popup_image_desktop AS popup_image_desktop_120, p0_.popup_image_mobile AS popup_image_mobile_121, p0_.popup_url AS popup_url_122, p0_.popup_blank AS popup_blank_123, p0_.alert_show AS alert_show_124, p0_.alert_image_desktop AS alert_image_desktop_125, p0_.alert_image_mobile AS alert_image_mobile_126, p0_.alert_url AS alert_url_127, p0_.alert_blank AS alert_blank_128, p0_.share_whatsapp_show AS share_whatsapp_show_129, p0_.share_facebook_show AS share_facebook_show_130, p0_.share_email_show AS share_email_show_131, p0_.mailing_show AS mailing_show_132, p0_.mailing_logo AS mailing_logo_133, p0_.mailing_banner AS mailing_banner_134, p0_.mailing_greeting_title AS mailing_greeting_title_135, p0_.mailing_greeting_text AS mailing_greeting_text_136, p0_.mailing_contact_title AS mailing_contact_title_137, p0_.mailing_contact_btn_text AS mailing_contact_btn_text_138, p0_.mailing_contact_btn_image AS mailing_contact_btn_image_139, p0_.mailing_contact_btn_url AS mailing_contact_btn_url_140, p0_.mailing_disclaimer AS mailing_disclaimer_141, p0_.child_number AS child_number_142, p0_.let_send_crm AS let_send_crm_143, p0_.crm_send_to_salesforce AS crm_send_to_salesforce_144, p0_.crm_origin_lead AS crm_origin_lead_145, p0_.seo_script_show AS seo_script_show_146, p0_.seo_script_generate AS seo_script_generate_147, p0_.seo_script_text AS seo_script_text_148, p0_.whatsapp_show AS whatsapp_show_149, p0_.whatsapp_replace AS whatsapp_replace_150, p0_.whatsapp_button AS whatsapp_button_151, p0_.whatsapp_image AS whatsapp_image_152, p0_.whatsapp_number AS whatsapp_number_153, p0_.whatsapp_message AS whatsapp_message_154, p0_.whatsapp_consultants_show AS whatsapp_consultants_show_155, p0_.whatsapp_title AS whatsapp_title_156, p0_.whatsapp_text AS whatsapp_text_157, p0_.whatsapp_help AS whatsapp_help_158, p0_.whatsapp_consultants_items AS whatsapp_consultants_items_159, p0_.id AS id_160, p0_.created AS created_161, p0_.modified AS modified_162, p0_.created_user AS created_user_163, p0_.modified_user AS modified_user_164, p1_.title AS title_165, p1_.slug AS slug_166, p1_.image AS image_167, p1_.logo AS logo_168, p1_.color AS color_169, p1_.sequence AS sequence_170, p1_.active AS active_171, p1_.open_in_list AS open_in_list_172, p1_.id AS id_173, p1_.created AS created_174, p1_.modified AS modified_175, p1_.created_user AS created_user_176, p1_.modified_user AS modified_user_177, l2_.title AS title_178, l2_.slug AS slug_179, l2_.image AS image_180, l2_.latitude AS latitude_181, l2_.longitude AS longitude_182, l2_.sequence AS sequence_183, l2_.active AS active_184, l2_.showtypes AS showtypes_185, l2_.id AS id_186, l2_.created AS created_187, l2_.modified AS modified_188, l2_.created_user AS created_user_189, l2_.modified_user AS modified_user_190, s3_.title AS title_191, s3_.slug AS slug_192, s3_.colour AS colour_193, s3_.sequence AS sequence_194, s3_.active AS active_195, s3_.id AS id_196, s3_.created AS created_197, s3_.modified AS modified_198, s3_.created_user AS created_user_199, s3_.modified_user AS modified_user_200, p0_.api_sap_zone_id AS api_sap_zone_id_201, p0_.stage_id AS stage_id_202, p0_.property_type_id AS property_type_id_203, p0_.location_id AS location_id_204, p0_.mother_id AS mother_id_205 FROM property p0_ INNER JOIN property_type p1_ ON p0_.property_type_id = p1_.id INNER JOIN location l2_ ON p0_.location_id = l2_.id INNER JOIN stage s3_ ON p0_.stage_id = s3_.id WHERE p0_.active = 1 AND p1_.active = 1 AND l2_.active = 1 AND s3_.active = 1 AND p0_.slug = 'los-ficus-de-carabayllo' ORDER BY p0_.sequence ASC, p0_.title ASC;