Query Metrics
9
Database Queries
6
Different statements
7.87 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.98 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.type_param AS type_param_3, t0.valeur AS valeur_4, t0.title AS title_5, t0.created_at AS created_at_6, t0.rang AS rang_7, t0.content_url AS content_url_8, t0.file_path AS file_path_9, t0.image_size AS image_size_10, t0.original_name AS original_name_11, t0.mime_type AS mime_type_12, t0.link AS link_13, t0.user_id AS user_id_14 FROM `parametre` t0 WHERE t0.type_param = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
"detailintervention"
]
|
2 | 1.28 ms |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.created_at AS created_at_3, i0_.img_number AS img_number_4, i0_.rang AS rang_5, i0_.content_url AS content_url_6, i0_.file_path AS file_path_7, i0_.image_size AS image_size_8, i0_.original_name AS original_name_9, i0_.mime_type AS mime_type_10, i0_.user_id AS user_id_11 FROM `intervention` i0_ WHERE i0_.img_number > 2 ORDER BY i0_.rang DESC
Parameters:
[] |
3 | 0.85 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.type_param AS type_param_3, t0.valeur AS valeur_4, t0.title AS title_5, t0.created_at AS created_at_6, t0.rang AS rang_7, t0.content_url AS content_url_8, t0.file_path AS file_path_9, t0.image_size AS image_size_10, t0.original_name AS original_name_11, t0.mime_type AS mime_type_12, t0.link AS link_13, t0.user_id AS user_id_14 FROM `parametre` t0 WHERE t0.type_param = ? LIMIT 1
Parameters:
[
"templatewebsite"
]
|
4 | 1.47 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.created_at AS created_at_3, i0_.img_number AS img_number_4, i0_.rang AS rang_5, i0_.content_url AS content_url_6, i0_.file_path AS file_path_7, i0_.image_size AS image_size_8, i0_.original_name AS original_name_9, i0_.mime_type AS mime_type_10 FROM `intervention` i0_ ORDER BY i0_.name ASC) dctrn_result) dctrn_table
Parameters:
[] |
5 | 0.74 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.lieu AS lieu_4, t0.date AS date_5, t0.image AS image_6 FROM agence t0
Parameters:
[] |
6 | 0.96 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.article_number AS article_number_4, t0_.rang AS rang_5 FROM `typearticle` t0_ ORDER BY t0_.rang ASC
Parameters:
[] |
7 | 0.62 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.type_param AS type_param_3, t0.valeur AS valeur_4, t0.title AS title_5, t0.created_at AS created_at_6, t0.rang AS rang_7, t0.content_url AS content_url_8, t0.file_path AS file_path_9, t0.image_size AS image_size_10, t0.original_name AS original_name_11, t0.mime_type AS mime_type_12, t0.link AS link_13, t0.user_id AS user_id_14 FROM `parametre` t0 WHERE t0.type_param = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
"contacts"
]
|
8 | 0.50 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.type_param AS type_param_3, t0.valeur AS valeur_4, t0.title AS title_5, t0.created_at AS created_at_6, t0.rang AS rang_7, t0.content_url AS content_url_8, t0.file_path AS file_path_9, t0.image_size AS image_size_10, t0.original_name AS original_name_11, t0.mime_type AS mime_type_12, t0.link AS link_13, t0.user_id AS user_id_14 FROM `parametre` t0 WHERE t0.type_param = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
"socialmedia"
]
|
9 | 0.46 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.type_param AS type_param_3, t0.valeur AS valeur_4, t0.title AS title_5, t0.created_at AS created_at_6, t0.rang AS rang_7, t0.content_url AS content_url_8, t0.file_path AS file_path_9, t0.image_size AS image_size_10, t0.original_name AS original_name_11, t0.mime_type AS mime_type_12, t0.link AS link_13, t0.user_id AS user_id_14 FROM `parametre` t0 WHERE t0.type_param = ? LIMIT 1
Parameters:
[
"templatewebsite"
]
|
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\Projet\Portfolio\Intervention | No errors. |
App\Entity\Users\Adminuser\Parametre | No errors. |
App\Entity\Users\User\User | No errors. |
App\Entity\Produit\Service\Agence | No errors. |
App\Entity\Produit\Service\Typearticle | No errors. |