Symfony Profiler

[
  "route" => "listeOffreNatureTypeVille"
  "route_parameters" => [
    "_route" => "listeOffreNatureTypeVille"
    "_controller" => "App\Controller\Front\OffresController::listeOffreNatureTypeVille"
    "nomPage" => "-immobilier"
    "nature" => "vente"
    "type" => "entrepots-locaux-d-activites"
    "ville" => "meyzieu-69330"
  ]
  "request_uri" => "https://preprod.evolis-ie.com/offres-immobilier/vente/entrepots-locaux-d-activites/meyzieu-69330/"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "evolisd25.mysql.db"
    "port" => 3306
    "user" => "evolisd25"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "evolisd25"
    "serverVersion" => "15"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.url_liste AS url_liste_5, t0.url_detail AS url_detail_6, t0.h1_liste AS h1_liste_7, t0.afficher_bloc_contact AS afficher_bloc_contact_8, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.image_bg AS image_bg_12, t0.date_maj AS date_maj_13, t0.afficher_unite_loyer AS afficher_unite_loyer_14, t0.afficher_loyer AS afficher_loyer_15, t0.afficher_prix AS afficher_prix_16, t0.afficher_unite_prix AS afficher_unite_prix_17, t0.slider_surface_max AS slider_surface_max_18, t0.afficher_tri AS afficher_tri_19, t0.afficher_favoris AS afficher_favoris_20, t0.button_contact AS button_contact_21 FROM offres_config t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerIueNYr2\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "vente"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "entrepots-locaux-d-activites"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.image AS image_3, t0.url AS url_4, t0.title AS title_5, t0.alt AS alt_6, t0.date_maj AS date_maj_7, t0.actif AS actif_8, t0.description AS description_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.og_title AS og_title_12, t0.og_desc AS og_desc_13, t0.og_image AS og_image_14, t0.home AS home_15, t0.agence_id AS agence_id_16 FROM secteur t0 WHERE t0.url = ? LIMIT 1"
  "params" => [
    1 => "/offres-immobilier/vente/entrepots-locaux-d-activites/meyzieu-69330/"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.afficher AS afficher_3 FROM tri_config t0"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "sql" => "SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 2 AND o0_.type_id = 3 AND o0_.directe = 1"
  "params" => [
    1 => "meyzieu-69330"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT o0_.id AS id_0, o0_.date_modif AS date_modif_1 FROM offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 2 AND o0_.type_id = 3 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16"
  "params" => [
    1 => "meyzieu-69330"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.ref_interne AS ref_interne_1, o0_.adresse AS adresse_2, o0_.cp AS cp_3, o0_.ville AS ville_4, o0_.photo1 AS photo1_5, o0_.descriptif AS descriptif_6, o0_.accroche AS accroche_7, o0_.condifi AS condifi_8, o0_.prestimm AS prestimm_9, o0_.equipement AS equipement_10, o0_.dispo AS dispo_11, o0_.desserte AS desserte_12, o0_.nom_consultant AS nom_consultant_13, o0_.tel_consultant AS tel_consultant_14, o0_.tel_port_consultant AS tel_port_consultant_15, o0_.mail_consultant AS mail_consultant_16, o0_.divisible AS divisible_17, o0_.date_modif AS date_modif_18, o0_.url_virtuelle AS url_virtuelle_19, o0_.dpe_chiffre AS dpe_chiffre_20, o0_.dpe_lettre AS dpe_lettre_21, o0_.ges_chiffre AS ges_chiffre_22, o0_.ges_lettre AS ges_lettre_23, o0_.surface_div AS surface_div_24, o0_.surface_totale AS surface_totale_25, o0_.latitude AS latitude_26, o0_.longitude AS longitude_27, o0_.prix_vente_global AS prix_vente_global_28, o0_.loyer_global AS loyer_global_29, o0_.honos_pourcent AS honos_pourcent_30, o0_.honos_montant AS honos_montant_31, o0_.photo2 AS photo2_32, o0_.photo3 AS photo3_33, o0_.photo4 AS photo4_34, o0_.photo5 AS photo5_35, o0_.photo6 AS photo6_36, o0_.photo7 AS photo7_37, o0_.photo8 AS photo8_38, o0_.photo9 AS photo9_39, o0_.photo10 AS photo10_40, o0_.photo11 AS photo11_41, o0_.photo12 AS photo12_42, o0_.photo13 AS photo13_43, o0_.photo14 AS photo14_44, o0_.photo15 AS photo15_45, o0_.plan1 AS plan1_46, o0_.plan2 AS plan2_47, o0_.plan3 AS plan3_48, o0_.plan4 AS plan4_49, o0_.plan5 AS plan5_50, o0_.plan6 AS plan6_51, o0_.plan7 AS plan7_52, o0_.plan8 AS plan8_53, o0_.plan9 AS plan9_54, o0_.plan10 AS plan10_55, o0_.plan11 AS plan11_56, o0_.plan12 AS plan12_57, o0_.plan13 AS plan13_58, o0_.plan14 AS plan14_59, o0_.plan15 AS plan15_60, o0_.slug_ville_cp AS slug_ville_cp_61, o0_.slug_ville AS slug_ville_62, o0_.slug_type AS slug_type_63, o0_.slug_nature AS slug_nature_64, o0_.slug_nature_second AS slug_nature_second_65, o0_.slug_detail_url AS slug_detail_url_66, o0_.directe AS directe_67, o0_.archive AS archive_68, o0_.loyer_mcarre AS loyer_mcarre_69, o0_.prix_mcarre AS prix_mcarre_70, o0_.detail_surfaces AS detail_surfaces_71, o0_.departement AS departement_72, o0_.departement_slug AS departement_slug_73, o0_.departement_libelle AS departement_libelle_74, o0_.import AS import_75, o0_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 2 AND o0_.type_id = 3 AND o0_.directe = 1 AND o0_.id IN (?) ORDER BY o0_.date_modif ASC"
  "params" => [
    1 => "meyzieu-69330"
    2 => 1128
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

[
  "sql" => "SELECT o0_.slug_ville_cp AS slug_ville_cp_0, o0_.ville AS ville_1, o0_.cp AS cp_2, o0_.departement_slug AS departement_slug_3, COUNT(o0_.id) AS sclr_4 FROM offres o0_ WHERE o0_.slug_ville_cp <> ? AND o0_.cp LIKE ? AND o0_.nature_id = 2 AND o0_.type_id = 3 GROUP BY o0_.slug_ville_cp ORDER BY o0_.ville ASC"
  "params" => [
    1 => "meyzieu-69330"
    2 => "69%"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.ref_interne AS ref_interne_1, o0_.adresse AS adresse_2, o0_.cp AS cp_3, o0_.ville AS ville_4, o0_.photo1 AS photo1_5, o0_.descriptif AS descriptif_6, o0_.accroche AS accroche_7, o0_.condifi AS condifi_8, o0_.prestimm AS prestimm_9, o0_.equipement AS equipement_10, o0_.dispo AS dispo_11, o0_.desserte AS desserte_12, o0_.nom_consultant AS nom_consultant_13, o0_.tel_consultant AS tel_consultant_14, o0_.tel_port_consultant AS tel_port_consultant_15, o0_.mail_consultant AS mail_consultant_16, o0_.divisible AS divisible_17, o0_.date_modif AS date_modif_18, o0_.url_virtuelle AS url_virtuelle_19, o0_.dpe_chiffre AS dpe_chiffre_20, o0_.dpe_lettre AS dpe_lettre_21, o0_.ges_chiffre AS ges_chiffre_22, o0_.ges_lettre AS ges_lettre_23, o0_.surface_div AS surface_div_24, o0_.surface_totale AS surface_totale_25, o0_.latitude AS latitude_26, o0_.longitude AS longitude_27, o0_.prix_vente_global AS prix_vente_global_28, o0_.loyer_global AS loyer_global_29, o0_.honos_pourcent AS honos_pourcent_30, o0_.honos_montant AS honos_montant_31, o0_.photo2 AS photo2_32, o0_.photo3 AS photo3_33, o0_.photo4 AS photo4_34, o0_.photo5 AS photo5_35, o0_.photo6 AS photo6_36, o0_.photo7 AS photo7_37, o0_.photo8 AS photo8_38, o0_.photo9 AS photo9_39, o0_.photo10 AS photo10_40, o0_.photo11 AS photo11_41, o0_.photo12 AS photo12_42, o0_.photo13 AS photo13_43, o0_.photo14 AS photo14_44, o0_.photo15 AS photo15_45, o0_.plan1 AS plan1_46, o0_.plan2 AS plan2_47, o0_.plan3 AS plan3_48, o0_.plan4 AS plan4_49, o0_.plan5 AS plan5_50, o0_.plan6 AS plan6_51, o0_.plan7 AS plan7_52, o0_.plan8 AS plan8_53, o0_.plan9 AS plan9_54, o0_.plan10 AS plan10_55, o0_.plan11 AS plan11_56, o0_.plan12 AS plan12_57, o0_.plan13 AS plan13_58, o0_.plan14 AS plan14_59, o0_.plan15 AS plan15_60, o0_.slug_ville_cp AS slug_ville_cp_61, o0_.slug_ville AS slug_ville_62, o0_.slug_type AS slug_type_63, o0_.slug_nature AS slug_nature_64, o0_.slug_nature_second AS slug_nature_second_65, o0_.slug_detail_url AS slug_detail_url_66, o0_.directe AS directe_67, o0_.archive AS archive_68, o0_.loyer_mcarre AS loyer_mcarre_69, o0_.prix_mcarre AS prix_mcarre_70, o0_.detail_surfaces AS detail_surfaces_71, o0_.departement AS departement_72, o0_.departement_slug AS departement_slug_73, o0_.departement_libelle AS departement_libelle_74, o0_.import AS import_75, o0_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 2 AND o0_.type_id = 3 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16"
  "params" => [
    1 => "meyzieu-69330"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.ref_interne AS ref_interne_1, o0_.adresse AS adresse_2, o0_.cp AS cp_3, o0_.ville AS ville_4, o0_.photo1 AS photo1_5, o0_.descriptif AS descriptif_6, o0_.accroche AS accroche_7, o0_.condifi AS condifi_8, o0_.prestimm AS prestimm_9, o0_.equipement AS equipement_10, o0_.dispo AS dispo_11, o0_.desserte AS desserte_12, o0_.nom_consultant AS nom_consultant_13, o0_.tel_consultant AS tel_consultant_14, o0_.tel_port_consultant AS tel_port_consultant_15, o0_.mail_consultant AS mail_consultant_16, o0_.divisible AS divisible_17, o0_.date_modif AS date_modif_18, o0_.url_virtuelle AS url_virtuelle_19, o0_.dpe_chiffre AS dpe_chiffre_20, o0_.dpe_lettre AS dpe_lettre_21, o0_.ges_chiffre AS ges_chiffre_22, o0_.ges_lettre AS ges_lettre_23, o0_.surface_div AS surface_div_24, o0_.surface_totale AS surface_totale_25, o0_.latitude AS latitude_26, o0_.longitude AS longitude_27, o0_.prix_vente_global AS prix_vente_global_28, o0_.loyer_global AS loyer_global_29, o0_.honos_pourcent AS honos_pourcent_30, o0_.honos_montant AS honos_montant_31, o0_.photo2 AS photo2_32, o0_.photo3 AS photo3_33, o0_.photo4 AS photo4_34, o0_.photo5 AS photo5_35, o0_.photo6 AS photo6_36, o0_.photo7 AS photo7_37, o0_.photo8 AS photo8_38, o0_.photo9 AS photo9_39, o0_.photo10 AS photo10_40, o0_.photo11 AS photo11_41, o0_.photo12 AS photo12_42, o0_.photo13 AS photo13_43, o0_.photo14 AS photo14_44, o0_.photo15 AS photo15_45, o0_.plan1 AS plan1_46, o0_.plan2 AS plan2_47, o0_.plan3 AS plan3_48, o0_.plan4 AS plan4_49, o0_.plan5 AS plan5_50, o0_.plan6 AS plan6_51, o0_.plan7 AS plan7_52, o0_.plan8 AS plan8_53, o0_.plan9 AS plan9_54, o0_.plan10 AS plan10_55, o0_.plan11 AS plan11_56, o0_.plan12 AS plan12_57, o0_.plan13 AS plan13_58, o0_.plan14 AS plan14_59, o0_.plan15 AS plan15_60, o0_.slug_ville_cp AS slug_ville_cp_61, o0_.slug_ville AS slug_ville_62, o0_.slug_type AS slug_type_63, o0_.slug_nature AS slug_nature_64, o0_.slug_nature_second AS slug_nature_second_65, o0_.slug_detail_url AS slug_detail_url_66, o0_.directe AS directe_67, o0_.archive AS archive_68, o0_.loyer_mcarre AS loyer_mcarre_69, o0_.prix_mcarre AS prix_mcarre_70, o0_.detail_surfaces AS detail_surfaces_71, o0_.departement AS departement_72, o0_.departement_slug AS departement_slug_73, o0_.departement_libelle AS departement_libelle_74, o0_.import AS import_75, o0_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o1_, offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 2 AND o0_.type_id = 3 AND o0_.directe = 0"
  "params" => [
    1 => "meyzieu-69330"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.email AS email_6, t0.tel AS tel_7, t0.fax AS fax_8, t0.description AS description_9, t0.image AS image_10, t0.date_maj AS date_maj_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.facebook AS facebook_14, t0.contact_titre AS contact_titre_15, t0.contact_span AS contact_span_16, t0.contact_texte AS contact_texte_17, t0.favico AS favico_18, t0.cle_google_map AS cle_google_map_19, t0.puce_google_map AS puce_google_map_20, t0.contact_fond AS contact_fond_21, t0.google_analytics AS google_analytics_22, t0.insta AS insta_23 FROM infos t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.secteur AS secteur_6, t0.picto AS picto_7, t0.date_maj AS date_maj_8, t0.email AS email_9, t0.tel AS tel_10, t0.ordre AS ordre_11, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 ORDER BY t0.ordre ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.afficher_actus_similaires AS afficher_actus_similaires_5, t0.url_liste AS url_liste_6, t0.url_detail AS url_detail_7, t0.h1_liste AS h1_liste_8, t0.afficher_bloc_contact AS afficher_bloc_contact_9, t0.titre_actu_similaire AS titre_actu_similaire_10, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11, t0.seo_title AS seo_title_12, t0.seo_desc AS seo_desc_13, t0.image_bg AS image_bg_14, t0.date_maj AS date_maj_15 FROM actus_config t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.photo AS photo_3, t0.update_at AS update_at_4, t0.type_offre_id AS type_offre_id_5 FROM offres_photos t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.recherche AS recherche_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5 FROM localisations t0 ORDER BY t0.libelle ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.title AS title_4, t0.url AS url_5, t0.targert AS targert_6, t0.type AS type_7 FROM menu t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.accroche AS accroche_3, t0.btn_libelle AS btn_libelle_4, t0.btn_lien AS btn_lien_5, t0.btn_title AS btn_title_6, t0.bloc_un_nom AS bloc_un_nom_7, t0.bloc_un_lien AS bloc_un_lien_8, t0.bloc_un_title AS bloc_un_title_9, t0.bloc_deux_nom AS bloc_deux_nom_10, t0.bloc_deux_lien AS bloc_deux_lien_11, t0.bloc_deux_title AS bloc_deux_title_12, t0.bloc_trois_nom AS bloc_trois_nom_13, t0.bloc_trois_lien AS bloc_trois_lien_14, t0.bloc_trois_title AS bloc_trois_title_15 FROM menu_mega t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.bloc_un_nom AS bloc_un_nom_2, t0.bloc_deux_nom AS bloc_deux_nom_3, t0.bloc_trois_nom AS bloc_trois_nom_4 FROM footer t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.actif AS actif_5, t0.date_maj AS date_maj_6, t0.nb AS nb_7 FROM secteur_config t0 WHERE t0.actif = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.svg AS svg_6, t0.svg_header AS svg_header_7, t0.template_id AS template_id_8 FROM favoris_config t0 WHERE t0.actif = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3 FROM partage_config t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.date_maj AS date_maj_4, t0.actif AS actif_5, t0.cle_api AS cle_api_6, t0.puce_map AS puce_map_7, t0.styles AS styles_8 FROM maps t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.affichage AS affichage_2, t0.choix_affichage_carte AS choix_affichage_carte_3, t0.choix_affichage_mixte AS choix_affichage_mixte_4, t0.choix_affichage_liste AS choix_affichage_liste_5 FROM type_affichage t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_id = ? ORDER BY t0.ordre ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_menu_deux_id = ? ORDER BY t0.ordre ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_id = ? ORDER BY t0.ordre ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_deux_id = ? ORDER BY t0.ordre ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_trois_id = ? ORDER BY t0.ordre ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "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\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::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.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\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

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