Query Metrics

21 Database Queries
4 Different statements
7.96 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.58 ms
SELECT t0.id AS id_1, t0.opt AS opt_2, t0.data AS data_3, t0.type AS type_4, t0.options AS options_5 FROM setting t0
Parameters:
[]
2 0.56 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "business/enquiry.html.twig"
]
3 0.37 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "business/enquiry.html.twig"
]
4 0.27 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "business/base.html.twig"
]
5 0.24 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "business/base.html.twig"
]
6 0.25 ms
SELECT t0.id AS id_1, t0.opt AS opt_2, t0.data AS data_3, t0.type AS type_4, t0.options AS options_5 FROM setting t0
Parameters:
[]
7 0.29 ms
SELECT t0.id AS id_1, t0.opt AS opt_2, t0.data AS data_3, t0.type AS type_4, t0.options AS options_5 FROM setting t0
Parameters:
[]
8 1.38 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_head"
]
9 0.26 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_head"
]
10 0.22 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_head"
]
11 0.24 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_head"
]
12 0.25 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_head"
]
13 0.22 ms
SELECT DATABASE()
Parameters:
[]
14 0.59 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "phcom_db"
]
15 0.17 ms
SELECT DATABASE()
Parameters:
[]
16 0.27 ms
SELECT t0.id AS id_1, t0.opt AS opt_2, t0.data AS data_3, t0.type AS type_4, t0.options AS options_5 FROM setting t0
Parameters:
[]
17 0.84 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_header"
]
18 0.27 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_header"
]
19 0.23 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_header"
]
20 0.25 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_header"
]
21 0.23 ms
SELECT t0.id AS id_1, t0.source AS source_2, t0.name AS name_3, t0.last_update AS last_update_4, t0.backup1 AS backup1_5, t0.backup1_date AS backup1_date_6, t0.backup2 AS backup2_7, t0.backup2_date AS backup2_date_8, t0.style AS style_9, t0.location AS location_10, t0.can_delete AS can_delete_11 FROM template t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_header"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
App\Entity\Template No errors.