Symfony Profiler

[
  "route" => "app_home_page"
  "route_parameters" => [
    "_route" => "app_home_page"
    "_controller" => "App\Controller\HomePageController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "https://ecom.freebird.fr/fr/"
  "method" => "GET"
]

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "u_freebird"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "db_freebird"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.address AS address_2, t0.phone_contact AS phone_contact_3, t0.email_contact AS email_contact_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.youtube AS youtube_7, t0.twitter AS twitter_8, t0.linkedin AS linkedin_9, t0.logo_name AS logo_name_10, t0.logo_footer_name AS logo_footer_name_11, t0.favicon_name AS favicon_name_12, t0.maintenance AS maintenance_13, t0.title AS title_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.meta_image_name AS meta_image_name_17, t0.payment_cb AS payment_cb_18, t0.payment_transfer AS payment_transfer_19, t0.payment_bank_cheque AS payment_bank_cheque_20, t0.payment_on_delivery AS payment_on_delivery_21, t0.payment_cbmodel AS payment_cbmodel_22, t0.payment_cbendpoint AS payment_cbendpoint_23, t0.payment_cbusername AS payment_cbusername_24, t0.payment_cbpassword AS payment_cbpassword_25, t0.payment_cbmode AS payment_cbmode_26, t0.denomination_virement AS denomination_virement_27, t0.iban AS iban_28, t0.bic AS bic_29, t0.payment_transfer_block_delay AS payment_transfer_block_delay_30, t0.payment_bank_cheque_order AS payment_bank_cheque_order_31, t0.payment_bank_cheque_address AS payment_bank_cheque_address_32, t0.payment_bank_cheque_block_delay AS payment_bank_cheque_block_delay_33, t0.allow_pickup_in_store AS allow_pickup_in_store_34, t0.api_key_google_maps AS api_key_google_maps_35, t0.api_key_public_grecaptcha AS api_key_public_grecaptcha_36, t0.api_key_private_grecaptcha AS api_key_private_grecaptcha_37, t0.latitude AS latitude_38, t0.longitude AS longitude_39, t0.zoom AS zoom_40, t0.map_id AS map_id_41, t0.marker_image_name AS marker_image_name_42, t0.api_freebird_backend_endpoint AS api_freebird_backend_endpoint_43, t0.api_freebird_licence_endpoint AS api_freebird_licence_endpoint_44, t0.api_freebird_backend_username AS api_freebird_backend_username_45, t0.api_freebird_backend_password AS api_freebird_backend_password_46, t0.section_id AS section_id_47, t0.caisse_id AS caisse_id_48, t0.stock_restriction_section AS stock_restriction_section_49, t0.font_primary AS font_primary_50, t0.font_secondary AS font_secondary_51, t0.color_primary AS color_primary_52, t0.color_secondary AS color_secondary_53, t0.tax AS tax_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.current_devise_id AS current_devise_id_57 FROM configuration t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "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\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" => "App\EventListener\ConfigurationListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\MaintenanceListener::onKernelRequest"
]

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

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

