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
  t0.title AS title_1,
  t0.menu_items AS menu_items_2,
  t0.menu_contact_us AS menu_contact_us_3,
  t0.menu_common_areas AS menu_common_areas_4,
  t0.menu_gallery AS menu_gallery_5,
  t0.menu_benefit AS menu_benefit_6,
  t0.menu_location AS menu_location_7,
  t0.menu_share AS menu_share_8,
  t0.policy_title AS policy_title_9,
  t0.policy_text AS policy_text_10,
  t0.personal_information_title AS personal_information_title_11,
  t0.personal_information__text AS personal_information__text_12,
  t0.communications_policy_title AS communications_policy_title_13,
  t0.communications_policy__text AS communications_policy__text_14,
  t0.option_page_title AS option_page_title_15,
  t0.option_casas_only_image AS option_casas_only_image_16,
  t0.option_casas_image AS option_casas_image_17,
  t0.option_casas_title AS option_casas_title_18,
  t0.option_casas_text AS option_casas_text_19,
  t0.option_casas_url AS option_casas_url_20,
  t0.option_casas_sequence AS option_casas_sequence_21,
  t0.option_casas_with_opacity AS option_casas_with_opacity_22,
  t0.option_lotes_only_image AS option_lotes_only_image_23,
  t0.option_lotes_image AS option_lotes_image_24,
  t0.option_lotes_title AS option_lotes_title_25,
  t0.option_lotes_text AS option_lotes_text_26,
  t0.option_lotes_url AS option_lotes_url_27,
  t0.option_lotes_sequence AS option_lotes_sequence_28,
  t0.option_lotes_with_opacity AS option_lotes_with_opacity_29,
  t0.option_techo_only_image AS option_techo_only_image_30,
  t0.option_techo_image AS option_techo_image_31,
  t0.option_techo_title AS option_techo_title_32,
  t0.option_techo_text AS option_techo_text_33,
  t0.option_techo_url AS option_techo_url_34,
  t0.option_techo_sequence AS option_techo_sequence_35,
  t0.option_techo_with_opacity AS option_techo_with_opacity_36,
  t0.map_page_house_title AS map_page_house_title_37,
  t0.map_page_house_image AS map_page_house_image_38,
  t0.map_page_house_list_show AS map_page_house_list_show_39,
  t0.map_piura_techo_title AS map_piura_techo_title_40,
  t0.map_piura_techo_image AS map_piura_techo_image_41,
  t0.map_ica_lot_title AS map_ica_lot_title_42,
  t0.map_ica_lot_image AS map_ica_lot_image_43,
  t0.map_chiclayo_lot_title AS map_chiclayo_lot_title_44,
  t0.map_chiclayo_lot_image AS map_chiclayo_lot_image_45,
  t0.map_chiclayo_list_show AS map_chiclayo_list_show_46,
  t0.option_asia_page_title AS option_asia_page_title_47,
  t0.option_asia_cond_only_image AS option_asia_cond_only_image_48,
  t0.option_asia_cond_image AS option_asia_cond_image_49,
  t0.option_asia_cond_url AS option_asia_cond_url_50,
  t0.option_asia_cond_title AS option_asia_cond_title_51,
  t0.option_asia_cond_text AS option_asia_cond_text_52,
  t0.option_asia_cond_sequence AS option_asia_cond_sequence_53,
  t0.option_asia_cond_with_opacity AS option_asia_cond_with_opacity_54,
  t0.option_asia_lotes_only_image AS option_asia_lotes_only_image_55,
  t0.option_asia_lotes_image AS option_asia_lotes_image_56,
  t0.option_asia_lotes_url AS option_asia_lotes_url_57,
  t0.option_asia_lotes_title AS option_asia_lotes_title_58,
  t0.option_asia_lotes_text AS option_asia_lotes_text_59,
  t0.option_asia_lotes_sequence AS option_asia_lotes_sequence_60,
  t0.option_asia_lotes_with_opacity AS option_asia_lotes_with_opacity_61,
  t0.option_chilca_page_title AS option_chilca_page_title_62,
  t0.option_chilca_lotes_only_image AS option_chilca_lotes_only_image_63,
  t0.option_chilca_lotes_image AS option_chilca_lotes_image_64,
  t0.option_chilca_lotes_url AS option_chilca_lotes_url_65,
  t0.option_chilca_lotes_title AS option_chilca_lotes_title_66,
  t0.option_chilca_lotes_text AS option_chilca_lotes_text_67,
  t0.option_chilca_lotes_sequence AS option_chilca_lotes_sequence_68,
  t0.option_chilca_lotes_with_opacity AS option_chilca_lotes_with_opacity_69,
  t0.option_chilca_casas_only_image AS option_chilca_casas_only_image_70,
  t0.option_chilca_casas_image AS option_chilca_casas_image_71,
  t0.option_chilca_casas_url AS option_chilca_casas_url_72,
  t0.option_chilca_casas_title AS option_chilca_casas_title_73,
  t0.option_chilca_casas_text AS option_chilca_casas_text_74,
  t0.option_chilca_casas_sequence AS option_chilca_casas_sequence_75,
  t0.option_chilca_casas_with_opacity AS option_chilca_casas_with_opacity_76,
  t0.option_chiclayo_page_title AS option_chiclayo_page_title_77,
  t0.option_chiclayo_lotes_only_image AS option_chiclayo_lotes_only_image_78,
  t0.option_chiclayo_lotes_image AS option_chiclayo_lotes_image_79,
  t0.option_chiclayo_lotes_url AS option_chiclayo_lotes_url_80,
  t0.option_chiclayo_lotes_title AS option_chiclayo_lotes_title_81,
  t0.option_chiclayo_lotes_text AS option_chiclayo_lotes_text_82,
  t0.option_chiclayo_lotes_sequence AS option_chiclayo_lotes_sequence_83,
  t0.option_chiclayo_lotes_with_opacity AS option_chiclayo_lotes_with_opacity_84,
  t0.option_chiclayo_casas_only_image AS option_chiclayo_casas_only_image_85,
  t0.option_chiclayo_casas_image AS option_chiclayo_casas_image_86,
  t0.option_chiclayo_casas_url AS option_chiclayo_casas_url_87,
  t0.option_chiclayo_casas_title AS option_chiclayo_casas_title_88,
  t0.option_chiclayo_casas_text AS option_chiclayo_casas_text_89,
  t0.option_chiclayo_casas_sequence AS option_chiclayo_casas_sequence_90,
  t0.option_chiclayo_casas_with_opacity AS option_chiclayo_casas_with_opacity_91,
  t0.option_ica_page_title AS option_ica_page_title_92,
  t0.option_ica_lotes_only_image AS option_ica_lotes_only_image_93,
  t0.option_ica_lotes_image AS option_ica_lotes_image_94,
  t0.option_ica_lotes_url AS option_ica_lotes_url_95,
  t0.option_ica_lotes_title AS option_ica_lotes_title_96,
  t0.option_ica_lotes_text AS option_ica_lotes_text_97,
  t0.option_ica_lotes_sequence AS option_ica_lotes_sequence_98,
  t0.option_ica_lotes_with_opacity AS option_ica_lotes_with_opacity_99,
  t0.option_ica_casas_only_image AS option_ica_casas_only_image_100,
  t0.option_ica_casas_image AS option_ica_casas_image_101,
  t0.option_ica_casas_url AS option_ica_casas_url_102,
  t0.option_ica_casas_title AS option_ica_casas_title_103,
  t0.option_ica_casas_text AS option_ica_casas_text_104,
  t0.option_ica_casas_sequence AS option_ica_casas_sequence_105,
  t0.option_ica_casas_with_opacity AS option_ica_casas_with_opacity_106,
  t0.option_ica_techo_only_image AS option_ica_techo_only_image_107,
  t0.option_ica_techo_image AS option_ica_techo_image_108,
  t0.option_ica_techo_url AS option_ica_techo_url_109,
  t0.option_ica_techo_title AS option_ica_techo_title_110,
  t0.option_ica_techo_text AS option_ica_techo_text_111,
  t0.option_ica_techo_sequence AS option_ica_techo_sequence_112,
  t0.option_ica_techo_with_opacity AS option_ica_techo_with_opacity_113,
  t0.option_lambayeque_page_title AS option_lambayeque_page_title_114,
  t0.option_lambayeque_lotes_only_image AS option_lambayeque_lotes_only_image_115,
  t0.option_lambayeque_lotes_image AS option_lambayeque_lotes_image_116,
  t0.option_lambayeque_lotes_url AS option_lambayeque_lotes_url_117,
  t0.option_lambayeque_lotes_title AS option_lambayeque_lotes_title_118,
  t0.option_lambayeque_lotes_text AS option_lambayeque_lotes_text_119,
  t0.option_lambayeque_lotes_sequence AS option_lambayeque_lotes_sequence_120,
  t0.option_lambayeque_lotes_with_opacity AS option_lambayeque_lotes_with_opacity_121,
  t0.option_lambayeque_casas_only_image AS option_lambayeque_casas_only_image_122,
  t0.option_lambayeque_casas_image AS option_lambayeque_casas_image_123,
  t0.option_lambayeque_casas_url AS option_lambayeque_casas_url_124,
  t0.option_lambayeque_casas_title AS option_lambayeque_casas_title_125,
  t0.option_lambayeque_casas_text AS option_lambayeque_casas_text_126,
  t0.option_lambayeque_casas_sequence AS option_lambayeque_casas_sequence_127,
  t0.option_lambayeque_casas_with_opacity AS option_lambayeque_casas_with_opacity_128,
  t0.id AS id_129,
  t0.created AS created_130,
  t0.modified AS modified_131,
  t0.created_user AS created_user_132,
  t0.modified_user AS modified_user_133
