Query Metrics
6
Database Queries
4
Different statements
3.77 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.04 ms |
SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1
Parameters:
[ "/localite/blaye-en" 1 ] |
2 | 0.15 ms |
SELECT l0_.id AS id_0, l0_.active AS active_1, l0_.name AS name_2, l0_.language_code AS language_code_3, l0_.flag AS flag_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6 FROM language l0_ WHERE l0_.active = 1 ORDER BY l0_.id ASC
Parameters:
[] |
3 | 0.96 ms |
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.actif AS actif_2, s0_.activite_primaire_ids AS activite_primaire_ids_3, s0_.activite_secondaire_ids AS activite_secondaire_ids_4, s0_.tag_managerhead AS tag_managerhead_5, s0_.tag_managerbody AS tag_managerbody_6, s0_.DateCreation AS DateCreation_7, s0_.DateModification AS DateModification_8 FROM secteurs s0_ INNER JOIN secteurs_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? AND s0_.actif = 1 AND s1_.libelle_url = ?
Parameters:
[ "fr" "blaye-en" ] |
4 | 0.45 ms |
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.actif AS actif_2, s0_.activite_primaire_ids AS activite_primaire_ids_3, s0_.activite_secondaire_ids AS activite_secondaire_ids_4, s0_.tag_managerhead AS tag_managerhead_5, s0_.tag_managerbody AS tag_managerbody_6, s0_.DateCreation AS DateCreation_7, s0_.DateModification AS DateModification_8 FROM secteurs s0_ INNER JOIN secteurs_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? AND s0_.actif = 1 AND s1_.libelle_url = ?
Parameters:
[ "en" "blaye-en" ] |
5 | 0.16 ms |
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.actif AS actif_2, s0_.activite_primaire_ids AS activite_primaire_ids_3, s0_.activite_secondaire_ids AS activite_secondaire_ids_4, s0_.tag_managerhead AS tag_managerhead_5, s0_.tag_managerbody AS tag_managerbody_6, s0_.DateCreation AS DateCreation_7, s0_.DateModification AS DateModification_8 FROM secteurs s0_ INNER JOIN secteurs_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? AND s0_.actif = 1 AND s1_.libelle_url = ?
Parameters:
[ "en" "blaye-en" ] |
6 | 1.02 ms |
SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = ? LIMIT 1
Parameters:
[
"blaye-en"
]
|
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\User | No errors. |
App\Entity\Redirection | No errors. |
App\Entity\Site | No errors. |
App\Entity\Secteurs | No errors. |
App\Entity\Language | No errors. |
App\Entity\SecteursTranslation | No errors. |
App\Entity\UrlRef | No errors. |
App\Entity\UrlPost | No errors. |
App\Entity\UrlPostTranslation | No errors. |