Symfony Profiler

SELECT
  id,
  code,
  name,
  slug
FROM
  tyre_seasons
WHERE
  slug = ?
LIMIT
  1

SELECT id, code, name, slug
             FROM tyre_seasons
             WHERE slug = 'zimowe'
             LIMIT 1;

SELECT
  b.name,
  b.slug,
  NULL AS total
FROM
  tyre_products p
  INNER JOIN tyre_brands b ON b.id = p.brand_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.is_active = 1
  AND p.season_id = ?
GROUP BY
  b.id,
  b.name,
  b.slug
ORDER BY
  b.name ASC
LIMIT
  ?

SELECT
                b.name,
                b.slug,
                NULL AS total
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_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.is_active = 1 AND p.season_id = 8
             GROUP BY b.id, b.name, b.slug
             ORDER BY b.name ASC
             LIMIT 24;

SELECT
  g.label,
  g.slug,
  g.width,
  g.profile,
  g.diameter,
  NULL AS total
FROM
  tyre_products p
  INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
  INNER JOIN tyre_seasons ss ON ss.id = p.season_id
  INNER JOIN tyre_brands b ON b.id = p.brand_id
WHERE
  p.is_active = 1
  AND p.season_id = ?
GROUP BY
  g.id,
  g.label,
  g.slug,
  g.width,
  g.profile,
  g.diameter
ORDER BY
  g.diameter ASC,
  g.width ASC,
  g.profile ASC
LIMIT
  ?

SELECT
                g.label,
                g.slug,
                g.width,
                g.profile,
                g.diameter,
                NULL AS total
             FROM tyre_products p
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             WHERE p.is_active = 1 AND p.season_id = 8
             GROUP BY g.id, g.label, g.slug, g.width, g.profile, g.diameter
             ORDER BY g.diameter ASC, g.width ASC, g.profile ASC
             LIMIT 24;

SELECT
  p.eprel_registration_number,
  p.commercial_name,
  p.model_identifier,
  p.load_index,
  p.speed_index,
  p.energy_class,
  p.wet_grip_class,
  p.noise_value,
  p.noise_class,
  p.is_xl,
  p.is_runflat,
  b.name AS brand_name,
  b.slug AS brand_slug,
  COALESCE(
    s.name, p.commercial_name, p.model_identifier
  ) AS series_name,
  COALESCE(s.slug, ?) AS series_slug,
  g.label AS size_label,
  g.slug AS size_slug,
  ss.name AS season_name,
  ss.slug AS season_slug
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_size_groups g ON g.id = p.size_group_id
  INNER JOIN tyre_seasons ss ON ss.id = p.season_id
WHERE
  p.is_active = 1
  AND p.season_id = ?
ORDER BY
  p.id DESC
LIMIT
  ?

SELECT
                p.eprel_registration_number,
                p.commercial_name,
                p.model_identifier,
                p.load_index,
                p.speed_index,
                p.energy_class,
                p.wet_grip_class,
                p.noise_value,
                p.noise_class,
                p.is_xl,
                p.is_runflat,
                b.name AS brand_name,
                b.slug AS brand_slug,
                COALESCE(s.name, p.commercial_name, p.model_identifier) AS series_name,
                COALESCE(s.slug, 'unknown') AS series_slug,
                g.label AS size_label,
                g.slug AS size_slug,
                ss.name AS season_name,
                ss.slug AS season_slug
             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_size_groups g ON g.id = p.size_group_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             WHERE p.is_active = 1 AND p.season_id = 8
             ORDER BY p.id DESC
             LIMIT 72;

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 ('493801', '493786', '493782', '493778', '467156', '467113', '467245', '467208', '467206', '467191', '468104', '468084', '468073', '468068', '467777', '467775', '466974', '466968', '466958', '467076', '467067', '467061', '467043', '467038', '467753', '467752', '467690', '467675', '467375', '467267', '467250', '419421', '419418', '419414', '972447', '972395', '447010', '446990', '446979', '446970', '446960', '446947', '446907', '446890', '446839', '446831', '446803', '446718', '446700', '446447', '446440', '659054', '659038', '659009', '659002', '658995', '659173', '659172', '658959', '659169', '615208', '615200', '412347', '412343', '412529', '412528', '412340', '412316', '412310', '412307', '412303', '506078')
               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 ('493801', '493786', '493782', '493778', '467156', '467113', '467245', '467208', '467206', '467191', '468104', '468084', '468073', '468068', '467777', '467775', '466974', '466968', '466958', '467076', '467067', '467061', '467043', '467038', '467753', '467752', '467690', '467675', '467375', '467267', '467250', '419421', '419418', '419414', '972447', '972395', '447010', '446990', '446979', '446970', '446960', '446947', '446907', '446890', '446839', '446831', '446803', '446718', '446700', '446447', '446440', '659054', '659038', '659009', '659002', '658995', '659173', '659172', '658959', '659169', '615208', '615200', '412347', '412343', '412529', '412528', '412340', '412316', '412310', '412307', '412303', '506078')
               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;