Symfony Profiler

SELECT
  id,
  label,
  slug,
  width,
  profile,
  diameter
FROM
  tyre_size_groups
WHERE
  slug = ?
LIMIT
  1

SELECT id, label, slug, width, profile, diameter
             FROM tyre_size_groups
             WHERE slug = '145-80-r13'
             LIMIT 1;

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

SELECT
                ss.code,
                ss.name,
                ss.slug,
                NULL AS total
             FROM tyre_products p
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             WHERE p.is_active = 1 AND p.size_group_id = 1520
             GROUP BY ss.id, ss.code, ss.name, ss.slug
             ORDER BY CASE ss.code
                WHEN 'summer' THEN 1
                WHEN 'winter' THEN 2
                WHEN 'allseason' THEN 3
                ELSE 4
             END, ss.name ASC;

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.size_group_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.size_group_id = 1520
             GROUP BY b.id, b.name, b.slug
             ORDER BY b.name 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.size_group_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.size_group_id = 1520
             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 ('2625573', '1430363', '448716', '439745', '2628187', '2453672', '382792', '992972', '536675', '525507', '540229', '2384608', '2536044', '2362789', '495313', '2513406', '444202', '517444', '1186789', '630428', '590797', '419454', '493353', '1804805', '2564000', '2632213', '2631922', '2628403', '1381592', '2278815', '547380', '509582', '2682743', '2343267', '589740', '2631994', '2277039', '2545265', '569125', '521091', '521090', '504749', '504640', '481595', '463075', '463066', '616834', '2666149', '418222', '412516', '2661842', '2305710', '1007038', '992968', '801416', '437872', '419101', '436091', '506091', '497615', '472800', '2513315', '2301776', '2628620', '2628836', '2622654', '2622472', '2073087', '1831824', '710640', '547211', '526739')
               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 ('2625573', '1430363', '448716', '439745', '2628187', '2453672', '382792', '992972', '536675', '525507', '540229', '2384608', '2536044', '2362789', '495313', '2513406', '444202', '517444', '1186789', '630428', '590797', '419454', '493353', '1804805', '2564000', '2632213', '2631922', '2628403', '1381592', '2278815', '547380', '509582', '2682743', '2343267', '589740', '2631994', '2277039', '2545265', '569125', '521091', '521090', '504749', '504640', '481595', '463075', '463066', '616834', '2666149', '418222', '412516', '2661842', '2305710', '1007038', '992968', '801416', '437872', '419101', '436091', '506091', '497615', '472800', '2513315', '2301776', '2628620', '2628836', '2622654', '2622472', '2073087', '1831824', '710640', '547211', '526739')
               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;