Symfony Profiler

[
  "route" => "detail_page"
  "route_parameters" => [
    "_route" => "detail_page"
    "lang" => "fr"
    "_controller" => "App\Controller\MainController::detailPage"
    "operacio" => "acheter"
    "supertipus" => "habitatges"
    "province" => "barcelona"
    "locality" => "badalona"
    "id" => "18"
  ]
  "request_uri" => "https://webprof.tridenia.es/fr/acheter/habitatges/barcelona/badalona/18"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "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\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "host" => "tridenia.cluster-cdx46d7cizxf.eu-west-1.rds.amazonaws.com"
    "port" => 3306
    "user" => "tecnoapi"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "5.7"
    "defaultTableOptions" => []
    "dbname" => "bd_agency_a13096"
  ]
]

[
  "sql" => "INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => 0
    2 => "1122b1127dd203a4c9a07c01fee8dd2bcf618d3c"
    3 => "/fr/acheter/habitatges/barcelona/badalona/18"
    4 => "2026-06-19 18:03:30"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "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"
  "listener" => "App\EventSubscriber\PageSubscriber::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"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3 FROM api_menu t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.google AS google_9, t0.linkedin AS linkedin_10, t0.instagram AS instagram_11, t0.tiktok AS tiktok_12, t0.youtube AS youtube_13, t0.logo AS logo_14, t0.logo_movile_email AS logo_movile_email_15, t0.logo_contact AS logo_contact_16, t0.logo_fav AS logo_fav_17, t0.logo_aicat AS logo_aicat_18, t0.logo_agente AS logo_agente_19, t0.logo_miembro AS logo_miembro_20, t0.banner AS banner_21, t0.banner_url AS banner_url_22, t0.default_list_properties AS default_list_properties_23, t0.user AS user_24, t0.password AS password_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.primary_foot_1 AS primary_foot_1_28, t0.primary_foot_2 AS primary_foot_2_29, t0.filter_header AS filter_header_30, t0.newsletter AS newsletter_31, t0.first_time AS first_time_32, t0.activation AS activation_33, t0.roles AS roles_34 FROM api_agency t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id_colegiado AS id_colegiado_2, t0.id_despacho AS id_despacho_3, t0.provincia AS provincia_4, t0.localidad AS localidad_5, t0.zona AS zona_6, t0.cod_postal AS cod_postal_7, t0.direccion AS direccion_8, t0.obra_nueva AS obra_nueva_9, t0.alquiler AS alquiler_10, t0.es_subhasta AS es_subhasta_11, t0.es_lloguer_temporada AS es_lloguer_temporada_12, t0.es_banc AS es_banc_13, t0.superf_util AS superf_util_14, t0.superf_constr AS superf_constr_15, t0.agencia AS agencia_16, t0.referencia AS referencia_17, t0.glat AS glat_18, t0.glon AS glon_19, t0.ref_catastral AS ref_catastral_20, t0.num_fotos AS num_fotos_21, t0.id_tipo_via AS id_tipo_via_22, t0.situacion_concreta AS situacion_concreta_23, t0.precio_alquiler AS precio_alquiler_24, t0.precio_alquiler_anterior AS precio_alquiler_anterior_25, t0.precio AS precio_26, t0.precio_anterior AS precio_anterior_27, t0.rebajado AS rebajado_28, t0.precio_subhasta AS precio_subhasta_29, t0.precio_subhasta_anterior AS precio_subhasta_anterior_30, t0.precio_alquiler_temporada AS precio_alquiler_temporada_31, t0.precio_alquiler_temporada_anterior AS precio_alquiler_temporada_anterior_32, t0.estado AS estado_33, t0.contrato_exclusividad AS contrato_exclusividad_34, t0.idportal AS idportal_35, t0.fecha_creacion AS fecha_creacion_36, t0.fecha_importacion AS fecha_importacion_37, t0.fecha_caducidad AS fecha_caducidad_38, t0.fecha_update AS fecha_update_39, t0.fecha_disponibilidad AS fecha_disponibilidad_40, t0.id_properties_subtype AS id_properties_subtype_41, t0.id_properties_type AS id_properties_type_42, t0.id_properties_supertype AS id_properties_supertype_43, t0.num_dorm AS num_dorm_44, t0.contactos AS contactos_45, t0.visitas AS visitas_46, t0.disponible AS disponible_47, t0.visibilidad AS visibilidad_48, t0.destacado AS destacado_49 FROM api_properties t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => "18"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0"
]

