Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.59 ms Query time

0 Invalid entities

Time▼	Count	Info
1.25 ms (78.54%)	2	SELECT * FROM school s INNER JOIN school_education e ON s.id = e.school_id WHERE e.education_id = ? ORDER BY s.updated_at DESC Parameters: [`488`] View formatted query View runnable query Explain query SELECT * FROM school s INNER JOIN school_education e ON s.id = e.school_id WHERE e.education_id = ? ORDER BY s.updated_at DESC SELECT * FROM school s INNER JOIN school_education e ON s.id = e.school_id WHERE e.education_id = 488 ORDER BY s.updated_at DESC;
0.34 ms (21.46%)	1	SELECT edu.id, edu.parent_id, edu.name, edu.url, edu.image, edu.css_class FROM education edu WHERE id = ? ORDER BY edu.name ASC Parameters: [`488`] View formatted query View runnable query Explain query SELECT edu.id, edu.parent_id, edu.name, edu.url, edu.image, edu.css_class FROM education edu WHERE id = ? ORDER BY edu.name ASC SELECT edu.id, edu.parent_id, edu.name, edu.url, edu.image, edu.css_class FROM education edu WHERE id = 488 ORDER BY edu.name ASC;

Time▼

Count

Info

1.25 ms
(78.54%)

SELECT * FROM school s INNER JOIN school_education e ON s.id = e.school_id WHERE e.education_id = ? ORDER BY s.updated_at DESC

Parameters:

[
  488
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  school s
  INNER JOIN school_education e ON s.id = e.school_id
WHERE
  e.education_id = ?
ORDER BY
  s.updated_at DESC

SELECT * FROM school s INNER JOIN school_education e ON s.id = e.school_id WHERE e.education_id = 488 ORDER BY s.updated_at DESC;

0.34 ms
(21.46%)

SELECT edu.id, edu.parent_id, edu.name, edu.url, edu.image, edu.css_class FROM education edu WHERE id = ? ORDER BY edu.name ASC

Parameters:

[
  488
]

View formatted query View runnable query Explain query

SELECT
  edu.id,
  edu.parent_id,
  edu.name,
  edu.url,
  edu.image,
  edu.css_class
FROM
  education edu
WHERE
  id = ?
ORDER BY
  edu.name ASC

SELECT edu.id, edu.parent_id, edu.name, edu.url, edu.image, edu.css_class FROM education edu WHERE id = 488 ORDER BY edu.name ASC;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.