Symfony Profiler

[
  "route" => "public_area_products_by_brand_index"
  "route_parameters" => [
    "_route" => "public_area_products_by_brand_index"
    "_controller" => "App\Controller\PublicArea\Products\ProductsController::index"
    "_locale" => "en"
  ]
  "request_uri" => "https://shop.element-dental.com/en/p?family=family-pilar-provisional"
  "method" => "GET"
]

[
  "firewall_name" => "public_area"
  "authenticators" => 0
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "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\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.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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "shop_element_dental"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "shop_element_dental"
    "serverVersion" => "8.0.36"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.reference AS reference_4, p0_.image AS image_5, p0_.hidden AS hidden_6, p1_.id AS id_7, p1_.locale AS locale_8, p1_.name AS name_9, p1_.slug AS slug_10, p1_.description AS description_11, p1_.specifications AS specifications_12, p1_.directions AS directions_13, a2_.id AS id_14, a2_.contact_phone_number AS contact_phone_number_15, a2_.contact_address AS contact_address_16, a2_.billing_email AS billing_email_17, a2_.billing_name AS billing_name_18, a2_.billing_phone_number AS billing_phone_number_19, a2_.billing_address AS billing_address_20, a2_.nif AS nif_21, a2_.updated_at AS updated_at_22, a2_.preferences AS preferences_23, p0_.brand_id AS brand_id_24, p1_.product_id AS product_id_25, a2_.user_id AS user_id_26 FROM products p0_ INNER JOIN brands b3_ ON p0_.brand_id = b3_.id INNER JOIN products_translations p1_ ON p0_.id = p1_.product_id LEFT JOIN favorite_products f4_ ON p0_.id = f4_.product_id LEFT JOIN accounts a2_ ON a2_.id = f4_.account_id INNER JOIN filter_value_product f6_ ON p0_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE p1_.locale = ? AND f5_.code = ? AND p0_.hidden = 0 ORDER BY b3_.display_order ASC, p1_.name ASC"
  "params" => [
    1 => "en"
    2 => "family-pilar-provisional"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.locale AS locale_3, t0.account_id AS account_id_4 FROM carts t0 WHERE t0.account_id = ?"
  "params" => [
    1 => b"\x01–«{\x00ýp)„Ÿ’zûIi&"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f1_.code AS code_1, f0_.code AS code_2, f2_.locale AS locale_3, f2_.name AS name_4 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id LEFT JOIN filter_value_translations f2_ ON f0_.id = f2_.value_id"
]

[
  "sql" => "SELECT f0_.id AS id_0 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id INNER JOIN filter_value_product f3_ ON f0_.id = f3_.value_id INNER JOIN products p2_ ON p2_.id = f3_.product_id AND (p2_.hidden = 0) WHERE EXISTS (SELECT 1 AS sclr_1 FROM products p4_ INNER JOIN filter_value_product f6_ ON p4_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE f5_.code = ? AND p4_.id = p2_.id)"
  "params" => [
    1 => "family-pilar-provisional"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01˜>jâÝtà»Í\t¥.Œ6Ï"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = ?"
  "params" => [
    1 => b"""
      \x01˜>jç®q-›\n
      \x01:õ†¿ˆ
      """
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01˜>jÞì\x7F¨›¬™˜$磯"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01˜>jè–{r¤\x17à!i\x0F»°"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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\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"
]