Query Metrics
173
Database Queries
8
Different statements
13.03 ms
Query time
0
Invalid entities
277
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.23 ms (47.80%) |
86 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sitemap AS sitemap_4, t0.sitemap_priority AS sitemap_priority_5, t0.nofollow AS nofollow_6, t0.locale AS locale_7, t0.ogType AS ogType_8, t0.route_id AS route_id_9, t0.cms_id AS cms_id_10, t0.og_image_id AS og_image_id_11 FROM core_cms_seo t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
5.27 ms (40.42%) |
81 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.controller AS controller_4, t0.component AS component_5, t0.expose AS expose_6, t0.seo_id AS seo_id_7, t0.context_id AS context_id_8 FROM core_url t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.58 ms (4.47%) |
1 |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.statut AS statut_2, c0_.titre AS titre_3, c0_.description AS description_4, c0_.contenu AS contenu_5, c0_.resume AS resume_6, c0_.created AS created_7, c0_.modified AS modified_8, c0_.publied AS publied_9, c0_.language AS language_10, c0_.image_id AS image_id_11, c0_.route_id AS route_id_12, c0_.seo_id AS seo_id_13, c0_.auteur_id AS auteur_id_14 FROM core_cms c0_ LEFT JOIN core_url c1_ ON c0_.route_id = c1_.id WHERE c1_.path = ? AND c1_.context_id = ?
Parameters:
[ "/" 6 ] |
|
0.26 ms (2.01%) |
1 |
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.nom AS nom_3, t0.label AS label_4, t0.valeur AS valeur_5, t0.context_id AS context_id_6, t0.property_entreprise_id AS property_entreprise_id_7 FROM core_config_parametre t0 WHERE t0.context_id = ?
Parameters:
[
6
]
|
|
0.23 ms (1.73%) |
1 |
SELECT t0.id AS id_1, t0.host AS host_2, t0.name AS name_3, t0.created AS created_4 FROM core_config_context t0 WHERE t0.host = ? LIMIT 1
Parameters:
[
"alturgences.com"
]
|
|
0.22 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.statut AS statut_3, t0.titre AS titre_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.resume AS resume_7, t0.created AS created_8, t0.modified AS modified_9, t0.publied AS publied_10, t0.language AS language_11, t0.image_id AS image_id_12, t0.route_id AS route_id_13, t0.seo_id AS seo_id_14, t0.auteur_id AS auteur_id_15 FROM core_cms t0 WHERE t0.statut = ?
Parameters:
[
202
]
|
|
0.18 ms (1.37%) |
1 |
SELECT COUNT(*) FROM core_config_context t0
Parameters:
[] |
|
0.07 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.skey AS skey_2 FROM core_user_permissions t0
Parameters:
[] |
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 |
|---|---|
| Wee\CoreBundle\Entity\Cms\Cms | 86 |
| Wee\CoreBundle\Entity\Config\Route | 86 |
| Wee\CoreBundle\Entity\Cms\Seo | 86 |
| Wee\CoreBundle\Entity\User\Permission | 17 |
| Wee\CoreBundle\Entity\Config\Context | 1 |
| Wee\CoreBundle\Entity\Config\Parametre | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Wee\CoreBundle\Entity\Cms\Cms | No errors. |
| Wee\CoreBundle\Entity\Config\Context | No errors. |
| Wee\CoreBundle\Entity\Config\Parametre | No errors. |
| Wee\CoreBundle\Entity\User\Entreprise | No errors. |
| Wee\CoreBundle\Entity\Config\Route | No errors. |
| Wee\CoreBundle\Entity\Cms\File | No errors. |
| Wee\CoreBundle\Entity\Cms\Seo | No errors. |
| Wee\CoreBundle\Entity\User\User | No errors. |
| Wee\CoreBundle\Entity\Category | No errors. |
| Wee\CoreBundle\Entity\Cms\Bloc | No errors. |
| Wee\CoreBundle\Entity\Cms\Commentaire | No errors. |
| Wee\CoreBundle\Entity\Cms\Tag | No errors. |
| Wee\CoreBundle\Entity\User\Groupe | No errors. |
| Wee\CoreBundle\Entity\User\Permission | No errors. |