FROM
  info_property t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.menu_items AS menu_items_2, t0.menu_contact_us AS menu_contact_us_3, t0.menu_common_areas AS menu_common_areas_4, t0.menu_gallery AS menu_gallery_5, t0.menu_benefit AS menu_benefit_6, t0.menu_location AS menu_location_7, t0.menu_share AS menu_share_8, t0.policy_title AS policy_title_9, t0.policy_text AS policy_text_10, t0.personal_information_title AS personal_information_title_11, t0.personal_information__text AS personal_information__text_12, t0.communications_policy_title AS communications_policy_title_13, t0.communications_policy__text AS communications_policy__text_14, t0.option_page_title AS option_page_title_15, t0.option_casas_only_image AS option_casas_only_image_16, t0.option_casas_image AS option_casas_image_17, t0.option_casas_title AS option_casas_title_18, t0.option_casas_text AS option_casas_text_19, t0.option_casas_url AS option_casas_url_20, t0.option_casas_sequence AS option_casas_sequence_21, t0.option_casas_with_opacity AS option_casas_with_opacity_22, t0.option_lotes_only_image AS option_lotes_only_image_23, t0.option_lotes_image AS option_lotes_image_24, t0.option_lotes_title AS option_lotes_title_25, t0.option_lotes_text AS option_lotes_text_26, t0.option_lotes_url AS option_lotes_url_27, t0.option_lotes_sequence AS option_lotes_sequence_28, t0.option_lotes_with_opacity AS option_lotes_with_opacity_29, t0.option_techo_only_image AS option_techo_only_image_30, t0.option_techo_image AS option_techo_image_31, t0.option_techo_title AS option_techo_title_32, t0.option_techo_text AS option_techo_text_33, t0.option_techo_url AS option_techo_url_34, t0.option_techo_sequence AS option_techo_sequence_35, t0.option_techo_with_opacity AS option_techo_with_opacity_36, t0.map_page_house_title AS map_page_house_title_37, t0.map_page_house_image AS map_page_house_image_38, t0.map_page_house_list_show AS map_page_house_list_show_39, t0.map_piura_techo_title AS map_piura_techo_title_40, t0.map_piura_techo_image AS map_piura_techo_image_41, t0.map_ica_lot_title AS map_ica_lot_title_42, t0.map_ica_lot_image AS map_ica_lot_image_43, t0.map_chiclayo_lot_title AS map_chiclayo_lot_title_44, t0.map_chiclayo_lot_image AS map_chiclayo_lot_image_45, t0.map_chiclayo_list_show AS map_chiclayo_list_show_46, t0.option_asia_page_title AS option_asia_page_title_47, t0.option_asia_cond_only_image AS option_asia_cond_only_image_48, t0.option_asia_cond_image AS option_asia_cond_image_49, t0.option_asia_cond_url AS option_asia_cond_url_50, t0.option_asia_cond_title AS option_asia_cond_title_51, t0.option_asia_cond_text AS option_asia_cond_text_52, t0.option_asia_cond_sequence AS option_asia_cond_sequence_53, t0.option_asia_cond_with_opacity AS option_asia_cond_with_opacity_54, t0.option_asia_lotes_only_image AS option_asia_lotes_only_image_55, t0.option_asia_lotes_image AS option_asia_lotes_image_56, t0.option_asia_lotes_url AS option_asia_lotes_url_57, t0.option_asia_lotes_title AS option_asia_lotes_title_58, t0.option_asia_lotes_text AS option_asia_lotes_text_59, t0.option_asia_lotes_sequence AS option_asia_lotes_sequence_60, t0.option_asia_lotes_with_opacity AS option_asia_lotes_with_opacity_61, t0.option_chilca_page_title AS option_chilca_page_title_62, t0.option_chilca_lotes_only_image AS option_chilca_lotes_only_image_63, t0.option_chilca_lotes_image AS option_chilca_lotes_image_64, t0.option_chilca_lotes_url AS option_chilca_lotes_url_65, t0.option_chilca_lotes_title AS option_chilca_lotes_title_66, t0.option_chilca_lotes_text AS option_chilca_lotes_text_67, t0.option_chilca_lotes_sequence AS option_chilca_lotes_sequence_68, t0.option_chilca_lotes_with_opacity AS option_chilca_lotes_with_opacity_69, t0.option_chilca_casas_only_image AS option_chilca_casas_only_image_70, t0.option_chilca_casas_image AS option_chilca_casas_image_71, t0.option_chilca_casas_url AS option_chilca_casas_url_72, t0.option_chilca_casas_title AS option_chilca_casas_title_73, t0.option_chilca_casas_text AS option_chilca_casas_text_74, t0.option_chilca_casas_sequence AS option_chilca_casas_sequence_75, t0.option_chilca_casas_with_opacity AS option_chilca_casas_with_opacity_76, t0.option_chiclayo_page_title AS option_chiclayo_page_title_77, t0.option_chiclayo_lotes_only_image AS option_chiclayo_lotes_only_image_78, t0.option_chiclayo_lotes_image AS option_chiclayo_lotes_image_79, t0.option_chiclayo_lotes_url AS option_chiclayo_lotes_url_80, t0.option_chiclayo_lotes_title AS option_chiclayo_lotes_title_81, t0.option_chiclayo_lotes_text AS option_chiclayo_lotes_text_82, t0.option_chiclayo_lotes_sequence AS option_chiclayo_lotes_sequence_83, t0.option_chiclayo_lotes_with_opacity AS option_chiclayo_lotes_with_opacity_84, t0.option_chiclayo_casas_only_image AS option_chiclayo_casas_only_image_85, t0.option_chiclayo_casas_image AS option_chiclayo_casas_image_86, t0.option_chiclayo_casas_url AS option_chiclayo_casas_url_87, t0.option_chiclayo_casas_title AS option_chiclayo_casas_title_88, t0.option_chiclayo_casas_text AS option_chiclayo_casas_text_89, t0.option_chiclayo_casas_sequence AS option_chiclayo_casas_sequence_90, t0.option_chiclayo_casas_with_opacity AS option_chiclayo_casas_with_opacity_91, t0.option_ica_page_title AS option_ica_page_title_92, t0.option_ica_lotes_only_image AS option_ica_lotes_only_image_93, t0.option_ica_lotes_image AS option_ica_lotes_image_94, t0.option_ica_lotes_url AS option_ica_lotes_url_95, t0.option_ica_lotes_title AS option_ica_lotes_title_96, t0.option_ica_lotes_text AS option_ica_lotes_text_97, t0.option_ica_lotes_sequence AS option_ica_lotes_sequence_98, t0.option_ica_lotes_with_opacity AS option_ica_lotes_with_opacity_99, t0.option_ica_casas_only_image AS option_ica_casas_only_image_100, t0.option_ica_casas_image AS option_ica_casas_image_101, t0.option_ica_casas_url AS option_ica_casas_url_102, t0.option_ica_casas_title AS option_ica_casas_title_103, t0.option_ica_casas_text AS option_ica_casas_text_104, t0.option_ica_casas_sequence AS option_ica_casas_sequence_105, t0.option_ica_casas_with_opacity AS option_ica_casas_with_opacity_106, t0.option_ica_techo_only_image AS option_ica_techo_only_image_107, t0.option_ica_techo_image AS option_ica_techo_image_108, t0.option_ica_techo_url AS option_ica_techo_url_109, t0.option_ica_techo_title AS option_ica_techo_title_110, t0.option_ica_techo_text AS option_ica_techo_text_111, t0.option_ica_techo_sequence AS option_ica_techo_sequence_112, t0.option_ica_techo_with_opacity AS option_ica_techo_with_opacity_113, t0.option_lambayeque_page_title AS option_lambayeque_page_title_114, t0.option_lambayeque_lotes_only_image AS option_lambayeque_lotes_only_image_115, t0.option_lambayeque_lotes_image AS option_lambayeque_lotes_image_116, t0.option_lambayeque_lotes_url AS option_lambayeque_lotes_url_117, t0.option_lambayeque_lotes_title AS option_lambayeque_lotes_title_118, t0.option_lambayeque_lotes_text AS option_lambayeque_lotes_text_119, t0.option_lambayeque_lotes_sequence AS option_lambayeque_lotes_sequence_120, t0.option_lambayeque_lotes_with_opacity AS option_lambayeque_lotes_with_opacity_121, t0.option_lambayeque_casas_only_image AS option_lambayeque_casas_only_image_122, t0.option_lambayeque_casas_image AS option_lambayeque_casas_image_123, t0.option_lambayeque_casas_url AS option_lambayeque_casas_url_124, t0.option_lambayeque_casas_title AS option_lambayeque_casas_title_125, t0.option_lambayeque_casas_text AS option_lambayeque_casas_text_126, t0.option_lambayeque_casas_sequence AS option_lambayeque_casas_sequence_127, t0.option_lambayeque_casas_with_opacity AS option_lambayeque_casas_with_opacity_128, t0.id AS id_129, t0.created AS created_130, t0.modified AS modified_131, t0.created_user AS created_user_132, t0.modified_user AS modified_user_133 FROM info_property t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.image_list_url AS image_list_url_2,
  p0_.image_list_only_image AS image_list_only_image_3,
  p0_.image_list_desktop AS image_list_desktop_4,
  p0_.image_list_mobile AS image_list_mobile_5,
  p0_.title AS title_6,
  p0_.fee_preffix AS fee_preffix_7,
  p0_.fee_price AS fee_price_8,
  p0_.fee_suffix AS fee_suffix_9,
  p0_.list_btn_text AS list_btn_text_10,
  p1_.title AS title_11,
  l2_.title AS title_12,
  s3_.colour AS colour_13,
  s3_.title AS title_14,
  s4_.project_desc AS project_desc_15,
  s4_.square_desc AS square_desc_16
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
  INNER JOIN sap_zone s4_ ON p0_.api_sap_zone_id = s4_.id
