Symfony Profiler

[
  "route" => "tyre_size_show"
  "route_parameters" => [
    "_route" => "tyre_size_show"
    "_controller" => "App\Controller\TyreCatalogController::size"
    "sizeSlug" => "195-60-r12"
  ]
  "request_uri" => "https://pewneopony.pl/rozmiary/195-60-r12"
  "method" => "GET"
]

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

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

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

[
  "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\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\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerE1iWvET\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

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

[
  "sql" => """
    SELECT id, label, slug, width, profile, diameter\n
                 FROM tyre_size_groups\n
                 WHERE slug = ?\n
                 LIMIT 1
    """
  "params" => [
    1 => "195-60-r12"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                    ss.code,\n
                    ss.name,\n
                    ss.slug,\n
                    NULL AS total\n
                 FROM tyre_products p\n
                 INNER JOIN tyre_seasons ss ON ss.id = p.season_id\n
                 INNER JOIN tyre_brands b ON b.id = p.brand_id\n
                 INNER JOIN tyre_size_groups g ON g.id = p.size_group_id\n
                 WHERE p.is_active = 1 AND p.size_group_id = ?\n
                 GROUP BY ss.id, ss.code, ss.name, ss.slug\n
                 ORDER BY CASE ss.code\n
                    WHEN 'summer' THEN 1\n
                    WHEN 'winter' THEN 2\n
                    WHEN 'allseason' THEN 3\n
                    ELSE 4\n
                 END, ss.name ASC
    """
  "params" => [
    1 => 1567
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                    b.name,\n
                    b.slug,\n
                    NULL AS total\n
                 FROM tyre_products p\n
                 INNER JOIN tyre_brands b ON b.id = p.brand_id\n
                 INNER JOIN tyre_seasons ss ON ss.id = p.season_id\n
                 INNER JOIN tyre_size_groups g ON g.id = p.size_group_id\n
                 WHERE p.is_active = 1 AND p.size_group_id = ?\n
                 GROUP BY b.id, b.name, b.slug\n
                 ORDER BY b.name ASC\n
                 LIMIT ?
    """
  "params" => [
    1 => 1567
    2 => 24
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => """
    SELECT\n
                    p.eprel_registration_number,\n
                    p.commercial_name,\n
                    p.model_identifier,\n
                    p.load_index,\n
                    p.speed_index,\n
                    p.energy_class,\n
                    p.wet_grip_class,\n
                    p.noise_value,\n
                    p.noise_class,\n
                    p.is_xl,\n
                    p.is_runflat,\n
                    b.name AS brand_name,\n
                    b.slug AS brand_slug,\n
                    COALESCE(s.name, p.commercial_name, p.model_identifier) AS series_name,\n
                    COALESCE(s.slug, ?) AS series_slug,\n
                    g.label AS size_label,\n
                    g.slug AS size_slug,\n
                    ss.name AS season_name,\n
                    ss.slug AS season_slug\n
                 FROM tyre_products p\n
                 INNER JOIN tyre_brands b ON b.id = p.brand_id\n
                 LEFT JOIN tyre_series s ON s.id = p.series_id\n
                 INNER JOIN tyre_size_groups g ON g.id = p.size_group_id\n
                 INNER JOIN tyre_seasons ss ON ss.id = p.season_id\n
                 WHERE p.is_active = 1 AND p.size_group_id = ?\n
                 ORDER BY p.id DESC\n
                 LIMIT ?
    """
  "params" => [
    1 => "unknown"
    2 => 1567
    3 => 72
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => """
    SELECT\n
                    lp.eprel_code AS ern,\n
                    ph.file_name,\n
                    ph.local_path,\n
                    ph.sort_order,\n
                    ph.is_primary,\n
                    'latex' AS source\n
                 FROM latex_products lp\n
                 INNER JOIN latex_product_photos ph ON ph.product_id = lp.id\n
                 WHERE lp.eprel_code IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
                   AND ph.local_path IS NOT NULL\n
                   AND ph.local_path <> ''\n
                 ORDER BY lp.eprel_code ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC
    """
  "params" => [
    1 => "549677"
    2 => "2018504"
    3 => "564260"
    4 => "2658289"
    5 => "2528356"
    6 => "549688"
    7 => "549657"
    8 => "2284929"
    9 => "1209407"
    10 => "428197"
    11 => "549670"
    12 => "549666"
    13 => "2459750"
    14 => "2336008"
    15 => "1697521"
    16 => "2323960"
    17 => "472792"
    18 => "453953"
    19 => "2391166"
    20 => "2391103"
    21 => "2474122"
    22 => "454414"
    23 => "549707"
    24 => "2627778"
    25 => "2555729"
    26 => "2503080"
    27 => "2388864"
    28 => "2237820"
    29 => "1554898"
    30 => "564332"
    31 => "549699"
    32 => "428731"
    33 => "2474386"
    34 => "2234015"
    35 => "706576"
    36 => "470869"
    37 => "437038"
    38 => "428201"
    39 => "2564086"
    40 => "2564495"
    41 => "2473879"
    42 => "2473720"
    43 => "2090180"
    44 => "549723"
    45 => "549718"
    46 => "1219460"
    47 => "2633102"
    48 => "2633119"
    49 => "898409"
    50 => "463109"
    51 => "427597"
    52 => "1697518"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                    et.eprel_registration_number AS ern,\n
                    ph.file_name,\n
                    ph.local_path,\n
                    ph.sort_order,\n
                    ph.is_primary,\n
                    'intercars' AS source\n
                 FROM eprel_tyres et\n
                 INNER JOIN inter_cars_products icp ON icp.eprel_tyre_id = et.id\n
                 INNER JOIN inter_cars_product_photos ph ON ph.product_id = icp.id\n
                 WHERE et.eprel_registration_number IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n
                   AND ph.local_path IS NOT NULL\n
                   AND ph.local_path <> ''\n
                 ORDER BY et.eprel_registration_number ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC
    """
  "params" => [
    1 => "549677"
    2 => "2018504"
    3 => "564260"
    4 => "2658289"
    5 => "2528356"
    6 => "549688"
    7 => "549657"
    8 => "2284929"
    9 => "1209407"
    10 => "428197"
    11 => "549670"
    12 => "549666"
    13 => "2459750"
    14 => "2336008"
    15 => "1697521"
    16 => "2323960"
    17 => "472792"
    18 => "453953"
    19 => "2391166"
    20 => "2391103"
    21 => "2474122"
    22 => "454414"
    23 => "549707"
    24 => "2627778"
    25 => "2555729"
    26 => "2503080"
    27 => "2388864"
    28 => "2237820"
    29 => "1554898"
    30 => "564332"
    31 => "549699"
    32 => "428731"
    33 => "2474386"
    34 => "2234015"
    35 => "706576"
    36 => "470869"
    37 => "437038"
    38 => "428201"
    39 => "2564086"
    40 => "2564495"
    41 => "2473879"
    42 => "2473720"
    43 => "2090180"
    44 => "549723"
    45 => "549718"
    46 => "1219460"
    47 => "2633102"
    48 => "2633119"
    49 => "898409"
    50 => "463109"
    51 => "427597"
    52 => "1697518"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 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\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"
]