Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT code, name, slug, NULL AS total
                 FROM tyre_seasons
                 ORDER BY CASE code
                    WHEN 'summer' THEN 1
                    WHEN 'winter' THEN 2
                    WHEN 'allseason' THEN 3
                    ELSE 4
                 END, name ASC

[]

SELECT
  code,
  name,
  slug,
  NULL AS total
FROM
  tyre_seasons
ORDER BY
  CASE code
  WHEN 'summer' THEN
    1
  WHEN 'winter' THEN
    2
  WHEN 'allseason' THEN
    3
  ELSE
    4
  END,
  name ASC

SELECT code, name, slug, NULL AS total
                 FROM tyre_seasons
                 ORDER BY CASE code
                    WHEN 'summer' THEN 1
                    WHEN 'winter' THEN 2
                    WHEN 'allseason' THEN 3
                    ELSE 4
                 END, name ASC;

SELECT name, slug, NULL AS total
                 FROM tyre_brands
                 ORDER BY name ASC
                 LIMIT ?

[
  24
]

SELECT
  name,
  slug,
  NULL AS total
FROM
  tyre_brands
ORDER BY
  name ASC
LIMIT
  ?

SELECT name, slug, NULL AS total
                 FROM tyre_brands
                 ORDER BY name ASC
                 LIMIT 24;

SELECT label, slug, width, profile, diameter, NULL AS total
                 FROM tyre_size_groups
                 ORDER BY diameter ASC, width ASC, profile ASC, label ASC
                 LIMIT ?

[
  24
]

SELECT
  label,
  slug,
  width,
  profile,
  diameter,
  NULL AS total
FROM
  tyre_size_groups
ORDER BY
  diameter ASC,
  width ASC,
  profile ASC,
  label ASC
LIMIT
  ?

SELECT label, slug, width, profile, diameter, NULL AS total
                 FROM tyre_size_groups
                 ORDER BY diameter ASC, width ASC, profile ASC, label 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
             ORDER BY p.id DESC
             LIMIT ?

[
  "unknown"
  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
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
             ORDER BY p.id DESC
             LIMIT 24;

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

[
  "493764"
  "493802"
  "493801"
  "493786"
  "493782"
  "493778"
  "467156"
  "467138"
  "467113"
  "467245"
  "467208"
  "467206"
  "467191"
  "468104"
  "468084"
  "468073"
  "468068"
  "467797"
  "467790"
  "467787"
  "467784"
  "467781"
  "467777"
  "467775"
]

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 ('493764', '493802', '493801', '493786', '493782', '493778', '467156', '467138', '467113', '467245', '467208', '467206', '467191', '468104', '468084', '468073', '468068', '467797', '467790', '467787', '467784', '467781', '467777', '467775')
               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

[
  "493764"
  "493802"
  "493801"
  "493786"
  "493782"
  "493778"
  "467156"
  "467138"
  "467113"
  "467245"
  "467208"
  "467206"
  "467191"
  "468104"
  "468084"
  "468073"
  "468068"
  "467797"
  "467790"
  "467787"
  "467784"
  "467781"
  "467777"
  "467775"
]

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 ('493764', '493802', '493801', '493786', '493782', '493778', '467156', '467138', '467113', '467245', '467208', '467206', '467191', '468104', '468084', '468073', '468068', '467797', '467790', '467787', '467784', '467781', '467777', '467775')
               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;