Symfony Profiler

SELECT
  p.id,
  p.eprel_registration_number,
  p.model_identifier,
  p.commercial_name,
  p.tyre_designation,
  p.tyre_class,
  p.load_index,
  p.speed_index,
  p.load_capacity_indicator,
  p.energy_class,
  p.wet_grip_class,
  p.noise_class,
  p.noise_value,
  p.is_xl,
  p.is_runflat,
  p.is_severe_snow,
  p.is_ice,
  p.raw_detail_data,
  b.id AS brand_id,
  b.name AS brand_name,
  b.slug AS brand_slug,
  s.id AS series_id,
  s.name AS series_name,
  s.slug AS series_slug,
  ss.code AS season_code,
  ss.name AS season_name,
  g.id AS size_group_id,
  g.label AS size_label
FROM
  tyre_products p
  INNER JOIN tyre_brands b ON b.id = p.brand_id
  LEFT JOIN tyre_series s ON s.id = p.series_id
  INNER JOIN tyre_seasons ss ON ss.id = p.season_id
  INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
WHERE
  p.eprel_registration_number = ?
  AND b.slug = ?
  AND COALESCE(s.slug, ?) = ?
LIMIT
  1

SELECT
                p.id,
                p.eprel_registration_number,
                p.model_identifier,
                p.commercial_name,
                p.tyre_designation,
                p.tyre_class,
                p.load_index,
                p.speed_index,
                p.load_capacity_indicator,
                p.energy_class,
                p.wet_grip_class,
                p.noise_class,
                p.noise_value,
                p.is_xl,
                p.is_runflat,
                p.is_severe_snow,
                p.is_ice,
                p.raw_detail_data,
                b.id AS brand_id,
                b.name AS brand_name,
                b.slug AS brand_slug,
                s.id AS series_id,
                s.name AS series_name,
                s.slug AS series_slug,
                ss.code AS season_code,
                ss.name AS season_name,
                g.id AS size_group_id,
                g.label AS size_label
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series s ON s.id = p.series_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             WHERE p.eprel_registration_number = '2255384'
               AND b.slug = 'bridgestone'
               AND COALESCE(s.slug, 'unknown') = 'm749'
             LIMIT 1;

SELECT
  p2.eprel_registration_number,
  g2.label AS size_label,
  g2.width AS size_width,
  g2.profile AS size_profile,
  g2.diameter AS size_diameter,
  p2.load_index,
  p2.speed_index
FROM
  tyre_products p2
  INNER JOIN tyre_size_groups g2 ON g2.id = p2.size_group_id
WHERE
  p2.brand_id = ?
  AND (
    (p2.series_id = ?)
    OR (
      p2.series_id IS NULL
      AND ? IS NULL
    )
  )
  AND p2.is_active = 1
ORDER BY
  g2.diameter ASC,
  g2.width ASC,
  g2.profile ASC,
  p2.load_index ASC,
  p2.speed_index ASC,
  p2.eprel_registration_number ASC
LIMIT
  100

SELECT
                p2.eprel_registration_number,
                g2.label AS size_label,
                g2.width AS size_width,
                g2.profile AS size_profile,
                g2.diameter AS size_diameter,
                p2.load_index,
                p2.speed_index
             FROM tyre_products p2
             INNER JOIN tyre_size_groups g2 ON g2.id = p2.size_group_id
             WHERE p2.brand_id = 946
               AND (
                    (p2.series_id = 12995)
                    OR (p2.series_id IS NULL AND 12995 IS NULL)
               )
               AND p2.is_active = 1
             ORDER BY g2.diameter ASC, g2.width ASC, g2.profile ASC, p2.load_index ASC, p2.speed_index ASC, p2.eprel_registration_number ASC
             LIMIT 100;

