Symfony Profiler

[
  "route" => "tyre_product_show"
  "route_parameters" => [
    "_route" => "tyre_product_show"
    "_controller" => "App\Controller\TyreProductController::show"
    "brandSlug" => "continental"
    "seriesSlug" => "ecocontact-7"
    "ern" => "2620934"
  ]
  "request_uri" => "https://pewneopony.pl/opony/continental/ecocontact-7/2620934"
  "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\n
                    p.id,\n
                    p.eprel_registration_number,\n
                    p.model_identifier,\n
                    p.commercial_name,\n
                    p.tyre_designation,\n
                    p.tyre_class,\n
                    p.load_index,\n
                    p.speed_index,\n
                    p.load_capacity_indicator,\n
                    p.energy_class,\n
                    p.wet_grip_class,\n
                    p.noise_class,\n
                    p.noise_value,\n
                    p.is_xl,\n
                    p.is_runflat,\n
                    p.is_severe_snow,\n
                    p.is_ice,\n
                    p.raw_detail_data,\n
                    b.id AS brand_id,\n
                    b.name AS brand_name,\n
                    b.slug AS brand_slug,\n
                    s.id AS series_id,\n
                    s.name AS series_name,\n
                    s.slug AS series_slug,\n
                    ss.code AS season_code,\n
                    ss.name AS season_name,\n
                    g.id AS size_group_id,\n
                    g.label AS size_label\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_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.eprel_registration_number = ?\n
                   AND b.slug = ?\n
                   AND COALESCE(s.slug, ?) = ?\n
                 LIMIT 1
    """
  "params" => [
    1 => "2620934"
    2 => "continental"
    3 => "unknown"
    4 => "ecocontact-7"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                    p2.eprel_registration_number,\n
                    g2.label AS size_label,\n
                    g2.width AS size_width,\n
                    g2.profile AS size_profile,\n
                    g2.diameter AS size_diameter,\n
                    p2.load_index,\n
                    p2.speed_index\n
                 FROM tyre_products p2\n
                 INNER JOIN tyre_size_groups g2 ON g2.id = p2.size_group_id\n
                 WHERE p2.brand_id = ?\n
                   AND (\n
                        (p2.series_id = ?)\n
                        OR (p2.series_id IS NULL AND ? IS NULL)\n
                   )\n
                   AND p2.is_active = 1\n
                 ORDER BY g2.diameter ASC, g2.width ASC, g2.profile ASC, p2.load_index ASC, p2.speed_index ASC, p2.eprel_registration_number ASC\n
                 LIMIT 100
    """
  "params" => [
    1 => 1079
    2 => 15874
    3 => 15874
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                    o.id,\n
                    o.external_id,\n
                    o.name,\n
                    sup.code AS supplier_code,\n
                    sup.name AS supplier_name,\n
                    o.match_status,\n
                    o.match_score,\n
                    o.is_active,\n
                    p.net_offer_price,\n
                    p.gross_offer_price,\n
                    p.net_list_price,\n
                    p.gross_list_price,\n
                    MIN(tp_offer.eprel_registration_number) AS linked_eprel_registration_number,\n
                    COALESCE(SUM(CASE WHEN st.quantity > 0 THEN st.quantity ELSE 0 END), 0) AS total_quantity,\n
                    MAX(CASE WHEN st.quantity > 0 THEN 1 ELSE 0 END) AS has_stock\n
                 FROM tyre_supplier_offers o\n
                 INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id\n
                 INNER JOIN tyre_suppliers sup ON sup.id = o.supplier_id\n
                 LEFT JOIN tyre_supplier_offer_prices p ON p.offer_id = o.id AND p.is_current = 1\n
                 LEFT JOIN tyre_supplier_offer_stocks st ON st.offer_id = o.id AND st.is_current = 1\n
                 WHERE tp_offer.brand_id = ?\n
                   AND tp_offer.size_group_id = ?\n
                   AND (\n
                        (tp_offer.series_id = ?)\n
                        OR (tp_offer.series_id IS NULL AND ? IS NULL)\n
                   )\n
                   AND (\n
                        (tp_offer.load_index = ?)\n
                        OR (tp_offer.load_index IS NULL AND ? IS NULL)\n
                   )\n
                   AND COALESCE(tp_offer.speed_index, '') = ?\n
                   AND tp_offer.is_xl = ?\n
                   AND tp_offer.is_runflat = ?\n
                   AND o.match_status = ?\n
                   AND o.is_active = 1\n
                 GROUP BY\n
                    o.id,\n
                    o.external_id,\n
                    o.name,\n
                    sup.code,\n
                    sup.name,\n
                    o.match_status,\n
                    o.match_score,\n
                    o.is_active,\n
                    p.net_offer_price,\n
                    p.gross_offer_price,\n
                    p.net_list_price,\n
                    p.gross_list_price\n
                 ORDER BY has_stock DESC, p.gross_offer_price ASC, p.net_offer_price ASC, o.id ASC
    """
  "params" => [
    1 => 1079
    2 => 1262
    3 => 15874
    4 => 15874
    5 => 109
    6 => 109
    7 => "V"
    8 => 1
    9 => 0
    10 => "matched"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
  ]
]

[
  "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 => "2620934"
  ]
  "types" => [
    1 => 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 => "2620934"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                        o.id AS offer_id,\n
                        st.warehouse_code,\n
                        st.warehouse_name,\n
                        st.quantity\n
                     FROM tyre_supplier_offers o\n
                     INNER JOIN tyre_supplier_offer_stocks st ON st.offer_id = o.id AND st.is_current = 1\n
                     INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id\n
                     WHERE tp_offer.brand_id = ?\n
                       AND tp_offer.size_group_id = ?\n
                       AND (\n
                            (tp_offer.series_id = ?)\n
                            OR (tp_offer.series_id IS NULL AND ? IS NULL)\n
                       )\n
                       AND (\n
                            (tp_offer.load_index = ?)\n
                            OR (tp_offer.load_index IS NULL AND ? IS NULL)\n
                       )\n
                       AND COALESCE(tp_offer.speed_index, '') = ?\n
                       AND tp_offer.is_xl = ?\n
                       AND tp_offer.is_runflat = ?\n
                       AND o.match_status = ?\n
                       AND o.is_active = 1\n
                     ORDER BY o.id ASC, st.quantity DESC, st.warehouse_name ASC
    """
  "params" => [
    1 => 1079
    2 => 1262
    3 => 15874
    4 => 15874
    5 => 109
    6 => 109
    7 => "V"
    8 => 1
    9 => 0
    10 => "matched"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                        o.id AS offer_id,\n
                        ph.file_name,\n
                        ph.local_path,\n
                        ph.sort_order,\n
                        ph.is_primary\n
                     FROM tyre_supplier_offers o\n
                     INNER JOIN latex_products lp ON lp.supplier_index = o.external_id\n
                     INNER JOIN latex_product_photos ph ON ph.product_id = lp.id\n
                     INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id\n
                     WHERE tp_offer.brand_id = ?\n
                       AND tp_offer.size_group_id = ?\n
                       AND (\n
                            (tp_offer.series_id = ?)\n
                            OR (tp_offer.series_id IS NULL AND ? IS NULL)\n
                       )\n
                       AND (\n
                            (tp_offer.load_index = ?)\n
                            OR (tp_offer.load_index IS NULL AND ? IS NULL)\n
                       )\n
                       AND COALESCE(tp_offer.speed_index, '') = ?\n
                       AND tp_offer.is_xl = ?\n
                       AND tp_offer.is_runflat = ?\n
                       AND o.match_status = ?\n
                       AND o.is_active = 1\n
                     ORDER BY ph.is_primary DESC, ph.sort_order ASC, ph.id ASC
    """
  "params" => [
    1 => 1079
    2 => 1262
    3 => 15874
    4 => 15874
    5 => 109
    6 => 109
    7 => "V"
    8 => 1
    9 => 0
    10 => "matched"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                            COUNT(*) AS total_reviews,\n
                            ROUND(AVG(r.rating_overall), 1) AS avg_overall,\n
                            ROUND(AVG(r.rating_comfort), 1) AS avg_comfort,\n
                            ROUND(AVG(r.rating_dry), 1) AS avg_dry,\n
                            ROUND(AVG(r.rating_wet), 1) AS avg_wet,\n
                            ROUND(AVG(r.rating_winter), 1) AS avg_winter,\n
                            ROUND(100 * AVG(CASE WHEN r.recommend = 1 THEN 1 ELSE 0 END), 0) AS recommend_percent\n
                         FROM tyre_series_reviews r\n
                         WHERE r.series_id = ?\n
                           AND r.is_active = 1
    """
  "params" => [
    1 => 15874
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT\n
                            r.id,\n
                            r.author_name,\n
                            r.tyre_size_label,\n
                            r.rating_overall,\n
                            r.rating_comfort,\n
                            r.rating_dry,\n
                            r.rating_wet,\n
                            r.rating_winter,\n
                            r.recommend,\n
                            r.is_verified_purchase,\n
                            r.comment,\n
                            r.created_at\n
                         FROM tyre_series_reviews r\n
                         WHERE r.series_id = ?\n
                           AND r.is_active = 1\n
                         ORDER BY r.created_at DESC, r.id DESC\n
                         LIMIT ? OFFSET ?
    """
  "params" => [
    1 => 15874
    2 => 5
    3 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "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"
]