Query Metrics
20
Database Queries
4
Different statements
13.67 ms
Query time
0
Invalid entities
108
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.14 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"theme"
]
|
2 | 0.35 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"theme"
]
|
3 | 0.72 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"theme"
]
|
4 | 0.45 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"theme"
]
|
5 | 1.53 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.link = ? LIMIT 1
Parameters:
[
"/"
]
|
6 | 0.70 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"facebook"
]
|
7 | 0.86 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"facebook"
]
|
8 | 1.11 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"twitter"
]
|
9 | 0.39 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"linkedin"
]
|
10 | 0.84 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"linkedin"
]
|
11 | 0.32 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"instagram"
]
|
12 | 0.25 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"instagram"
]
|
13 | 0.33 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"mailto"
]
|
14 | 0.18 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"mailto"
]
|
15 | 0.27 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"youtube"
]
|
16 | 0.23 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"youtube"
]
|
17 | 0.32 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"espace_pro"
]
|
18 | 0.31 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.link = ? LIMIT 1
Parameters:
[
"/"
]
|
19 | 1.73 ms |
SELECT m0_.id AS id_0, m0_.text AS text_1, m0_.link AS link_2, m0_.image AS image_3, m0_.resume AS resume_4, m0_.texte_complet AS texte_complet_5, m0_.colonne AS colonne_6, m0_.position AS position_7, m0_.type AS type_8, m0_.link_type AS link_type_9, m0_.display_title AS display_title_10, m0_.is_only_for_subscriber AS is_only_for_subscriber_11, m0_.is_only_for_admin AS is_only_for_admin_12, m1_.id AS id_13, m1_.text AS text_14, m1_.link AS link_15, m1_.image AS image_16, m1_.resume AS resume_17, m1_.texte_complet AS texte_complet_18, m1_.colonne AS colonne_19, m1_.position AS position_20, m1_.type AS type_21, m1_.link_type AS link_type_22, m1_.display_title AS display_title_23, m1_.is_only_for_subscriber AS is_only_for_subscriber_24, m1_.is_only_for_admin AS is_only_for_admin_25, m2_.id AS id_26, m2_.text AS text_27, m2_.link AS link_28, m2_.image AS image_29, m2_.resume AS resume_30, m2_.texte_complet AS texte_complet_31, m2_.colonne AS colonne_32, m2_.position AS position_33, m2_.type AS type_34, m2_.link_type AS link_type_35, m2_.display_title AS display_title_36, m2_.is_only_for_subscriber AS is_only_for_subscriber_37, m2_.is_only_for_admin AS is_only_for_admin_38, m0_.parent_id AS parent_id_39, m1_.parent_id AS parent_id_40, m2_.parent_id AS parent_id_41 FROM menu m0_ LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu m2_ ON m1_.id = m2_.parent_id WHERE m0_.parent_id IS NULL ORDER BY m0_.position ASC, m0_.text ASC, m1_.colonne ASC, m1_.position ASC, m2_.colonne ASC, m2_.position ASC
Parameters:
[] |
20 | 1.64 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.colonne ASC, t0.position ASC
Parameters:
[ 91 124 125 81 82 83 84 85 86 87 126 88 89 92 110 49 94 106 95 113 96 97 98 99 105 104 114 100 101 102 103 115 116 117 118 119 108 109 121 122 123 41 42 43 44 45 62 63 64 76 ] |
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Menu | 101 |
App\Entity\Setting | 7 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Setting | No errors. |
App\Entity\Menu | No errors. |