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"
  "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" => "dbaas-db-5397322-do-user-19017645-0.g.db.ondigitalocean.com"
    "port" => 25060
    "user" => "element_dental_prod"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "shop_element_dental_prod"
    "serverVersion" => "8.0.36"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.iva AS iva_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.reference AS reference_5, p0_.image AS image_6, p0_.hidden AS hidden_7, p1_.id AS id_8, p1_.locale AS locale_9, p1_.name AS name_10, p1_.slug AS slug_11, p1_.description AS description_12, p1_.specifications AS specifications_13, p1_.directions AS directions_14, a2_.id AS id_15, a2_.contact_phone_number AS contact_phone_number_16, a2_.contact_address AS contact_address_17, a2_.billing_email AS billing_email_18, a2_.billing_name AS billing_name_19, a2_.billing_phone_number AS billing_phone_number_20, a2_.billing_address AS billing_address_21, a2_.nif AS nif_22, a2_.updated_at AS updated_at_23, a2_.preferences AS preferences_24, p0_.brand_id AS brand_id_25, p1_.product_id AS product_id_26, a2_.user_id AS user_id_27 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 WHERE p1_.locale = ? AND p0_.hidden = 0 ORDER BY b3_.display_order ASC, p1_.name ASC"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => 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 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˜Zú¢˜xa²-È~«Ý\x13à"
  ]
  "types" => [
    1 => 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™á³{$vº»cQÙs\x07 \v"
  ]
  "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)"
]

[
  "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ötq\x16ŠËJ=S…ÞÌ"
  ]
  "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
  ]
]

[
  "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ßw|i¡¢ürVN-Ñ"
  ]
  "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äÈ}\x03ˆ\x0Eמmƒ%Ú"
  ]
  "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å„{´„ûÈ×m\Òæ"
  ]
  "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òb{Ê¢R1\x7F«tÏ\x03"
  ]
  "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"
]