Query Metrics

9 Database Queries
6 Different statements
17.69 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.03 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:
[
  "detailblog"
]
2 1.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.article_number AS article_number_5, t0.rang AS rang_6 FROM `typearticle` t0
Parameters:
[]
3 1.16 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 9.36 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.rang AS rang_4, a0_.keywords AS keywords_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.created_at AS created_at_9, t1_.article_number AS article_number_10, t1_.rang AS rang_11 FROM `article` a0_ LEFT JOIN `typearticle` t1_ ON a0_.typearticle_id = t1_.id WHERE a0_.title LIKE ? OR a0_.keywords LIKE ? ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "%%"
  "%%"
]
5 1.05 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 1.38 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.91 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.59 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.58 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.