Query Metrics
15
Database Queries
13
Different statements
7.54 ms
Query time
0
Invalid entities
56
Managed entities
42
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.64 ms |
SELECT t0.path AS path_1, t0.alias AS alias_2, t0.primary_path AS primary_path_3, t0.type AS type_4, t0.method AS method_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM path_alias t0 WHERE t0.path = ? AND t0.locale_code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "/blog/tag/gaming-performance" "en" 1 ] |
2 | 0.94 ms |
SELECT n0_.id AS id_0 FROM node n0_ LEFT JOIN core_node c1_ ON n0_.id = c1_.id LEFT JOIN page_node p2_ ON n0_.id = p2_.id LEFT JOIN series_node s3_ ON n0_.id = s3_.id LEFT JOIN seriesssd_node s4_ ON n0_.id = s4_.id LEFT JOIN model_node m5_ ON n0_.id = m5_.id LEFT JOIN modelssd_node m6_ ON n0_.id = m6_.id LEFT JOIN component_page_node c7_ ON n0_.id = c7_.id LEFT JOIN product_node p8_ ON n0_.id = p8_.id LEFT JOIN filter_page_node f9_ ON n0_.id = f9_.id LEFT JOIN article_node a10_ ON n0_.id = a10_.id LEFT JOIN article_taxonomy_node a11_ ON n0_.id = a11_.id LEFT JOIN article_tag_node a12_ ON n0_.id = a12_.id LEFT JOIN generic_node g13_ ON n0_.id = g13_.id LEFT JOIN help_topic_node h14_ ON n0_.id = h14_.id LEFT JOIN help_article_node h15_ ON n0_.id = h15_.id LEFT JOIN model_category_node m16_ ON n0_.id = m16_.id LEFT JOIN model_categoryssd_node m17_ ON n0_.id = m17_.id LEFT JOIN model_category_brand_node m18_ ON n0_.id = m18_.id LEFT JOIN model_category_brandssd_node m19_ ON n0_.id = m19_.id LEFT JOIN oem_part_page_node o20_ ON n0_.id = o20_.id LEFT JOIN oem_brand_node o21_ ON n0_.id = o21_.id LEFT JOIN oem_model_node o22_ ON n0_.id = o22_.id LEFT JOIN oem_category_node o23_ ON n0_.id = o23_.id LEFT JOIN oem_brand_category_node o24_ ON n0_.id = o24_.id WHERE n0_.id = ?
Parameters:
[
1020394
]
|
3 | 1.23 ms |
SELECT t0.node_type AS node_type_25, t0.system_managed AS system_managed_26, t0.id AS id_27, t0.uuid AS uuid_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.handle AS handle_31, t0.discr, t1.controller AS controller_32, t1.action AS action_33, t2.page_entity_id AS page_entity_id_34, t3.series_entity_id AS series_entity_id_35, t3.help_topic_id AS help_topic_id_36, t4.series_entity_id AS series_entity_id_37, t4.help_topic_id AS help_topic_id_38, t5.model_entity_id AS model_entity_id_39, t6.model_entity_id AS model_entity_id_40, t7.component_page_entity_id AS component_page_entity_id_41, t7.help_topic_id AS help_topic_id_42, t8.product_entity_id AS product_entity_id_43, t8.help_topic_id AS help_topic_id_44, t9.filter_page_entity_id AS filter_page_entity_id_45, t10.article_entity_id AS article_entity_id_46, t11.article_taxonomy_entity_id AS article_taxonomy_entity_id_47, t12.article_tag_entity_id AS article_tag_entity_id_48, t13.settings AS settings_49, t13.symfony_route_name AS symfony_route_name_50, t14.help_topic_entity_id AS help_topic_entity_id_51, t15.help_article_entity_id AS help_article_entity_id_52, t16.model_category_entity_id AS model_category_entity_id_53, t16.help_topic_id AS help_topic_id_54, t17.model_category_entity_id AS model_category_entity_id_55, t17.help_topic_id AS help_topic_id_56, t18.model_category_brand_entity_id AS model_category_brand_entity_id_57, t18.help_topic_id AS help_topic_id_58, t19.model_category_brand_entity_id AS model_category_brand_entity_id_59, t19.help_topic_id AS help_topic_id_60, t20.oem_part_entity_id AS oem_part_entity_id_61, t20.help_topic_id AS help_topic_id_62, t21.oem_brand_entity_id AS oem_brand_entity_id_63, t21.help_topic_id AS help_topic_id_64, t22.model_entity_id AS model_entity_id_65, t22.help_topic_id AS help_topic_id_66, t23.oem_category_entity_id AS oem_category_entity_id_67, t23.help_topic_id AS help_topic_id_68, t24.oem_brand_category_entity_id AS oem_brand_category_entity_id_69, t24.help_topic_id AS help_topic_id_70 FROM node t0 LEFT JOIN core_node t1 ON t0.id = t1.id LEFT JOIN page_node t2 ON t0.id = t2.id LEFT JOIN series_node t3 ON t0.id = t3.id LEFT JOIN seriesssd_node t4 ON t0.id = t4.id LEFT JOIN model_node t5 ON t0.id = t5.id LEFT JOIN modelssd_node t6 ON t0.id = t6.id LEFT JOIN component_page_node t7 ON t0.id = t7.id LEFT JOIN product_node t8 ON t0.id = t8.id LEFT JOIN filter_page_node t9 ON t0.id = t9.id LEFT JOIN article_node t10 ON t0.id = t10.id LEFT JOIN article_taxonomy_node t11 ON t0.id = t11.id LEFT JOIN article_tag_node t12 ON t0.id = t12.id LEFT JOIN generic_node t13 ON t0.id = t13.id LEFT JOIN help_topic_node t14 ON t0.id = t14.id LEFT JOIN help_article_node t15 ON t0.id = t15.id LEFT JOIN model_category_node t16 ON t0.id = t16.id LEFT JOIN model_categoryssd_node t17 ON t0.id = t17.id LEFT JOIN model_category_brand_node t18 ON t0.id = t18.id LEFT JOIN model_category_brandssd_node t19 ON t0.id = t19.id LEFT JOIN oem_part_page_node t20 ON t0.id = t20.id LEFT JOIN oem_brand_node t21 ON t0.id = t21.id LEFT JOIN oem_model_node t22 ON t0.id = t22.id LEFT JOIN oem_category_node t23 ON t0.id = t23.id LEFT JOIN oem_brand_category_node t24 ON t0.id = t24.id WHERE t0.id = ? LIMIT 1
Parameters:
[
1020394
]
|
4 | 0.45 ms |
SELECT t0.path AS path_1, t0.alias AS alias_2, t0.primary_path AS primary_path_3, t0.type AS type_4, t0.method AS method_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM path_alias t0 WHERE t0.alias = ? AND t0.primary_path = ? AND t0.active = ?
Parameters:
[ "node/1020394" 1 1 ] |
5 | 0.29 ms |
SELECT t0.id AS id_1, t0.page_title AS page_title_2, t0.page_description AS page_description_3, t0.allow_robots_index AS allow_robots_index_4, t0.allow_robots_follow AS allow_robots_follow_5, t0.additional_meta_tags AS additional_meta_tags_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM article_tag_node_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1020394
]
|
6 | 0.22 ms |
SELECT t0.tag AS tag_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.active AS active_5, t0.allow_node_generation AS allow_node_generation_6 FROM article_tag t0 WHERE t0.id = ?
Parameters:
[
133
]
|
7 | 0.26 ms |
SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_tag_entity_id AS article_tag_entity_id_9, t1.discr FROM article_tag_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_tag_entity_id = ?
Parameters:
[
133
]
|
8 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM article_tag_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
133
]
|
9 | 0.72 ms |
SELECT DISTINCT id_1 FROM (SELECT DISTINCT id_1, created_at_3 FROM (SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6 FROM article a0_ LEFT JOIN article_article_tag a2_ ON a0_.id = a2_.article_id LEFT JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE EXISTS (SELECT 1 FROM article_article_tag a3_ WHERE a3_.article_id = a0_.id AND a3_.article_tag_id IN (?)) AND a0_.active = ?) dctrn_result_inner ORDER BY created_at_3 DESC) dctrn_result LIMIT 10
Parameters:
[ 133 1 ] |
10 | 0.58 ms |
SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6, a0_.main_taxonomy_id AS main_taxonomy_id_7, a0_.author_id AS author_id_8 FROM article a0_ LEFT JOIN article_article_tag a2_ ON a0_.id = a2_.article_id LEFT JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE EXISTS (SELECT 1 FROM article_article_tag a3_ WHERE a3_.article_id = a0_.id AND a3_.article_tag_id IN (?)) AND a0_.active = ? AND a0_.id IN (?, ?) ORDER BY a0_.created_at DESC
Parameters:
[ 133 1 100 74 ] |
11 | 0.28 ms |
SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ?
Parameters:
[
100
]
|
12 | 0.28 ms |
SELECT t1.node_type AS node_type_2, t1.system_managed AS system_managed_3, t1.id AS id_4, t1.uuid AS uuid_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.handle AS handle_8, t0.article_entity_id AS article_entity_id_9, t1.discr FROM article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.article_entity_id = ?
Parameters:
[
74
]
|
13 | 0.57 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT a0_.popular AS popular_0, a0_.id AS id_1, a0_.uuid AS uuid_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.active AS active_5, a0_.allow_node_generation AS allow_node_generation_6 FROM article a0_ LEFT JOIN article_article_tag a2_ ON a0_.id = a2_.article_id LEFT JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE EXISTS (SELECT 1 FROM article_article_tag a3_ WHERE a3_.article_id = a0_.id AND a3_.article_tag_id IN (?)) AND a0_.active = ? ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[ 133 1 ] |
14 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
100
]
|
15 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main_title AS main_title_3, t0.description AS description_4, t0.content AS content_5, t0.locale AS locale_6, t0.featured_image_id AS featured_image_id_7, t0.translatable_id AS translatable_id_8 FROM article_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
74
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
old_global_db | doctrine.dbal.old_global_db_connection |
old_latestimport_db | doctrine.dbal.old_latestimport_db_connection |
locale_uk | doctrine.dbal.locale_uk_connection |
locale_de | doctrine.dbal.locale_de_connection |
locale_es | doctrine.dbal.locale_es_connection |
locale_fr | doctrine.dbal.locale_fr_connection |
locale_it | doctrine.dbal.locale_it_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
42
Hits
0
Misses
0
Puts
Number of cache hits
Region | Hits |
---|---|
core_write_rare | 31 |
core_append_only | 9 |
content_write_rare | 2 |
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Translation\ArticleTranslation | 10 |
App\Entity\ManagedFile | 10 |
App\Entity\Locale | 6 |
App\Entity\BankDetails | 5 |
App\Entity\Channel | 5 |
App\Entity\Translation\ArticleTagTranslation | 5 |
App\Entity\Currency | 3 |
App\Entity\Node | 3 |
App\Entity\Article | 2 |
App\Entity\ArticleTaxonomy | 2 |
App\Entity\Author | 2 |
App\Entity\SiteBanner | 1 |
App\Entity\PathAlias | 1 |
App\Entity\ArticleTag | 1 |