GET https://www.dnaklik.nl/en/specialisation/extension-cms-edit-preview

Query Metrics

27 Database Queries
16 Different statements
6.76 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.shortcode AS shortcode_4, t0.sequence AS sequence_5, t0.main AS main_6, t0.flag_icon_code AS flag_icon_code_7, t0.published_at AS published_at_8, t0.archived_at AS archived_at_9, t0.created AS created_10, t0.modified AS modified_11, t0.created_by_id AS created_by_id_12, t0.modified_by_id AS modified_by_id_13 FROM language t0 WHERE t0.main = ?
Parameters:
[
  1
]
2 0.57 ms
SELECT p0_.id AS id_0, t1_.content AS name_1, t2_.content AS slug_2, p0_.head_menu AS head_menu_3, t3_.content AS meta_title_4, t4_.content AS meta_description_5, t5_.content AS meta_keywords_6, p0_.sequence AS sequence_7, p0_.created AS created_8, p0_.modified AS modified_9, p0_.published_at AS published_at_10, p0_.archived_at AS archived_at_11, p0_.parent_page_id AS parent_page_id_12, p0_.created_by_id AS created_by_id_13, p0_.modified_by_id AS modified_by_id_14 FROM page p0_ LEFT JOIN page_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\Page' AND t1_.foreign_key = p0_.id LEFT JOIN page_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'slug' AND t2_.object_class = 'App\\Entity\\Page' AND t2_.foreign_key = p0_.id LEFT JOIN page_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'meta_title' AND t3_.object_class = 'App\\Entity\\Page' AND t3_.foreign_key = p0_.id LEFT JOIN page_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'meta_description' AND t4_.object_class = 'App\\Entity\\Page' AND t4_.foreign_key = p0_.id LEFT JOIN page_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'meta_keywords' AND t5_.object_class = 'App\\Entity\\Page' AND t5_.foreign_key = p0_.id WHERE t2_.content = ?
Parameters:
[
  "specialisation"
]
3 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.head_menu AS head_menu_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.sequence AS sequence_8, t0.created AS created_9, t0.modified AS modified_10, t0.published_at AS published_at_11, t0.archived_at AS archived_at_12, t0.parent_page_id AS parent_page_id_13, t0.created_by_id AS created_by_id_14, t0.modified_by_id AS modified_by_id_15 FROM page t0 WHERE t0.parent_page_id IN (?) ORDER BY t0.sequence ASC
Parameters:
[
  51
]
4 0.17 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.head_menu AS head_menu_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.sequence AS sequence_7, p0_.created AS created_8, p0_.modified AS modified_9, p0_.published_at AS published_at_10, p0_.archived_at AS archived_at_11 FROM page p0_ WHERE p0_.id = ?
Parameters:
[
  51
]
5 0.19 ms
SELECT p0_.content AS content_0, p0_.field AS field_1, p0_.locale AS locale_2 FROM page_translations p0_ WHERE p0_.foreign_key = ? AND p0_.object_class = ? ORDER BY p0_.locale ASC
Parameters:
[
  51
  "App\Entity\Page"
]
6 0.23 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.access AS access_3, t0.page_id AS page_id_4, t5.id AS id_6, t5.name AS name_7, t5.slug AS slug_8, t5.head_menu AS head_menu_9, t5.meta_title AS meta_title_10, t5.meta_description AS meta_description_11, t5.meta_keywords AS meta_keywords_12, t5.sequence AS sequence_13, t5.created AS created_14, t5.modified AS modified_15, t5.published_at AS published_at_16, t5.archived_at AS archived_at_17, t5.parent_page_id AS parent_page_id_18, t5.created_by_id AS created_by_id_19, t5.modified_by_id AS modified_by_id_20, t0.sjabloon_content_id AS sjabloon_content_id_21 FROM page_sjabloon_content t0 INNER JOIN page t5 ON t0.page_id = t5.id WHERE t0.page_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  51
]
7 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_url AS page_url_3, t0.created AS created_4, t0.modified AS modified_5, t0.sjabloon_id AS sjabloon_id_6, t7.id AS id_8, t7.name AS name_9, t7.uitleg AS uitleg_10, t7.code AS code_11, t7.sequence AS sequence_12, t7.access AS access_13, t7.created AS created_14, t7.modified AS modified_15, t7.modified_by_id AS modified_by_id_16, t7.created_by_id AS created_by_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM sjabloon_content t0 LEFT JOIN sjabloon t7 ON t0.sjabloon_id = t7.id WHERE t0.id = ?
Parameters:
[
  28
]
8 0.48 ms
SELECT t0.id AS id_1, t0.object_name AS object_name_2, t0.content_id AS content_id_3, t4.id AS id_5, t4.name AS name_6, t4.page_url AS page_url_7, t4.created AS created_8, t4.modified AS modified_9, t4.sjabloon_id AS sjabloon_id_10, t4.created_by_id AS created_by_id_11, t4.modified_by_id AS modified_by_id_12, t0.field_id AS field_id_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.name AS name_17, t15.sequence AS sequence_18, t15.sjabloon_field_value_collection_id AS sjabloon_field_value_collection_id_19, t20.id AS id_21, t20.html AS html_22, t20.value_id AS value_id_23, t24.id AS id_25, t24.string AS string_26, t24.value_id AS value_id_27, t28.id AS id_29, t28.image_file_name AS image_file_name_30, t28.value_id AS value_id_31, t32.id AS id_33, t32.file AS file_34, t32.value_id AS value_id_35, t36.id AS id_37, t36.text AS text_38, t36.value_id AS value_id_39, t40.id AS id_41, t40.number AS number_42, t40.value_id AS value_id_43, t44.id AS id_45, t44.sjabloon_content_id AS sjabloon_content_id_46, t44.value_id AS value_id_47, t48.id AS id_49, t48.module AS module_50, t48.method AS method_51, t48.value_id AS value_id_52, t53.id AS id_54, t53.name AS name_55, t53.value_id AS value_id_56 FROM sjabloon_content_value t0 LEFT JOIN sjabloon_content t4 ON t0.content_id = t4.id LEFT JOIN sjabloon_field_value_parent t15 ON t0.parent_id = t15.id LEFT JOIN sjabloon_field_value_tiny t20 ON t20.value_id = t0.id LEFT JOIN sjabloon_field_value_string t24 ON t24.value_id = t0.id LEFT JOIN sjabloon_field_value_image t28 ON t28.value_id = t0.id LEFT JOIN sjabloon_field_value_file t32 ON t32.value_id = t0.id LEFT JOIN sjabloon_field_value_text t36 ON t36.value_id = t0.id LEFT JOIN sjabloon_field_value_num t40 ON t40.value_id = t0.id LEFT JOIN sjabloon_field_value_sjabloon_content t44 ON t44.value_id = t0.id LEFT JOIN sjabloon_field_value_module t48 ON t48.value_id = t0.id LEFT JOIN sjabloon_field_value_collection t53 ON t53.value_id = t0.id WHERE t0.content_id = ?
Parameters:
[
  28
]
9 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.id = ?
Parameters:
[
  153
]
10 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.id = ?
Parameters:
[
  154
]
11 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.sjabloon_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  64
]
12 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.sjabloon_field_value_module_id AS sjabloon_field_value_module_id_4 FROM module_parameter t0 WHERE t0.sjabloon_field_value_module_id = ?
Parameters:
[
  6
]
13 0.50 ms
SELECT a0_.id AS id_0, t1_.content AS title_1, t2_.content AS url_name_2, a0_.img_teaser AS img_teaser_3, t3_.content AS teaser_4, t4_.content AS content_5, a0_.img_header AS img_header_6, a0_.sequence AS sequence_7, t5_.content AS meta_title_8, t6_.content AS meta_description_9, t7_.content AS meta_keywords_10, a0_.published_at AS published_at_11, a0_.archived_at AS archived_at_12, a0_.created AS created_13, a0_.modified AS modified_14, a0_.article_category_id AS article_category_id_15, a0_.created_by_id AS created_by_id_16, a0_.modified_by_id AS modified_by_id_17 FROM article a0_ LEFT JOIN article_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.object_class = 'App\\Entity\\Article' AND t1_.foreign_key = a0_.id LEFT JOIN article_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'urlName' AND t2_.object_class = 'App\\Entity\\Article' AND t2_.foreign_key = a0_.id LEFT JOIN article_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'teaser' AND t3_.object_class = 'App\\Entity\\Article' AND t3_.foreign_key = a0_.id LEFT JOIN article_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'content' AND t4_.object_class = 'App\\Entity\\Article' AND t4_.foreign_key = a0_.id LEFT JOIN article_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'meta_title' AND t5_.object_class = 'App\\Entity\\Article' AND t5_.foreign_key = a0_.id LEFT JOIN article_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'meta_description' AND t6_.object_class = 'App\\Entity\\Article' AND t6_.foreign_key = a0_.id LEFT JOIN article_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'meta_keywords' AND t7_.object_class = 'App\\Entity\\Article' AND t7_.foreign_key = a0_.id WHERE t2_.content = ?
Parameters:
[
  "extension-cms-edit-preview"
]
14 0.17 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url_name AS url_name_2, a0_.img_teaser AS img_teaser_3, a0_.teaser AS teaser_4, a0_.content AS content_5, a0_.img_header AS img_header_6, a0_.sequence AS sequence_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.meta_keywords AS meta_keywords_10, a0_.published_at AS published_at_11, a0_.archived_at AS archived_at_12, a0_.created AS created_13, a0_.modified AS modified_14 FROM article a0_ WHERE a0_.id = ?
Parameters:
[
  10
]
15 0.19 ms
SELECT a0_.content AS content_0, a0_.field AS field_1, a0_.locale AS locale_2 FROM article_translations a0_ WHERE a0_.foreign_key = ? AND a0_.object_class = ? ORDER BY a0_.locale ASC
Parameters:
[
  10
  "App\Entity\Article"
]
16 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.uitleg AS uitleg_3, t0.code AS code_4, t0.sequence AS sequence_5, t0.access AS access_6, t0.created AS created_7, t0.modified AS modified_8, t0.modified_by_id AS modified_by_id_9, t0.created_by_id AS created_by_id_10 FROM sjabloon t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Article Header Teaser"
]
17 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.sjabloon_id = ?
Parameters:
[
  65
]
18 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_url AS page_url_3, t0.created AS created_4, t0.modified AS modified_5, t0.sjabloon_id AS sjabloon_id_6, t7.id AS id_8, t7.name AS name_9, t7.uitleg AS uitleg_10, t7.code AS code_11, t7.sequence AS sequence_12, t7.access AS access_13, t7.created AS created_14, t7.modified AS modified_15, t7.modified_by_id AS modified_by_id_16, t7.created_by_id AS created_by_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM sjabloon_content t0 LEFT JOIN sjabloon t7 ON t0.sjabloon_id = t7.id WHERE t0.id = ?
Parameters:
[
  27
]
19 0.46 ms
SELECT t0.id AS id_1, t0.object_name AS object_name_2, t0.content_id AS content_id_3, t4.id AS id_5, t4.name AS name_6, t4.page_url AS page_url_7, t4.created AS created_8, t4.modified AS modified_9, t4.sjabloon_id AS sjabloon_id_10, t4.created_by_id AS created_by_id_11, t4.modified_by_id AS modified_by_id_12, t0.field_id AS field_id_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.name AS name_17, t15.sequence AS sequence_18, t15.sjabloon_field_value_collection_id AS sjabloon_field_value_collection_id_19, t20.id AS id_21, t20.html AS html_22, t20.value_id AS value_id_23, t24.id AS id_25, t24.string AS string_26, t24.value_id AS value_id_27, t28.id AS id_29, t28.image_file_name AS image_file_name_30, t28.value_id AS value_id_31, t32.id AS id_33, t32.file AS file_34, t32.value_id AS value_id_35, t36.id AS id_37, t36.text AS text_38, t36.value_id AS value_id_39, t40.id AS id_41, t40.number AS number_42, t40.value_id AS value_id_43, t44.id AS id_45, t44.sjabloon_content_id AS sjabloon_content_id_46, t44.value_id AS value_id_47, t48.id AS id_49, t48.module AS module_50, t48.method AS method_51, t48.value_id AS value_id_52, t53.id AS id_54, t53.name AS name_55, t53.value_id AS value_id_56 FROM sjabloon_content_value t0 LEFT JOIN sjabloon_content t4 ON t0.content_id = t4.id LEFT JOIN sjabloon_field_value_parent t15 ON t0.parent_id = t15.id LEFT JOIN sjabloon_field_value_tiny t20 ON t20.value_id = t0.id LEFT JOIN sjabloon_field_value_string t24 ON t24.value_id = t0.id LEFT JOIN sjabloon_field_value_image t28 ON t28.value_id = t0.id LEFT JOIN sjabloon_field_value_file t32 ON t32.value_id = t0.id LEFT JOIN sjabloon_field_value_text t36 ON t36.value_id = t0.id LEFT JOIN sjabloon_field_value_num t40 ON t40.value_id = t0.id LEFT JOIN sjabloon_field_value_sjabloon_content t44 ON t44.value_id = t0.id LEFT JOIN sjabloon_field_value_module t48 ON t48.value_id = t0.id LEFT JOIN sjabloon_field_value_collection t53 ON t53.value_id = t0.id WHERE t0.content_id = ?
Parameters:
[
  27
]
20 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.id = ?
Parameters:
[
  79
]
21 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.sjabloon_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  37
]
22 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.sjabloon_field_value_module_id AS sjabloon_field_value_module_id_4 FROM module_parameter t0 WHERE t0.sjabloon_field_value_module_id = ?
Parameters:
[
  5
]
23 0.46 ms
SELECT a0_.id AS id_0, t1_.content AS title_1, t2_.content AS url_name_2, a0_.img_teaser AS img_teaser_3, t3_.content AS teaser_4, t4_.content AS content_5, a0_.img_header AS img_header_6, a0_.sequence AS sequence_7, t5_.content AS meta_title_8, t6_.content AS meta_description_9, t7_.content AS meta_keywords_10, a0_.published_at AS published_at_11, a0_.archived_at AS archived_at_12, a0_.created AS created_13, a0_.modified AS modified_14, a0_.article_category_id AS article_category_id_15, a0_.created_by_id AS created_by_id_16, a0_.modified_by_id AS modified_by_id_17 FROM article a0_ LEFT JOIN article_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.object_class = 'App\\Entity\\Article' AND t1_.foreign_key = a0_.id LEFT JOIN article_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'urlName' AND t2_.object_class = 'App\\Entity\\Article' AND t2_.foreign_key = a0_.id LEFT JOIN article_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'teaser' AND t3_.object_class = 'App\\Entity\\Article' AND t3_.foreign_key = a0_.id LEFT JOIN article_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'content' AND t4_.object_class = 'App\\Entity\\Article' AND t4_.foreign_key = a0_.id LEFT JOIN article_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'meta_title' AND t5_.object_class = 'App\\Entity\\Article' AND t5_.foreign_key = a0_.id LEFT JOIN article_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'meta_description' AND t6_.object_class = 'App\\Entity\\Article' AND t6_.foreign_key = a0_.id LEFT JOIN article_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'meta_keywords' AND t7_.object_class = 'App\\Entity\\Article' AND t7_.foreign_key = a0_.id WHERE t2_.content = ?
Parameters:
[
  "extension-cms-edit-preview"
]
24 0.16 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url_name AS url_name_2, a0_.img_teaser AS img_teaser_3, a0_.teaser AS teaser_4, a0_.content AS content_5, a0_.img_header AS img_header_6, a0_.sequence AS sequence_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.meta_keywords AS meta_keywords_10, a0_.published_at AS published_at_11, a0_.archived_at AS archived_at_12, a0_.created AS created_13, a0_.modified AS modified_14 FROM article a0_ WHERE a0_.id = ?
Parameters:
[
  10
]
25 0.19 ms
SELECT a0_.content AS content_0, a0_.field AS field_1, a0_.locale AS locale_2 FROM article_translations a0_ WHERE a0_.foreign_key = ? AND a0_.object_class = ? ORDER BY a0_.locale ASC
Parameters:
[
  10
  "App\Entity\Article"
]
26 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.uitleg AS uitleg_3, t0.code AS code_4, t0.sequence AS sequence_5, t0.access AS access_6, t0.created AS created_7, t0.modified AS modified_8, t0.modified_by_id AS modified_by_id_9, t0.created_by_id AS created_by_id_10 FROM sjabloon t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "SpecialisatieDetail"
]
27 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.sjabloon_id = ?
Parameters:
[
  63
]

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.