Query Metrics
23
Database Queries
11
Different statements
6.20 ms
Query time
0
Invalid entities
57
Managed entities
40
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.49 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:
[ "/help-and-faqs/dram-faq/how-to-check-your-computer-specs" "en" 1 ] |
2 | 0.67 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:
[
537076
]
|
3 | 0.88 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:
[
537076
]
|
4 | 0.40 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/537076" 1 1 ] |
5 | 0.25 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.page_title AS page_title_3, t0.page_description AS page_description_4, t0.allow_robots_index AS allow_robots_index_5, t0.allow_robots_follow AS allow_robots_follow_6, t0.additional_meta_tags AS additional_meta_tags_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM help_article_node_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
537076
]
|
6 | 0.27 ms |
SELECT t0.popular AS popular_1, t0.icon AS icon_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.materialized_path AS materialized_path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.handle AS handle_8, t0.active AS active_9, t0.allow_node_generation AS allow_node_generation_10, t0.legacy_id AS legacy_id_11, t0.legacy_data AS legacy_data_12 FROM help_topic t0 WHERE t0.active = ?
Parameters:
[
1
]
|
7 | 0.24 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
1
]
|
8 | 0.21 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
2
]
|
9 | 0.18 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
3
]
|
10 | 0.18 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
4
]
|
11 | 0.18 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
5
]
|
12 | 0.17 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
6
]
|
13 | 0.18 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
7
]
|
14 | 0.17 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
8
]
|
15 | 0.17 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
9
]
|
16 | 0.18 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
10
]
|
17 | 0.17 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
11
]
|
18 | 0.17 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
12
]
|
19 | 0.17 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.help_topic_entity_id AS help_topic_entity_id_9, t1.discr FROM help_topic_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_topic_entity_id = ?
Parameters:
[
13
]
|
20 | 0.19 ms |
SELECT t0.popular AS popular_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.handle AS handle_6, t0.active AS active_7, t0.allow_node_generation AS allow_node_generation_8, t0.legacy_id AS legacy_id_9, t0.legacy_data AS legacy_data_10, t0.help_topic_id AS help_topic_id_11 FROM help_article t0 WHERE t0.id = ?
Parameters:
[
9
]
|
21 | 0.19 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.help_article_entity_id AS help_article_entity_id_9, t1.discr FROM help_article_node t0 INNER JOIN node t1 ON t0.id = t1.id WHERE t0.help_article_entity_id = ?
Parameters:
[
9
]
|
22 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.main_title AS main_title_4, t0.content AS content_5, t0.locale AS locale_6, t0.banner_image_id AS banner_image_id_7, t0.featured_image_id AS featured_image_id_8, t0.translatable_id AS translatable_id_9 FROM help_article_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
9
]
|
23 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.content AS content_4, t0.main_title AS main_title_5, t0.locale AS locale_6, t0.banner_image_id AS banner_image_id_7, t0.featured_image_id AS featured_image_id_8, t0.translatable_id AS translatable_id_9 FROM help_topic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
10
]
|
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
40
Hits
0
Misses
0
Puts
Number of cache hits
Region | Hits |
---|---|
core_write_rare | 31 |
core_append_only | 9 |
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Node | 14 |
App\Entity\HelpTopic | 13 |
App\Entity\Locale | 6 |
App\Entity\BankDetails | 5 |
App\Entity\Channel | 5 |
App\Entity\PathAlias | 5 |
App\Entity\Currency | 3 |
App\Entity\ManagedFile | 2 |
App\Entity\SiteBanner | 1 |
App\Entity\HelpArticle | 1 |
App\Entity\Translation\HelpArticleTranslation | 1 |
App\Entity\Translation\HelpTopicTranslation | 1 |