Query Metrics
10
Database Queries
8
Different statements
17.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.51 ms |
SELECT m0_.id AS id_0, m0_.ip AS ip_1, m0_.reproche AS reproche_2, m0_.date_crea AS date_crea_3 FROM mod_ipbann m0_ WHERE m0_.ip = ?
Parameters:
[
"216.73.216.27"
]
|
| 2 | 0.20 ms |
SELECT m0_.id AS id_0, m0_.username AS username_1, m0_.roles AS roles_2, m0_.password AS password_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.actif AS actif_6, m0_.code AS code_7, m0_.cgu AS cgu_8, m0_.date_crea AS date_crea_9, m0_.date_modif AS date_modif_10 FROM mod_user m0_ WHERE m0_.roles LIKE ? AND m0_.actif = ?
Parameters:
[ "["ROLE_ADMIN"]" "1" ] |
| 3 | 0.12 ms |
SELECT m0_.id AS id_0, m0_.ip AS ip_1, m0_.reproche AS reproche_2, m0_.date_crea AS date_crea_3 FROM mod_ipbann m0_ WHERE m0_.ip = ?
Parameters:
[
"216.73.216.27"
]
|
| 4 | 0.12 ms |
SELECT m0_.id AS id_0, m0_.username AS username_1, m0_.roles AS roles_2, m0_.password AS password_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.actif AS actif_6, m0_.code AS code_7, m0_.cgu AS cgu_8, m0_.date_crea AS date_crea_9, m0_.date_modif AS date_modif_10 FROM mod_user m0_ WHERE m0_.roles LIKE ? AND m0_.actif = ?
Parameters:
[ "["ROLE_ADMIN"]" "1" ] |
| 5 | 0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.domaine AS domaine_3, t0.logo AS logo_4, t0.logo_l228 AS logo_l228_5, t0.charte_id AS charte_id_6 FROM mod_identite t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 6 | 0.18 ms |
SELECT m0_.id AS id_0, m0_.start AS start_1, m0_.etat AS etat_2, m0_.ordre AS ordre_3, m0_.nom AS nom_4, m0_.nomcourt AS nomcourt_5, m0_.url AS url_6, m0_.slug AS slug_7, m0_.slugcourt AS slugcourt_8, m0_.titre AS titre_9, m0_.description AS description_10, m0_.motscles AS motscles_11, m0_.priority AS priority_12, m0_.parent_id AS parent_id_13, m0_.template_id AS template_id_14, m0_.frequence_id AS frequence_id_15 FROM mod_page m0_ WHERE m0_.start = 1 AND m0_.parent_id IS NULL
Parameters:
[] |
| 7 | 0.18 ms |
SELECT m0_.id AS id_0, m0_.start AS start_1, m0_.etat AS etat_2, m0_.ordre AS ordre_3, m0_.nom AS nom_4, m0_.nomcourt AS nomcourt_5, m0_.url AS url_6, m0_.slug AS slug_7, m0_.slugcourt AS slugcourt_8, m0_.titre AS titre_9, m0_.description AS description_10, m0_.motscles AS motscles_11, m0_.priority AS priority_12, m0_.parent_id AS parent_id_13, m0_.template_id AS template_id_14, m0_.frequence_id AS frequence_id_15 FROM mod_page m0_ WHERE m0_.start = 1 AND m0_.etat = 1 AND m0_.parent_id IS NULL
Parameters:
[] |
| 8 | 7.28 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.code_js AS code_js_3, t0.page_id AS page_id_4, t0.element_id AS element_id_5, t0.conf_id AS conf_id_6 FROM mod_page_element t0 WHERE t0.page_id = ?
Parameters:
[
1
]
|
| 9 | 8.69 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.url AS url_4, t0.code_js AS code_js_5, t0.charte_id AS charte_id_6 FROM mod_element t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 10 | 0.21 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chemin AS chemin_3, t0.actif AS actif_4, t0.head_html AS head_html_5, t0.js_html AS js_html_6, t0.loading_html AS loading_html_7 FROM mod_charte t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\ModElemDivType | No errors. |
| App\Entity\VarTexte | No errors. |
| App\Entity\VarVarchar | No errors. |
| App\Entity\VarElement | No errors. |
| App\Entity\VarModPage | No errors. |
| App\Entity\VarUrl | No errors. |
| App\Entity\VarImg | No errors. |
| App\Entity\ModDivCol | No errors. |
| App\Entity\ModElemDiv | No errors. |
| App\Entity\ModDiv | No errors. |
| App\Entity\TypeImg | No errors. |
| App\Entity\ModPage | No errors. |
| App\Entity\ModCharte | No errors. |
| App\Entity\ModIdentite | No errors. |
| App\Entity\ModImage | No errors. |
| App\Entity\ModUser | No errors. |
| App\Entity\ModIpbann | No errors. |
| App\Entity\ModEssaiUser | No errors. |
| App\Entity\InfoFrequence | No errors. |
| App\Entity\ModPageElement | No errors. |
| App\Entity\ModElement | No errors. |
| App\Entity\ConfElement | No errors. |