Query Metrics
48
Database Queries
25
Different statements
47.76 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.71 ms |
SELECT t0.id AS id_1, t0.content_url AS content_url_2, t0.file_path AS file_path_3, t0.image_size AS image_size_4, t0.original_name AS original_name_5, t0.date AS date_6, t0.mime_type AS mime_type_7, t0.title AS title_8, t0.description AS description_9, t0.link AS link_10, t0.videolink AS videolink_11, t0.user_id AS user_id_12 FROM `slideaccueil` t0
Parameters:
[] |
2 | 1.55 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:
[
"aboutWithArticle"
]
|
3 | 0.94 ms |
SELECT t0.id AS id_1, t0.content_url AS content_url_2, t0.file_path AS file_path_3, t0.image_size AS image_size_4, t0.original_name AS original_name_5, t0.date AS date_6, t0.mime_type AS mime_type_7, t0.name AS name_8, t0.description AS description_9, t0.link AS link_10, t0.user_id AS user_id_11 FROM `partenaire` t0
Parameters:
[] |
4 | 0.80 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:
[
"detailservice"
]
|
5 | 0.61 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:
[
"detailtestimonial"
]
|
6 | 1.50 ms |
SELECT t0_.id AS id_0, t0_.content_url AS content_url_1, t0_.file_path AS file_path_2, t0_.image_size AS image_size_3, t0_.original_name AS original_name_4, t0_.date AS date_5, t0_.mime_type AS mime_type_6, t0_.description AS description_7, t0_.autor_name AS autor_name_8, t0_.autor_poste AS autor_poste_9, t0_.note AS note_10, t0_.user_id AS user_id_11 FROM `testimonial` t0_ ORDER BY t0_.note DESC
Parameters:
[] |
7 | 0.84 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:
[
"calltoaction"
]
|
8 | 0.56 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:
[
"detailteam"
]
|
9 | 0.98 ms |
SELECT t0_.id AS id_0, t0_.content_url AS content_url_1, t0_.file_path AS file_path_2, t0_.image_size AS image_size_3, t0_.original_name AS original_name_4, t0_.date AS date_5, t0_.mime_type AS mime_type_6, t0_.autor_name AS autor_name_7, t0_.autor_poste AS autor_poste_8, t0_.autor_degree AS autor_degree_9, t0_.youtube AS youtube_10, t0_.facebook AS facebook_11, t0_.linked_in AS linked_in_12, t0_.twitter AS twitter_13, t0_.instagram AS instagram_14, t0_.speach AS speach_15, t0_.rang AS rang_16, t0_.user_id AS user_id_17 FROM `team` t0_ ORDER BY t0_.rang ASC
Parameters:
[] |
10 | 0.80 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:
[
"detailpricing"
]
|
11 | 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:
[
"detailfaq"
]
|
12 | 0.55 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"
]
|
13 | 0.89 ms |
SELECT f0_.id AS id_0, f0_.content_url AS content_url_1, f0_.file_path AS file_path_2, f0_.image_size AS image_size_3, f0_.original_name AS original_name_4, f0_.date AS date_5, f0_.mime_type AS mime_type_6, f0_.question AS question_7, f0_.response AS response_8, f0_.user_id AS user_id_9 FROM `faq` f0_ ORDER BY f0_.id ASC
Parameters:
[] |
14 | 0.97 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"
]
|
15 | 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:
[] |
16 | 1.33 ms |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.rapport AS rapport_3, p0_.date AS date_4, p0_.rang AS rang_5, p0_.nblike AS nblike_6, p0_.nbvente AS nbvente_7, p0_.choixauteur AS choixauteur_8, p0_.newprise AS newprise_9, p0_.lastprise AS lastprise_10, p0_.difference AS difference_11, p0_.user_id AS user_id_12, p0_.service_id AS service_id_13, p0_.imgproduit_id AS imgproduit_id_14 FROM produit p0_ ORDER BY p0_.rang ASC
Parameters:
[] |
17 | 1.68 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13 FROM `service` s0_ WHERE s0_.expertise LIKE ? ORDER BY s0_.date DESC) dctrn_result) dctrn_table
Parameters:
[
"%service%"
]
|
18 | 1.61 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_5 FROM (SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13 FROM `service` s0_ WHERE s0_.expertise LIKE ?) dctrn_result_inner ORDER BY date_5 DESC) dctrn_result LIMIT 20
Parameters:
[
"%service%"
]
|
19 | 1.23 ms |
SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13, s0_.user_id AS user_id_14 FROM `service` s0_ WHERE s0_.expertise LIKE ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.date DESC
Parameters:
[ "%service%" 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 39 36 46 29 31 ] |
20 | 1.05 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13 FROM `service` s0_ WHERE s0_.expertise LIKE ? ORDER BY s0_.date DESC) dctrn_result) dctrn_table
Parameters:
[
"%departement%"
]
|
21 | 0.93 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_5 FROM (SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13 FROM `service` s0_ WHERE s0_.expertise LIKE ?) dctrn_result_inner ORDER BY date_5 DESC) dctrn_result LIMIT 20
Parameters:
[
"%departement%"
]
|
22 | 0.92 ms |
SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13, s0_.user_id AS user_id_14 FROM `service` s0_ WHERE s0_.expertise LIKE ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.date DESC
Parameters:
[ "%departement%" 17 42 16 18 19 20 15 14 11 10 13 12 ] |
23 | 0.69 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"
]
|
24 | 1.00 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:
[] |
25 | 0.93 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:
[] |
26 | 1.20 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"
]
|
27 | 1.02 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"
]
|
28 | 1.01 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"
]
|
29 | 0.72 ms |
SELECT DATABASE()
Parameters:
[] |
30 | 1.24 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"syscofie_db"
]
|
31 | 0.31 ms |
SELECT DATABASE()
Parameters:
[] |
32 | 0.68 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"syscofie_db"
]
|
33 | 0.34 ms |
SELECT DATABASE()
Parameters:
[] |
34 | 1.03 ms |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "syscofie_db" "doctrine_migration_versions" ] |
35 | 0.34 ms |
SELECT DATABASE()
Parameters:
[] |
36 | 1.37 ms |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'syscofie_db' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "syscofie_db" "doctrine_migration_versions" ] |
37 | 2.90 ms |
SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'syscofie_db' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "syscofie_db" "syscofie_db" "doctrine_migration_versions" ] |
38 | 0.43 ms |
SELECT DATABASE()
Parameters:
[] |
39 | 0.86 ms |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "syscofie_db" "doctrine_migration_versions" ] |
40 | 0.47 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
41 | 0.45 ms |
SELECT DATABASE()
Parameters:
[] |
42 | 1.60 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:
[
"aboutplatform"
]
|
43 | 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 = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
"socialmedia"
]
|
44 | 0.63 ms |
SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13, s0_.user_id AS user_id_14 FROM `service` s0_ ORDER BY s0_.date ASC LIMIT 5
Parameters:
[] |
45 | 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 = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
"contacts"
]
|
46 | 0.45 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"
]
|
47 | 3.23 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_5 FROM (SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13 FROM `service` s0_ WHERE s0_.expertise LIKE ?) dctrn_result_inner ORDER BY date_5 DESC) dctrn_result LIMIT 8
Parameters:
[
"%departement%"
]
|
48 | 1.09 ms |
SELECT s0_.id AS id_0, s0_.content_url AS content_url_1, s0_.file_path AS file_path_2, s0_.image_size AS image_size_3, s0_.original_name AS original_name_4, s0_.date AS date_5, s0_.mime_type AS mime_type_6, s0_.name AS name_7, s0_.rang AS rang_8, s0_.description AS description_9, s0_.expertise AS expertise_10, s0_.motcle AS motcle_11, s0_.parent_id AS parent_id_12, s0_.objectifs AS objectifs_13, s0_.user_id AS user_id_14 FROM `service` s0_ WHERE s0_.expertise LIKE ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.date DESC
Parameters:
[ "%departement%" 17 42 16 18 19 20 15 14 ] |
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.