WHERE
  p0_.active = ?
  AND p0_.is_only_landing = ?
  AND p1_.active = ?
  AND l2_.active = ?
  AND s3_.active = ?
  AND p1_.slug = ?
ORDER BY
  p0_.sequence ASC,
  p0_.title ASC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.image_list_url AS image_list_url_2, p0_.image_list_only_image AS image_list_only_image_3, p0_.image_list_desktop AS image_list_desktop_4, p0_.image_list_mobile AS image_list_mobile_5, p0_.title AS title_6, p0_.fee_preffix AS fee_preffix_7, p0_.fee_price AS fee_price_8, p0_.fee_suffix AS fee_suffix_9, p0_.list_btn_text AS list_btn_text_10, p1_.title AS title_11, l2_.title AS title_12, s3_.colour AS colour_13, s3_.title AS title_14, s4_.project_desc AS project_desc_15, s4_.square_desc AS square_desc_16 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 INNER JOIN sap_zone s4_ ON p0_.api_sap_zone_id = s4_.id WHERE p0_.active = 1 AND p0_.is_only_landing = 0 AND p1_.active = 1 AND l2_.active = 1 AND s3_.active = 1 AND p1_.slug = 'casas-techo-propio' ORDER BY p0_.sequence ASC, p0_.title ASC;