[
  "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\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.active AS active_2, t0.homepage AS homepage_3, t0.cart AS cart_4, t0.shop AS shop_5, t0.order_process AS order_process_6, t0.color AS color_7 FROM away t0 WHERE t0.active = ? AND t0.homepage = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#939
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#939}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_image_name AS meta_image_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM home_page t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "route" => "app_menu"
  "route_parameters" => [
    "_route" => "app_menu"
    "_controller" => "App\Controller\MenuController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "https://ecom.freebird.fr/fr/__menu?path=%2Ffr%2F"
  "method" => "GET"
]

[
  "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\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" => "App\EventListener\ConfigurationListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\MaintenanceListener::onKernelRequest"
]

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

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

[
  "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\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT c0_.id AS id_0, c0_.freebird_id AS freebird_id_1, c0_.position AS position_2, c0_.default_weight AS default_weight_3, c0_.menu AS menu_4, c0_.active AS active_5, c0_.image_name AS image_name_6, c0_.image_name_responsive AS image_name_responsive_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c1_.id AS id_10, c1_.title AS title_11, c1_.title_web AS title_web_12, c1_.path AS path_13, c1_.locale AS locale_14, c2_.id AS id_15, c2_.freebird_id AS freebird_id_16, c2_.position AS position_17, c2_.default_weight AS default_weight_18, c2_.menu AS menu_19, c2_.active AS active_20, c2_.image_name AS image_name_21, c2_.image_name_responsive AS image_name_responsive_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c3_.id AS id_25, c3_.title AS title_26, c3_.title_web AS title_web_27, c3_.path AS path_28, c3_.locale AS locale_29, c4_.id AS id_30, c4_.freebird_id AS freebird_id_31, c4_.position AS position_32, c4_.default_weight AS default_weight_33, c4_.menu AS menu_34, c4_.active AS active_35, c4_.image_name AS image_name_36, c4_.image_name_responsive AS image_name_responsive_37, c4_.created_at AS created_at_38, c4_.updated_at AS updated_at_39, c5_.id AS id_40, c5_.title AS title_41, c5_.title_web AS title_web_42, c5_.path AS path_43, c5_.locale AS locale_44, c0_.parent_id AS parent_id_45, c1_.translatable_id AS translatable_id_46, c2_.parent_id AS parent_id_47, c3_.translatable_id AS translatable_id_48, c4_.parent_id AS parent_id_49, c5_.translatable_id AS translatable_id_50 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN category c2_ ON c0_.id = c2_.parent_id AND (c2_.active = 1) LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category c4_ ON c2_.id = c4_.parent_id AND (c4_.active = 1) LEFT JOIN category_translation c5_ ON c4_.id = c5_.translatable_id WHERE c0_.menu = 1 AND c0_.active = 1 ORDER BY c0_.position ASC, c2_.position ASC, c4_.position ASC"
]

[
  "sql" => "SELECT DISTINCT c0_.id AS id_0 FROM category c0_ INNER JOIN reference_category r2_ ON c0_.id = r2_.category_id INNER JOIN reference r1_ ON r1_.id = r2_.reference_id INNER JOIN product p3_ ON r1_.id = p3_.reference_id WHERE r1_.active = 1 AND p3_.active = 1 AND p3_.stock > 0"
]

[
  "sql" => "SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM reference r0_ INNER JOIN product p1_ ON r0_.id = p1_.reference_id WHERE r0_.active = 1 AND p1_.active = 1 AND p1_.stock > 0 AND r0_.created_at >= ?"
  "params" => [
    1 => "2026-05-11 23:49:16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.symbol_before AS symbol_before_5, t0.decimals AS decimals_6, t0.thousands_sep AS thousands_sep_7, t0.decimal_sep AS decimal_sep_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM devise t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "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\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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.elements AS elements_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM home_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "fr"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "route" => "app_footer"
  "route_parameters" => [
    "_route" => "app_footer"
    "_controller" => "App\Controller\FooterController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "https://ecom.freebird.fr/fr/__footer"
  "method" => "GET"
]

[
  "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\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" => "App\EventListener\ConfigurationListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\MaintenanceListener::onKernelRequest"
]

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

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

[
  "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\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM footer t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block1_id IN (?)"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block2_id IN (?)"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block3_id IN (?)"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.footer_block1_id AS footer_block1_id_3, t0.footer_block2_id AS footer_block2_id_4, t0.footer_block3_id AS footer_block3_id_5, t0.footer_block4_id AS footer_block4_id_6 FROM footer_link t0 WHERE t0.footer_block4_id IN (?)"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title_block1 AS title_block1_2, t0.title_block2 AS title_block2_3, t0.title_block3 AS title_block3_4, t0.title_block4 AS title_block4_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM footer_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "fr"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#787
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "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\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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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

[
  "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\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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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