Query Metrics
5
Database Queries
5
Different statements
1.99 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.06 ms (53.38%) |
1 |
SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = ?) LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = ? AND ((k0_.hidden_from_nav <> 1 OR k0_.internal_name IS NOT NULL)) ORDER BY k1_.weight ASC, k1_.title ASC
Parameters:
[ "fr" 0 ] |
0.33 ms (16.63%) |
1 |
SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain
Parameters:
[] |
0.30 ms (14.87%) |
1 |
SELECT t0.id AS id_1, t0.titreoffre AS titreoffre_2, t0.texte AS texte_3, t0.datedebut AS datedebut_4, t0.datefin AS datefin_5, t0.datecreation AS datecreation_6, t0.dateupdate AS dateupdate_7, t0.validee AS validee_8, t0.active AS active_9, t0.datevalidation AS datevalidation_10, t0.categoriesoffres_id AS categoriesoffres_id_11, t0.annonceurs_id AS annonceurs_id_12 FROM offresemploi t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
0.18 ms (9.04%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.organisme AS organisme_3, t0.telephone AS telephone_4, t0.adresse AS adresse_5, t0.logo AS logo_6 FROM annonceurs t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.12 ms (6.07%) |
1 |
SELECT DATABASE()
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.
Entities Mapping
Class | Mapping errors |
---|---|
Kunstmaan\RedirectBundle\Entity\Redirect | No errors. |
Kunstmaan\TranslatorBundle\Entity\Translation | No errors. |
Acme\OffresBundle\Entity\OffresEmploi | No errors. |
Acme\OffresBundle\Entity\CategoriesOffres | No errors. |
Acme\OffresBundle\Entity\Annonceurs | No errors. |
Kunstmaan\MediaBundle\Entity\Folder | No errors. |
Kunstmaan\PagePartBundle\Entity\PageTemplateConfiguration | No errors. |
Kunstmaan\MenuBundle\Entity\BaseMenuItem | No errors. |
Kunstmaan\MenuBundle\Entity\MenuItem | No errors. |
Kunstmaan\NodeBundle\Entity\Node | No errors. |
Kunstmaan\NodeBundle\Entity\NodeTranslation | No errors. |
Kunstmaan\NodeBundle\Entity\NodeVersion | No errors. |