Query Metrics
5
Database Queries
5
Different statements
2.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.94 ms (45.62%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.search_terms AS search_terms_5, t0.text AS text_6, t0.text_female AS text_female_7, t0.text_male AS text_male_8, t0.highlighted AS highlighted_9, t0.main_page_fragrance AS main_page_fragrance_10, t0.highlighted_in_search AS highlighted_in_search_11, t0.is_on_main_page AS is_on_main_page_12, t0.special AS special_13, t0.special_name AS special_name_14, t0.slogan AS slogan_15, t0.`lead` AS lead_16, t0.active AS active_17, t0.exclude_from_arukereso AS exclude_from_arukereso_18, t0.image_id AS image_id_19 FROM brand t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"cookie"
]
|
|
0.53 ms (25.64%) |
1 |
SELECT h0_.id AS id_0, h0_.lft AS lft_1, h0_.lvl AS lvl_2, h0_.rgt AS rgt_3, h0_.deleted AS deleted_4, h0_.hidden_from_nav AS hidden_from_nav_5, h0_.ref_entity_name AS ref_entity_name_6, h0_.internal_name AS internal_name_7, h1_.id AS id_8, h1_.lang AS lang_9, h1_.online AS online_10, h1_.title AS title_11, h1_.slug AS slug_12, h1_.url AS url_13, h1_.weight AS weight_14, h1_.created AS created_15, h1_.updated AS updated_16, h2_.id AS id_17, h2_.type AS type_18, h2_.owner AS owner_19, h2_.created AS created_20, h2_.updated AS updated_21, h2_.ref_id AS ref_id_22, h2_.ref_entity_name AS ref_entity_name_23, h0_.parent_id AS parent_id_24, h1_.node_id AS node_id_25, h1_.public_node_version_id AS public_node_version_id_26, h2_.node_translation_id AS node_translation_id_27, h2_.origin_id AS origin_id_28 FROM hg_node_nodes h0_ INNER JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id AND (h1_.public_node_version_id = h2_.id) WHERE h0_.deleted = 0 AND h0_.internal_name = ? AND h1_.lang = ? AND h1_.online = 1 ORDER BY h1_.weight ASC, h1_.title ASC
Parameters:
[ "homepage" "hu" ] |
|
0.21 ms (10.30%) |
1 |
SELECT DATABASE()
Parameters:
[] |
|
0.21 ms (10.16%) |
1 |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.origin AS origin_3, t0.target AS target_4, t0.permanent AS permanent_5 FROM hg_settings_redirect t0
Parameters:
[] |
|
0.17 ms (8.27%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_home_pages 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\FragranceSample | No errors. |
| App\Entity\GuaranteedPresent | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\FrequentlyAskedQuestion | No errors. |
| App\Entity\TopTen | No errors. |
| Hgabka\MediaBundle\Entity\Folder | No errors. |
| Hgabka\PagePartBundle\Entity\PageTemplateConfiguration | No errors. |
| Hgabka\SettingsBundle\Entity\Redirect | No errors. |
| App\Entity\Brand | No errors. |
| Hgabka\MediaBundle\Entity\Media | No errors. |
| Hgabka\NodeBundle\Entity\Node | No errors. |
| Hgabka\NodeBundle\Entity\NodeTranslation | No errors. |
| Hgabka\NodeBundle\Entity\NodeVersion | No errors. |
| App\Entity\Pages\HomePage | No errors. |