Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 WHERE t0.slug = ? LIMIT 1

[
  "ford"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.ext_source AS ext_source_4,
  t0.ext_id AS ext_id_5
FROM
  makes t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 WHERE t0.slug = 'ford' LIMIT 1;

SELECT DISTINCT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.ext_id AS ext_id_3, m0_.make_id AS make_id_4 FROM models m0_ INNER JOIN part_listings p1_ ON (p1_.model_id = m0_.id AND p1_.quantity > 0) INNER JOIN users u2_ ON p1_.owner_id = u2_.id INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id WHERE m0_.make_id = ? AND c3_.status = ? ORDER BY m0_.name ASC

[
  117
  "active"
]

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.slug AS slug_2,
  m0_.ext_id AS ext_id_3,
  m0_.make_id AS make_id_4
FROM
  models m0_
  INNER JOIN part_listings p1_ ON (
    p1_.model_id = m0_.id
    AND p1_.quantity > 0
  )
  INNER JOIN users u2_ ON p1_.owner_id = u2_.id
  INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id
WHERE
  m0_.make_id = ?
  AND c3_.status = ?
ORDER BY
  m0_.name ASC

SELECT DISTINCT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.ext_id AS ext_id_3, m0_.make_id AS make_id_4 FROM models m0_ INNER JOIN part_listings p1_ ON (p1_.model_id = m0_.id AND p1_.quantity > 0) INNER JOIN users u2_ ON p1_.owner_id = u2_.id INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id WHERE m0_.make_id = 117 AND c3_.status = 'active' ORDER BY m0_.name ASC;

SELECT t0.id AS id_1, t0.year_from AS year_from_2, t0.year_to AS year_to_3, t0.generation_name AS generation_name_4, t0.model_id AS model_id_5 FROM vehicle_ranges t0 WHERE t0.model_id = ?

[
  1472
]

SELECT
  t0.id AS id_1,
  t0.year_from AS year_from_2,
  t0.year_to AS year_to_3,
  t0.generation_name AS generation_name_4,
  t0.model_id AS model_id_5
FROM
  vehicle_ranges t0
WHERE
  t0.model_id = ?

SELECT t0.id AS id_1, t0.year_from AS year_from_2, t0.year_to AS year_to_3, t0.generation_name AS generation_name_4, t0.model_id AS model_id_5 FROM vehicle_ranges t0 WHERE t0.model_id = 1472;