{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "5e6e51"
    },
    "request_uri": "https://portales-vivienda.staff.digital/_profiler/5e6e51?panel=exception",
    "method": "GET"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventSubscriber\\UrlEventSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Stof\\DoctrineExtensionsBundle\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onLateKernelRequest"
}

{
    "params": {
        "driver": "pdo_mysql",
        "charset": "utf8mb4",
        "host": "localhost",
        "port": "3306",
        "dbname": "staff_portales_vivienda_2",
        "user": "staff_php2",
        "password": "<redacted>",
        "driverOptions": [],
        "defaultTableOptions": []
    }
}

{
    "sql": "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 = ?",
    "params": {
        "1": 1
    },
    "types": {
        "1": 1
    }
}

{
    "sql": "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 = ?",
    "params": {
        "1": 1
    },
    "types": {
        "1": 1
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 1,
        "5": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5,
        "5": 5
    }
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\CityEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventSubscriber\\UrlEventSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Stof\\DoctrineExtensionsBundle\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onLateKernelRequest"
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 1,
        "5": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5,
        "5": 5
    }
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\CityEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\RememberMe\\ResponseListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\StreamedResponseListener::onKernelResponse"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventSubscriber\\UrlEventSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Stof\\DoctrineExtensionsBundle\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onLateKernelRequest"
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 1,
        "5": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5,
        "5": 5
    }
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\CityEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\RememberMe\\ResponseListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}

{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\StreamedResponseListener::onKernelResponse"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}

{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}

{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventSubscriber\\UrlEventSubscriber::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "Stof\\DoctrineExtensionsBundle\\EventListener\\LocaleListener::onKernelRequest"
}

{
    "event": "kernel.request",
    "listener": "App\\EventListener\\DoctrineTranslatableListener::onLateKernelRequest"
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5
    }
}

{
    "sql": "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",
    "params": {
        "1": 1,
        "2": 1,
        "3": 1,
        "4": 1,
        "5": 0
    },
    "types": {
        "1": 5,
        "2": 5,
        "3": 5,
        "4": 5,
        "5": 5
    }
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\CityEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "App\\EventSubscriber\\TwigEventSubscriber::onControllerEvent"
}

{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ControllerListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\HttpCacheListener::onKernelController"
}

{
    "event": "kernel.controller",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\TemplateListener::onKernelController"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\SecurityListener::onKernelControllerArguments"
}

{
    "event": "kernel.controller_arguments",
    "listener": "Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\IsGrantedListener::onKernelControllerArguments"
}