SELECT
  o.id,
  o.external_id,
  o.name,
  sup.code AS supplier_code,
  sup.name AS supplier_name,
  o.match_status,
  o.match_score,
  o.is_active,
  p.net_offer_price,
  p.gross_offer_price,
  p.net_list_price,
  p.gross_list_price,
  MIN(
    tp_offer.eprel_registration_number
  ) AS linked_eprel_registration_number,
  COALESCE(
    SUM(
      CASE WHEN st.quantity > 0 THEN
        st.quantity
      ELSE
        0
      END
    ),
    0
  ) AS total_quantity,
  MAX(
    CASE WHEN st.quantity > 0 THEN
      1
    ELSE
      0
    END
  ) AS has_stock
FROM
  tyre_supplier_offers o
  INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id
  INNER JOIN tyre_suppliers sup ON sup.id = o.supplier_id
  LEFT JOIN tyre_supplier_offer_prices p ON p.offer_id = o.id
  AND p.is_current = 1
  LEFT JOIN tyre_supplier_offer_stocks st ON st.offer_id = o.id
  AND st.is_current = 1
WHERE
  tp_offer.brand_id = ?
  AND tp_offer.size_group_id = ?
  AND (
    (tp_offer.series_id = ?)
    OR (
      tp_offer.series_id IS NULL
      AND ? IS NULL
    )
  )
  AND (
    (tp_offer.load_index = ?)
    OR (
      tp_offer.load_index IS NULL
      AND ? IS NULL
    )
  )
  AND COALESCE(tp_offer.speed_index, '') = ?
  AND tp_offer.is_xl = ?
  AND tp_offer.is_runflat = ?
  AND o.match_status = ?
  AND o.is_active = 1
GROUP BY
  o.id,
  o.external_id,
  o.name,
  sup.code,
  sup.name,
  o.match_status,
  o.match_score,
  o.is_active,
  p.net_offer_price,
  p.gross_offer_price,
  p.net_list_price,
  p.gross_list_price
ORDER BY
  has_stock DESC,
  p.gross_offer_price ASC,
  p.net_offer_price ASC,
  o.id ASC

SELECT
                o.id,
                o.external_id,
                o.name,
                sup.code AS supplier_code,
                sup.name AS supplier_name,
                o.match_status,
                o.match_score,
                o.is_active,
                p.net_offer_price,
                p.gross_offer_price,
                p.net_list_price,
                p.gross_list_price,
                MIN(tp_offer.eprel_registration_number) AS linked_eprel_registration_number,
                COALESCE(SUM(CASE WHEN st.quantity > 0 THEN st.quantity ELSE 0 END), 0) AS total_quantity,
                MAX(CASE WHEN st.quantity > 0 THEN 1 ELSE 0 END) AS has_stock
             FROM tyre_supplier_offers o
             INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id
             INNER JOIN tyre_suppliers sup ON sup.id = o.supplier_id
             LEFT JOIN tyre_supplier_offer_prices p ON p.offer_id = o.id AND p.is_current = 1
             LEFT JOIN tyre_supplier_offer_stocks st ON st.offer_id = o.id AND st.is_current = 1
             WHERE tp_offer.brand_id = 946
               AND tp_offer.size_group_id = 1838
               AND (
                    (tp_offer.series_id = 12995)
                    OR (tp_offer.series_id IS NULL AND 12995 IS NULL)
               )
               AND (
                    (tp_offer.load_index = 147)
                    OR (tp_offer.load_index IS NULL AND 147 IS NULL)
               )
               AND COALESCE(tp_offer.speed_index, '') = 'L'
               AND tp_offer.is_xl = 0
               AND tp_offer.is_runflat = 0
               AND o.match_status = 'matched'
               AND o.is_active = 1
             GROUP BY
                o.id,
                o.external_id,
                o.name,
                sup.code,
                sup.name,
                o.match_status,
                o.match_score,
                o.is_active,
                p.net_offer_price,
                p.gross_offer_price,
                p.net_list_price,
                p.gross_list_price
             ORDER BY has_stock DESC, p.gross_offer_price ASC, p.net_offer_price ASC, o.id ASC;

SELECT
  lp.eprel_code AS ern,
  ph.file_name,
  ph.local_path,
  ph.sort_order,
  ph.is_primary,
  'latex' AS source
FROM
  latex_products lp
  INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
WHERE
  lp.eprel_code IN (?)
  AND ph.local_path IS NOT NULL
  AND ph.local_path <> ''
