Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

1.62 ms Query time

0 Invalid entities

#▲	Time	Info
1	0.94 ms	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: [`37`] 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 = 37 ORDER BY s.updated_at DESC;
2	0.68 ms	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: [`38`] 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 = 38 ORDER BY s.updated_at DESC;

#▲

Time

Info

0.94 ms

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:

[
  37
]

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 = 37 ORDER BY s.updated_at DESC;

0.68 ms

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:

[
  38
]

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 = 38 ORDER BY s.updated_at DESC;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.