GET https://azertyll.fr/

Query Metrics

11 Database Queries
4 Different statements
3.46 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.picture AS picture_4, t0.link AS link_5 FROM project t0
Parameters:
[]
2 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price_min AS price_min_4, t0.price_max AS price_max_5, t0.options AS options_6, t0.tag_id AS tag_id_7 FROM offer t0
Parameters:
[]
3 0.34 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.tag_id AS tag_id_3 FROM project_tag t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
4 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t4.id AS id_5, t4.name AS name_6, t4.description AS description_7, t4.price_min AS price_min_8, t4.price_max AS price_max_9, t4.options AS options_10, t4.tag_id AS tag_id_11 FROM tag t0 LEFT JOIN offer t4 ON t4.tag_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
5 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t4.id AS id_5, t4.name AS name_6, t4.description AS description_7, t4.price_min AS price_min_8, t4.price_max AS price_max_9, t4.options AS options_10, t4.tag_id AS tag_id_11 FROM tag t0 LEFT JOIN offer t4 ON t4.tag_id = t0.id WHERE t0.id = ?
Parameters:
[
  7
]
6 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t4.id AS id_5, t4.name AS name_6, t4.description AS description_7, t4.price_min AS price_min_8, t4.price_max AS price_max_9, t4.options AS options_10, t4.tag_id AS tag_id_11 FROM tag t0 LEFT JOIN offer t4 ON t4.tag_id = t0.id WHERE t0.id = ?
Parameters:
[
  14
]
7 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t4.id AS id_5, t4.name AS name_6, t4.description AS description_7, t4.price_min AS price_min_8, t4.price_max AS price_max_9, t4.options AS options_10, t4.tag_id AS tag_id_11 FROM tag t0 LEFT JOIN offer t4 ON t4.tag_id = t0.id WHERE t0.id = ?
Parameters:
[
  11
]
8 0.18 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.tag_id AS tag_id_3 FROM project_tag t0 WHERE t0.project_id = ?
Parameters:
[
  2
]
9 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t4.id AS id_5, t4.name AS name_6, t4.description AS description_7, t4.price_min AS price_min_8, t4.price_max AS price_max_9, t4.options AS options_10, t4.tag_id AS tag_id_11 FROM tag t0 LEFT JOIN offer t4 ON t4.tag_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
10 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t4.id AS id_5, t4.name AS name_6, t4.description AS description_7, t4.price_min AS price_min_8, t4.price_max AS price_max_9, t4.options AS options_10, t4.tag_id AS tag_id_11 FROM tag t0 LEFT JOIN offer t4 ON t4.tag_id = t0.id WHERE t0.id = ?
Parameters:
[
  15
]
11 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t4.id AS id_5, t4.name AS name_6, t4.description AS description_7, t4.price_min AS price_min_8, t4.price_max AS price_max_9, t4.options AS options_10, t4.tag_id AS tag_id_11 FROM tag t0 LEFT JOIN offer t4 ON t4.tag_id = t0.id WHERE t0.id = ?
Parameters:
[
  4
]

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\Project No errors.
App\Entity\ProjectTag No errors.
App\Entity\Offer No errors.
App\Entity\Tag No errors.