Query Metrics
91
Database Queries
30
Different statements
20.61 ms
Query time
0
Invalid entities
179
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.34 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.slug = ? LIMIT 1
Parameters:
[
"home"
]
|
| 2 | 0.23 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:
[
1
]
|
| 3 | 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:
[
1
]
|
| 4 | 0.21 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
]
|
| 5 | 0.20 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:
[ 1 "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:
[
1
]
|
| 7 | 0.22 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:
[
101
]
|
| 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:
[
101
]
|
| 9 | 0.22 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:
[
53
]
|
| 10 | 0.19 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:
[
115
]
|
| 11 | 0.38 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:
[
115
]
|
| 12 | 0.22 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:
[
102
]
|
| 13 | 0.18 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 = ? LIMIT 1
Parameters:
[
103
]
|
| 14 | 0.35 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:
[
103
]
|
| 15 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_field_value_collection_id AS sjabloon_field_value_collection_id_4, t5.id AS id_6, t5.name AS name_7, t5.value_id AS value_id_8 FROM sjabloon_field_value_parent t0 LEFT JOIN sjabloon_field_value_collection t5 ON t0.sjabloon_field_value_collection_id = t5.id WHERE t0.sjabloon_field_value_collection_id = ? ORDER BY t0.sequence ASC
Parameters:
[
2
]
|
| 16 | 0.36 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.parent_id = ?
Parameters:
[
2
]
|
| 17 | 0.36 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.parent_id = ?
Parameters:
[
3
]
|
| 18 | 0.39 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.parent_id = ?
Parameters:
[
4
]
|
| 19 | 0.35 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.parent_id = ?
Parameters:
[
5
]
|
| 20 | 0.35 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.parent_id = ?
Parameters:
[
6
]
|
| 21 | 0.35 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.parent_id = ?
Parameters:
[
7
]
|
| 22 | 0.38 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.parent_id = ?
Parameters:
[
8
]
|
| 23 | 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:
[
230
]
|
| 24 | 0.21 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:
[
92
]
|
| 25 | 0.18 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 = ? LIMIT 1
Parameters:
[
114
]
|
| 26 | 0.43 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:
[
114
]
|
| 27 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_field_value_collection_id AS sjabloon_field_value_collection_id_4, t5.id AS id_6, t5.name AS name_7, t5.value_id AS value_id_8 FROM sjabloon_field_value_parent t0 LEFT JOIN sjabloon_field_value_collection t5 ON t0.sjabloon_field_value_collection_id = t5.id WHERE t0.sjabloon_field_value_collection_id = ? ORDER BY t0.sequence ASC
Parameters:
[
5
]
|
| 28 | 0.37 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.parent_id = ?
Parameters:
[
12
]
|
| 29 | 0.38 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.parent_id = ?
Parameters:
[
11
]
|
| 30 | 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:
[
253
]
|
| 31 | 0.24 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:
[
101
]
|
| 32 | 0.18 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 = ? LIMIT 1
Parameters:
[
108
]
|
| 33 | 0.34 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:
[
108
]
|
| 34 | 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 = ? ORDER BY t0.sequence ASC
Parameters:
[
37
]
|
| 35 | 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:
[
21
]
|
| 36 | 0.18 ms |
SELECT t0.id AS id_1, t0.recensie AS recensie_2, t0.show_name AS show_name_3, t0.show_avatar AS show_avatar_4, t0.created AS created_5, t0.modified AS modified_6, t0.published_at AS published_at_7, t0.archived_at AS archived_at_8, t0.player_id AS player_id_9, t0.created_by_id AS created_by_id_10, t0.modified_by_id AS modified_by_id_11 FROM pool_recensie t0
Parameters:
[] |
| 37 | 0.19 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:
[
"Recensies"
]
|
| 38 | 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 = ?
Parameters:
[
98
]
|
| 39 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.initials AS initials_3, t0.birth_date AS birth_date_4, t0.gender AS gender_5, t0.telephone AS telephone_6, t0.single AS single_7, t0.dubbel AS dubbel_8, t0.email AS email_9, t0.avatar AS avatar_10, t0.created AS created_11, t0.modified AS modified_12, t0.published_at AS published_at_13, t0.archived_at AS archived_at_14, t0.player_user_id AS player_user_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM pool_player t0 WHERE t0.id = ?
Parameters:
[
86
]
|
| 40 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
86
]
|
| 41 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.initials AS initials_3, t0.birth_date AS birth_date_4, t0.gender AS gender_5, t0.telephone AS telephone_6, t0.single AS single_7, t0.dubbel AS dubbel_8, t0.email AS email_9, t0.avatar AS avatar_10, t0.created AS created_11, t0.modified AS modified_12, t0.published_at AS published_at_13, t0.archived_at AS archived_at_14, t0.player_user_id AS player_user_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM pool_player t0 INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_player_id WHERE pool_player_pool_poule.pool_poule_id = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 42 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
26
]
|
| 43 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.set_points AS set_points_3, t0.single AS single_4, t0.dubbel AS dubbel_5 FROM pool_sport t0 INNER JOIN pool_club_pool_sport ON t0.id = pool_club_pool_sport.pool_sport_id WHERE pool_club_pool_sport.pool_club_id = ?
Parameters:
[
1
]
|
| 44 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id WHERE t0.club_id IN (?)
Parameters:
[
1
]
|
| 45 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.mobile AS mobile_4, t0.gender AS gender_5, t0.created AS created_6, t0.added_to_players AS added_to_players_7, t0.club_id AS club_id_8 FROM player_subscription t0 WHERE t0.club_id IN (?)
Parameters:
[
1
]
|
| 46 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
6
]
|
| 47 | 0.20 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
26
]
|
| 48 | 0.16 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
26
]
|
| 49 | 0.17 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
26
]
|
| 50 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
44
]
|
| 51 | 0.21 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
6
]
|
| 52 | 0.14 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
6
]
|
| 53 | 0.13 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
6
]
|
| 54 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
7
]
|
| 55 | 0.20 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
44
]
|
| 56 | 0.14 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
44
]
|
| 57 | 0.13 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
44
]
|
| 58 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
84
]
|
| 59 | 0.20 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
7
]
|
| 60 | 0.14 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
7
]
|
| 61 | 0.15 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
7
]
|
| 62 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
41
]
|
| 63 | 0.20 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
84
]
|
| 64 | 0.15 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
84
]
|
| 65 | 0.13 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
84
]
|
| 66 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
16
]
|
| 67 | 0.19 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
41
]
|
| 68 | 0.13 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
41
]
|
| 69 | 0.13 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
41
]
|
| 70 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
21
]
|
| 71 | 0.19 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
16
]
|
| 72 | 0.15 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
16
]
|
| 73 | 0.15 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
16
]
|
| 74 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.type_pool AS type_pool_4, t0.gender AS gender_5, t0.type_game AS type_game_6, t0.add_game AS add_game_7, t0.contact_person AS contact_person_8, t0.contact_email AS contact_email_9, t0.mixed_correction AS mixed_correction_10, t0.start_date AS start_date_11, t0.created AS created_12, t0.modified AS modified_13, t0.published_at AS published_at_14, t0.archived_at AS archived_at_15, t0.sport_id AS sport_id_16, t17.id AS id_18, t17.name AS name_19, t17.set_points AS set_points_20, t17.single AS single_21, t17.dubbel AS dubbel_22, t0.captain_id AS captain_id_23, t0.club_id AS club_id_24, t25.id AS id_26, t25.name AS name_27, t25.url_name AS url_name_28, t25.address AS address_29, t25.zipcode AS zipcode_30, t25.city AS city_31, t25.website AS website_32, t25.courts AS courts_33, t25.period AS period_34, t25.expire_date AS expire_date_35, t25.contact_person AS contact_person_36, t25.contact_email AS contact_email_37, t25.created AS created_38, t25.modified AS modified_39, t25.published_at AS published_at_40, t25.archived_at AS archived_at_41, t25.administrator_id AS administrator_id_42, t25.school_id AS school_id_43, t25.created_by_id AS created_by_id_44, t25.modified_by_id AS modified_by_id_45, t0.created_by_id AS created_by_id_46, t0.modified_by_id AS modified_by_id_47 FROM pool_poule t0 INNER JOIN pool_sport t17 ON t0.sport_id = t17.id INNER JOIN pool_club t25 ON t0.club_id = t25.id INNER JOIN pool_player_pool_poule ON t0.id = pool_player_pool_poule.pool_poule_id WHERE pool_player_pool_poule.pool_player_id = ?
Parameters:
[
75
]
|
| 75 | 0.20 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
21
]
|
| 76 | 0.15 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
21
]
|
| 77 | 0.13 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
21
]
|
| 78 | 0.19 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
75
]
|
| 79 | 0.14 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
75
]
|
| 80 | 0.13 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
75
]
|
| 81 | 0.15 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.poule_id IN (?)
Parameters:
[
1
]
|
| 82 | 0.19 ms |
SELECT t0.id AS id_1, t0.single_ranking AS single_ranking_2, t0.double_ranking AS double_ranking_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.name AS name_7, t5.initials AS initials_8, t5.birth_date AS birth_date_9, t5.gender AS gender_10, t5.telephone AS telephone_11, t5.single AS single_12, t5.dubbel AS dubbel_13, t5.email AS email_14, t5.avatar AS avatar_15, t5.created AS created_16, t5.modified AS modified_17, t5.published_at AS published_at_18, t5.archived_at AS archived_at_19, t5.player_user_id AS player_user_id_20, t5.created_by_id AS created_by_id_21, t5.modified_by_id AS modified_by_id_22, t0.sport_id AS sport_id_23 FROM pool_player_pool_sport t0 INNER JOIN pool_player t5 ON t0.player_id = t5.id WHERE t0.player_id IN (?)
Parameters:
[
86
]
|
| 83 | 0.13 ms |
SELECT t0.id AS id_1, t0.start_ranking AS start_ranking_2, t0.player_id AS player_id_3, t0.poule_id AS poule_id_4 FROM pool_player_poule_ranking t0 WHERE t0.player_id IN (?)
Parameters:
[
86
]
|
| 84 | 0.13 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.player_id AS player_id_3, t0.game_id AS game_id_4 FROM pool_player_pool_game t0 WHERE t0.player_id IN (?)
Parameters:
[
86
]
|
| 85 | 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 = ? LIMIT 1
Parameters:
[
117
]
|
| 86 | 0.45 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:
[
117
]
|
| 87 | 0.21 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:
[
103
]
|
| 88 | 0.23 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, 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_ WHERE p0_.head_menu = 1 AND p0_.parent_page_id IS NULL AND p0_.published_at < ? AND (p0_.archived_at > ? OR p0_.archived_at IS NULL) ORDER BY p0_.sequence ASC
Parameters:
[ "2026-05-21 21:47:48" "2026-05-21 21:47:48" ] |
| 89 | 0.19 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:
[ 2 46 ] |
| 90 | 0.15 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
]
|
| 91 | 0.13 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
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\SjabloonContentValue | 47 |
| App\Entity\SjabloonField | 20 |
| App\Entity\SjabloonFieldValueString | 13 |
| App\Entity\User | 12 |
| App\Entity\PoolRecensie | 10 |
| App\Entity\PoolPlayer | 10 |
| App\Entity\SjabloonFieldValueParent | 9 |
| App\Entity\SjabloonFieldValueImage | 8 |
| App\Entity\SjabloonFieldValueText | 8 |
| App\Entity\SjabloonFieldSpecification | 8 |
| App\Entity\Sjabloon | 7 |
| App\Entity\SjabloonContent | 6 |
| App\Entity\SjabloonFieldValueSjabloonContent | 4 |
| App\Entity\Page | 3 |
| App\Entity\PageSjabloonContent | 3 |
| App\Entity\Language | 2 |
| App\Entity\SjabloonFieldValueTiny | 2 |
| App\Entity\SjabloonFieldValueCollection | 2 |
| App\Entity\SjabloonFieldValueModule | 1 |
| App\Entity\ModuleParameter | 1 |
| App\Entity\PoolPoule | 1 |
| App\Entity\PoolSport | 1 |
| App\Entity\PoolClub | 1 |