GET https://www.monkeydevwork.co.uk/blog/tag/startup-programs?page=1

Query Metrics

19 Database Queries
15 Different statements
12.27 ms Query time
0 Invalid entities
57 Managed entities
40 Cache hits
2 Cache misses
2 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 0.65 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/startup-programs"
  "en"
  1
]
2 0.97 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:
[
  1020303
]
3 1.14 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:
[
  1020303
]
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/1020303"
  1
  1
]
5 0.99 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:
[
  1020303
]
6 0.88 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:
[
  42
]
7 0.33 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:
[
  42
]
8 0.86 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:
[
  42
]
9 1.46 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:
[
  42
  1
]
10 0.62 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:
[
  42
  1
  81
  62
]
11 0.30 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:
[
  81
]
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:
[
  62
]
13 0.56 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:
[
  42
  1
]
14 0.73 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:
[
  81
]
15 0.33 ms
SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 WHERE t0.id = ?
Parameters:
[
  238214
]
16 0.44 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.locale_code = ? AND t0.active = ? AND t0.primary_path = ? LIMIT 1
Parameters:
[
  "node/1020233"
  "en"
  1
  1
]
17 0.61 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:
[
  62
]
18 0.27 ms
SELECT t0.file_name AS file_name_1, t0.file_uri AS file_uri_2, t0.file_mime AS file_mime_3, t0.file_size AS file_size_4, t0.status AS status_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.active AS active_8, t0.locale_code AS locale_code_9 FROM managed_file t0 WHERE t0.id = ?
Parameters:
[
  238119
]
19 0.41 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.locale_code = ? AND t0.active = ? AND t0.primary_path = ? LIMIT 1
Parameters:
[
  "node/1020214"
  "en"
  1
  1
]

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
2 Misses
2 Puts

Number of cache hits

Region Hits
core_write_rare 31
core_append_only 9

Number of cache misses

Region Misses
content_write_rare 2

Number of cache puts

Region Puts
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\PathAlias 3
App\Entity\Node 3
App\Entity\Article 2
App\Entity\ArticleTaxonomy 2
App\Entity\SiteBanner 1
App\Entity\ArticleTag 1
App\Entity\Author 1

Entities Mapping

Class Mapping errors
App\Entity\Channel No errors.
App\Entity\Locale No errors.
App\Entity\Currency No errors.
App\Entity\BankDetails No errors.
App\Entity\SiteBanner No errors.
App\Entity\Product No errors.
App\Entity\Feedback No errors.
App\Entity\PaymentMethod No errors.
App\Entity\Voucher No errors.
App\Entity\SearchHistoryItem No errors.
App\Entity\DeliveryOption No errors.
App\Entity\TrendingSearch No errors.
App\Entity\PathAlias No errors.
App\Entity\Node No errors.
App\Entity\ArticleTagNode No errors.
App\Entity\CoreNode No errors.
App\Entity\PageNode No errors.
App\Entity\SeriesNode No errors.
App\Entity\SeriesssdNode No errors.
App\Entity\ModelNode No errors.
App\Entity\ModelssdNode No errors.
App\Entity\ComponentPageNode No errors.
App\Entity\ProductNode No errors.
App\Entity\FilterPageNode No errors.
App\Entity\ArticleNode No errors.
App\Entity\ArticleTaxonomyNode No errors.
App\Entity\GenericNode No errors.
App\Entity\HelpTopicNode No errors.
App\Entity\HelpArticleNode No errors.
App\Entity\ModelCategoryNode No errors.
App\Entity\ModelCategoryssdNode No errors.
App\Entity\ModelCategoryBrandNode No errors.
App\Entity\ModelCategoryBrandssdNode No errors.
App\Entity\OemPartPageNode No errors.
App\Entity\OemBrandNode No errors.
App\Entity\OemModelNode No errors.
App\Entity\OemCategoryNode No errors.
App\Entity\OemBrandCategoryNode No errors.
App\Entity\Page No errors.
App\Entity\Series No errors.
App\Entity\HelpTopic No errors.
App\Entity\Model No errors.
App\Entity\ComponentPage No errors.
App\Entity\FilterPage No errors.
App\Entity\Article No errors.
App\Entity\ArticleTaxonomy No errors.
App\Entity\ArticleTag No errors.
App\Entity\HelpArticle No errors.
App\Entity\ModelCategory No errors.
App\Entity\ModelCategoryBrand No errors.
App\Entity\OemPart No errors.
App\Entity\OemBrand No errors.
App\Entity\OemCategory No errors.
App\Entity\OemBrandCategory No errors.
App\Entity\Translation\ArticleTagNodeTranslation No errors.
App\Entity\Translation\ArticleTagTranslation No errors.
App\Entity\Author No errors.
App\Entity\Translation\ArticleNodeTranslation No errors.
App\Entity\Translation\ArticleTranslation No errors.
App\Entity\ManagedFile No errors.
App\Entity\ManagedFileUsage No errors.