[
  "sql" => "SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0 WHERE t0.predeterminado = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0 WHERE t0.cod = ? LIMIT 1"
  "params" => [
    1 => "fr"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.order_page AS order_page_2, t0.page_id AS page_id_3, t0.menu_id AS menu_id_4, t0.parent_id AS parent_id_5 FROM api_order_pages t0 WHERE t0.menu_id = ? ORDER BY t0.order_page ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 21
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 137
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 137
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 141
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 141
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 145
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 145
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 149
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 99760
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 149
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 99999
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 63
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 88190
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 70840
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "fr"
    2 => 60722
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT identificador, valor_fr as texto FROM textos"
]

[
  "sql" => "SELECT slug, text FROM api_agency_description WHERE lang = 'fr'"
]

[
  "sql" => "SELECT identificador, valor_fr as texto FROM textos WHERE identificador in ('hipoteca_en','fitxa_de','text_a','en_tramite')"
]

[
  "sql" => "SELECT CONCAT('https://imagenes.ghestia.cat/images/webs//', url) AS url FROM api_properties_certificates_images WHERE id_property = '18'"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.glat AS glat_3, t0.glon AS glon_4 FROM api_locations_gps t0 WHERE t0.glat = ? AND t0.glon = ? LIMIT 1"
  "params" => [
    1 => "41.438886"
    2 => "2.2433103"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT pf.id_property,pf.id_feature,pf.id_feature_type,COALESCE(dict.value, pf.value) as value,f.*,f.id as idfeature,fi.*,fv.name as nombre \n
            \t\tFROM api_properties_features pf INNER JOIN api_features f ON pf.id_feature = f.id\n
                    LEFT JOIN api_features_i18n fi ON f.id = fi.id \n
                    LEFT JOIN api_features_values fv ON f.id = fv.feature\n
                    LEFT JOIN api_features_dictionary_i18n dict ON dict.feature = pf.value AND dict.cod_lang = 'fr_FR'\n
                    WHERE pf.id_property = '18'\n
                    AND fi.cod_lang = 'fr_FR'\n
                    GROUP BY f.id
    """
]

[
  "sql" => """
    SELECT api_features.id, api_features.type, api_features_i18n.text as name, api_properties_features.value \n
                    FROM api_features \n
                    LEFT JOIN api_properties_features ON api_properties_features.id_feature = api_features.id AND api_properties_features.id_property = '18'\n
                    LEFT JOIN api_features_i18n ON api_features_i18n.id = api_features.id AND api_features_i18n.cod_lang = 'fr_FR'\n
                    WHERE api_features.id IN (749, 750)
    """
]

[
  "sql" => "SELECT t0.id AS id_1, t0.location AS location_2, t0.name AS name_3, t0.friendly AS friendly_4, t0.coord AS coord_5 FROM api_zones t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.province AS province_2, t0.name AS name_3, t0.friendly AS friendly_4, t0.num_immobles_cerca_rapida AS num_immobles_cerca_rapida_5, t0.orden AS orden_6, t0.seo_home AS seo_home_7, t0.zoom AS zoom_8 FROM api_locations t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 3423
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.country AS country_2, t0.autonomousCommunity AS autonomousCommunity_3, t0.name AS name_4, t0.friendly AS friendly_5 FROM api_provinces t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 33
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.cod_lang AS cod_lang_2, t0.text AS text_3 FROM api_properties_types_i18n t0 WHERE t0.id = ? AND t0.cod_lang = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "fr_FR"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT friendly_FR as friendly FROM tipus_operacio WHERE codi = 2 LIMIT 1"
]

[
  "sql" => "SELECT * FROM api_properties p LEFT JOIN api_properties_i18n i ON p.id=i.id WHERE p.id=18 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.cod_lang AS cod_lang_2, t0.anuncio AS anuncio_3 FROM api_properties_i18n t0 WHERE t0.id = ? AND t0.cod_lang = ? LIMIT 1"
  "params" => [
    1 => 18
    2 => "fr_FR"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM api_properties WHERE precio >= 619000 LIMIT 1"
]

[
  "sql" => "SELECT * FROM preus_compra_cerca WHERE preu <= 639000 ORDER BY id DESC LIMIT 1"
]

[
  "sql" => """
    SELECT bi.*, des.telef1  ,bi18.anuncio AS descrip\n
    \t\t\t\t\t\t\t,IF (superf_constr != '' AND superf_constr != '00' AND superf_constr !='0' , superf_constr, superf_util) AS superficie,\n
    \t\t\t\t\t\t\t IF (precio_alquiler > 0, precio_alquiler, precio) AS preu  \t,bi.id_properties_subtype AS id_tipus,\n
    \t\t\t IF(bi.es_lloguer_temporada = 1, 7,\n
                    IF(bi.es_banc = 1, 4,\n
                        IF(bi.obra_nueva = 1, 3,\n
                            IF(bi.alquiler = 1, 1, 2)\n
                        )\n
                    )\n
                ) operation,\n
                apitype.text as tipo_nombre FROM api_properties as bi  LEFT JOIN api_properties_i18n AS bi18 ON (bi.id = bi18.id) AND bi18.cod_lang = '' \n
    \t\t        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens\n
    \t\t        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens\n
    \t\t        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens\n
    \t\t        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = '' WHERE  (IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE) = TRUE)    AND ((IF(bi.obra_nueva=1 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE) OR (IF(bi.obra_nueva=0 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE))  AND bi.num_fotos > 0  AND   bi.localidad = '3423'  AND   if(bi.superf_constr,bi.superf_constr >= 121,bi.superf_util >= 121)  AND   if(bi.superf_constr,bi.superf_constr <= 160,bi.superf_util <= 160)  GROUP BY bi.id  ORDER BY  bi.id DESC  LIMIT 5
    """
]

[
  "sql" => "SELECT link_video FROM api_properties_video WHERE id_property = '18' AND (link_video LIKE '%tour.feelestate.com%' OR link_video LIKE '%inmovriew%' OR link_video LIKE '%floorfy%' OR link_video LIKE '%viewer.realisti.co%' OR link_video LIKE '%storage.net-fs.com%' OR link_video LIKE '%matterport.com%' )"
]

[
  "sql" => "SELECT banner, banner_url FROM api_agency"
]

[
  "sql" => "SELECT codi FROM tipus_operacio WHERE friendly_ca = 'acheter' LIMIT 1"
]

[
  "sql" => "SELECT friendly_ca FROM tipus_operacio WHERE codi = '2' LIMIT 1"
]

[
  "sql" => "SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'habitatges'"
]

[
  "sql" => "SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'ca_ES' LIMIT 1"
]

[
  "sql" => "SELECT codi FROM tipus_operacio WHERE friendly_en = 'acheter' LIMIT 1"
]

[
  "sql" => "SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'habitatges'"
]

[
  "sql" => "SELECT friendly_en FROM tipus_operacio WHERE codi = '2' LIMIT 1"
]

[
  "sql" => "SELECT codi FROM tipus_operacio WHERE friendly_es = 'acheter' LIMIT 1"
]

[
  "sql" => "SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'en_US' LIMIT 1"
]

[
  "sql" => "SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'habitatges'"
]

[
  "sql" => "SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'es_ES' LIMIT 1"
]

[
  "sql" => "SELECT friendly_es FROM tipus_operacio WHERE codi = '2' LIMIT 1"
]

[
  "sql" => "SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'habitatges'"
]

[
  "sql" => "SELECT codi FROM tipus_operacio WHERE friendly_fr = 'acheter' LIMIT 1"
]

[
  "sql" => "SELECT friendly_fr FROM tipus_operacio WHERE codi = '2' LIMIT 1"
]

[
  "sql" => "SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'fr_FR' LIMIT 1"
]

[
  "sql" => "SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'habitatges'"
]

[
  "sql" => "SELECT codi FROM tipus_operacio WHERE friendly_fr = 'acheter' LIMIT 1"
]

[
  "sql" => "SELECT friendly_fr FROM tipus_operacio WHERE codi = '2' LIMIT 1"
]

[
  "sql" => "SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'fr_FR' LIMIT 1"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]