Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

29.54 ms Query time

0 Invalid entities

Time▼	Count	Info
28.12 ms (95.20%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"pyntrip"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'pyntrip' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
1.42 ms (4.80%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Time▼

Count

Info

28.12 ms
(95.20%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "pyntrip"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'pyntrip'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

1.42 ms
(4.80%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Name	Service
bookingEngine	doctrine.dbal.bookingEngine_connection

Name	Service
bookingEngine	doctrine.orm.bookingEngine_entity_manager

Second Level Cache is not enabled.

No loaded entities.