ORDER BY
  lp.eprel_code ASC,
  ph.is_primary DESC,
  ph.sort_order ASC,
  ph.id ASC

SELECT
                lp.eprel_code AS ern,
                ph.file_name,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                'latex' AS source
             FROM latex_products lp
             INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
             WHERE lp.eprel_code IN ('2255384')
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY lp.eprel_code ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC;

SELECT
  et.eprel_registration_number AS ern,
  ph.file_name,
  ph.local_path,
  ph.sort_order,
  ph.is_primary,
  'intercars' AS source
FROM
  eprel_tyres et
  INNER JOIN inter_cars_products icp ON icp.eprel_tyre_id = et.id
  INNER JOIN inter_cars_product_photos ph ON ph.product_id = icp.id
WHERE
  et.eprel_registration_number IN (?)
  AND ph.local_path IS NOT NULL
  AND ph.local_path <> ''
ORDER BY
  et.eprel_registration_number ASC,
  ph.is_primary DESC,
  ph.sort_order ASC,
  ph.id ASC

SELECT
                et.eprel_registration_number AS ern,
                ph.file_name,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                'intercars' AS source
             FROM eprel_tyres et
             INNER JOIN inter_cars_products icp ON icp.eprel_tyre_id = et.id
             INNER JOIN inter_cars_product_photos ph ON ph.product_id = icp.id
             WHERE et.eprel_registration_number IN ('2255384')
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY et.eprel_registration_number ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC;

SELECT
  COUNT(*) AS total_reviews,
  ROUND(
    AVG(r.rating_overall),
    1
  ) AS avg_overall,
  ROUND(
    AVG(r.rating_comfort),
    1
  ) AS avg_comfort,
  ROUND(
    AVG(r.rating_dry),
    1
  ) AS avg_dry,
  ROUND(
    AVG(r.rating_wet),
    1
  ) AS avg_wet,
  ROUND(
    AVG(r.rating_winter),
    1
  ) AS avg_winter,
  ROUND(
    100 * AVG(
      CASE WHEN r.recommend = 1 THEN
        1
      ELSE
        0
      END
    ),
    0
  ) AS recommend_percent
FROM
  tyre_series_reviews r
WHERE
  r.series_id = ?
  AND r.is_active = 1

SELECT
                        COUNT(*) AS total_reviews,
                        ROUND(AVG(r.rating_overall), 1) AS avg_overall,
                        ROUND(AVG(r.rating_comfort), 1) AS avg_comfort,
                        ROUND(AVG(r.rating_dry), 1) AS avg_dry,
                        ROUND(AVG(r.rating_wet), 1) AS avg_wet,
                        ROUND(AVG(r.rating_winter), 1) AS avg_winter,
                        ROUND(100 * AVG(CASE WHEN r.recommend = 1 THEN 1 ELSE 0 END), 0) AS recommend_percent
                     FROM tyre_series_reviews r
                     WHERE r.series_id = 12995
                       AND r.is_active = 1;

SELECT
  r.id,
  r.author_name,
  r.tyre_size_label,
  r.rating_overall,
  r.rating_comfort,
  r.rating_dry,
  r.rating_wet,
  r.rating_winter,
  r.recommend,
  r.is_verified_purchase,
  r.comment,
  r.created_at
FROM
  tyre_series_reviews r
WHERE
  r.series_id = ?
  AND r.is_active = 1
ORDER BY
  r.created_at DESC,
  r.id DESC
LIMIT
  ?
OFFSET
  ?

SELECT
                        r.id,
                        r.author_name,
                        r.tyre_size_label,
                        r.rating_overall,
                        r.rating_comfort,
                        r.rating_dry,
                        r.rating_wet,
                        r.rating_winter,
                        r.recommend,
                        r.is_verified_purchase,
                        r.comment,
                        r.created_at
                     FROM tyre_series_reviews r
                     WHERE r.series_id = 12995
                       AND r.is_active = 1
                     ORDER BY r.created_at DESC, r.id DESC
                     LIMIT 5 OFFSET 0;