Query Metrics
59
Database Queries
20
Different statements
85.92 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 9.29 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
1
]
|
2 | 0.19 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
1
]
|
3 | 0.22 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
"cs"
]
|
4 | 0.16 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
1
]
|
5 | 0.12 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
1
]
|
6 | 0.17 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
"cs"
]
|
7 | 7.05 ms |
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3, t4.trans_value AS trans_value_5, t4.id AS id_6, t4.locale AS locale_7, t4.translatable_id AS translatable_id_8 FROM setting t0 LEFT JOIN setting_translation t4 ON t4.translatable_id = t0.id
Parameters:
[] |
8 | 7.98 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15, t16.name AS name_17, t16.title AS title_18, t16.short_text AS short_text_19, t16.text AS text_20, t16.id AS id_21, t16.locale AS locale_22, t16.translatable_id AS translatable_id_23 FROM web_page t0 LEFT JOIN web_page_translation t16 ON t16.translatable_id = t0.id
Parameters:
[] |
9 | 12.67 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t3.name AS name_4, t3.id AS id_5, t3.locale AS locale_6, t3.translatable_id AS translatable_id_7 FROM web_menu_group t0 LEFT JOIN web_menu_group_translation t3 ON t3.translatable_id = t0.id
Parameters:
[] |
10 | 5.34 ms |
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[] |
11 | 2.46 ms |
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.file_id AS file_id_14, t6.img_file_id AS img_file_id_15 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
12 | 0.23 ms |
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.file_id AS file_id_14, t6.img_file_id AS img_file_id_15 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
13 | 0.25 ms |
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.file_id AS file_id_14, t6.img_file_id AS img_file_id_15 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
14 | 0.17 ms |
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.file_id AS file_id_14, t6.img_file_id AS img_file_id_15 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
15 | 0.16 ms |
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.file_id AS file_id_14, t6.img_file_id AS img_file_id_15 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
16 | 3.89 ms |
SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5, t6.url AS url_7, t6.name AS name_8, t6.id AS id_9, t6.locale AS locale_10, t6.translatable_id AS translatable_id_11 FROM web_module t0 LEFT JOIN web_module_translation t6 ON t6.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
17 | 0.25 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4
]
|
18 | 4.77 ms |
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6, t7.title AS title_8, t7.description AS description_9, t7.keywords AS keywords_10, t7.name AS name_11, t7.url AS url_12, t7.`generated` AS generated_13, t7.id AS id_14, t7.locale AS locale_15, t7.translatable_id AS translatable_id_16 FROM web_seo t0 LEFT JOIN web_seo_translation t7 ON t7.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
4
]
|
19 | 0.19 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
5
]
|
20 | 0.18 ms |
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6, t7.title AS title_8, t7.description AS description_9, t7.keywords AS keywords_10, t7.name AS name_11, t7.url AS url_12, t7.`generated` AS generated_13, t7.id AS id_14, t7.locale AS locale_15, t7.translatable_id AS translatable_id_16 FROM web_seo t0 LEFT JOIN web_seo_translation t7 ON t7.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
5
]
|
21 | 0.16 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3
]
|
22 | 0.20 ms |
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6, t7.title AS title_8, t7.description AS description_9, t7.keywords AS keywords_10, t7.name AS name_11, t7.url AS url_12, t7.`generated` AS generated_13, t7.id AS id_14, t7.locale AS locale_15, t7.translatable_id AS translatable_id_16 FROM web_seo t0 LEFT JOIN web_seo_translation t7 ON t7.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
3
]
|
23 | 0.15 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
24 | 0.15 ms |
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6, t7.title AS title_8, t7.description AS description_9, t7.keywords AS keywords_10, t7.name AS name_11, t7.url AS url_12, t7.`generated` AS generated_13, t7.id AS id_14, t7.locale AS locale_15, t7.translatable_id AS translatable_id_16 FROM web_seo t0 LEFT JOIN web_seo_translation t7 ON t7.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
25 | 0.13 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
9
]
|
26 | 0.19 ms |
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6, t7.title AS title_8, t7.description AS description_9, t7.keywords AS keywords_10, t7.name AS name_11, t7.url AS url_12, t7.`generated` AS generated_13, t7.id AS id_14, t7.locale AS locale_15, t7.translatable_id AS translatable_id_16 FROM web_seo t0 LEFT JOIN web_seo_translation t7 ON t7.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
9
]
|
27 | 1.33 ms |
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 2 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[] |
28 | 0.19 ms |
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.file_id AS file_id_14, t6.img_file_id AS img_file_id_15 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
6
]
|
29 | 0.18 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
8
]
|
30 | 0.17 ms |
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6, t7.title AS title_8, t7.description AS description_9, t7.keywords AS keywords_10, t7.name AS name_11, t7.url AS url_12, t7.`generated` AS generated_13, t7.id AS id_14, t7.locale AS locale_15, t7.translatable_id AS translatable_id_16 FROM web_seo t0 LEFT JOIN web_seo_translation t7 ON t7.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
8
]
|
31 | 0.13 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4
]
|
32 | 0.13 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3
]
|
33 | 3.35 ms |
SELECT t0.name AS name_1, t0.id AS id_2 FROM web_slider_group t0
Parameters:
[] |
34 | 4.12 ms |
SELECT w0_.active AS active_0, w0_.created AS created_1, w0_.id AS id_2, w0_.sort AS sort_3, w0_.link_id AS link_id_4, w0_.page_id AS page_id_5, w0_.author_id AS author_id_6, w0_.file_tablet_id AS file_tablet_id_7, w0_.file_phone_id AS file_phone_id_8, w0_.video_id AS video_id_9, w0_.dms_file_tablet_id AS dms_file_tablet_id_10, w0_.dms_file_phone_id AS dms_file_phone_id_11, w0_.dms_video_id AS dms_video_id_12, w0_.file_id AS file_id_13, w0_.img_file_id AS img_file_id_14 FROM web_slider w0_ INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.page_id ASC, w0_.sort ASC
Parameters:
[] |
35 | 2.63 ms |
SELECT t0.name AS name_1, t0.text AS text_2, t0.url AS url_3, t0.button AS button_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.active AS active_9, t8.created AS created_10, t8.id AS id_11, t8.sort AS sort_12, t8.link_id AS link_id_13, t8.page_id AS page_id_14, t8.author_id AS author_id_15, t8.file_tablet_id AS file_tablet_id_16, t8.file_phone_id AS file_phone_id_17, t8.video_id AS video_id_18, t8.dms_file_tablet_id AS dms_file_tablet_id_19, t8.dms_file_phone_id AS dms_file_phone_id_20, t8.dms_video_id AS dms_video_id_21, t8.file_id AS file_id_22, t8.img_file_id AS img_file_id_23 FROM web_slider_translation t0 LEFT JOIN web_slider t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
36 | 4.03 ms |
SELECT t0.block_key AS block_key_1, t0.id AS id_2, t0.files_order AS files_order_3, t0.media_updated AS media_updated_4, t0.img_files_order AS img_files_order_5, t0.block_file_id AS block_file_id_6, t0.file_id AS file_id_7, t0.img_file_id AS img_file_id_8, t0.doc_file_id AS doc_file_id_9, t10.name AS name_11, t10.text AS text_12, t10.id AS id_13, t10.locale AS locale_14, t10.translatable_id AS translatable_id_15 FROM web_block t0 LEFT JOIN web_block_translation t10 ON t10.translatable_id = t0.id
Parameters:
[] |
37 | 3.67 ms |
SELECT t0.updated_at AS updated_at_1, t0.sort AS sort_2, t0.id AS id_3, t0.seo_id AS seo_id_4, t0.file_id AS file_id_5, t6.name AS name_7, t6.short_name AS short_name_8, t6.description AS description_9, t6.id AS id_10, t6.locale AS locale_11, t6.translatable_id AS translatable_id_12 FROM shop_category t0 LEFT JOIN shop_category_translation t6 ON t6.translatable_id = t0.id ORDER BY t0.sort ASC
Parameters:
[] |
38 | 4.96 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9, t10.name AS name_11, t10.id AS id_12, t10.locale AS locale_13, t10.translatable_id AS translatable_id_14 FROM web_template t0 LEFT JOIN web_template_translation t10 ON t10.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
5
]
|
39 | 0.21 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9, t10.name AS name_11, t10.id AS id_12, t10.locale AS locale_13, t10.translatable_id AS translatable_id_14 FROM web_template t0 LEFT JOIN web_template_translation t10 ON t10.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
40 | 0.17 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9, t10.name AS name_11, t10.id AS id_12, t10.locale AS locale_13, t10.translatable_id AS translatable_id_14 FROM web_template t0 LEFT JOIN web_template_translation t10 ON t10.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
4
]
|
41 | 0.23 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9, t10.name AS name_11, t10.id AS id_12, t10.locale AS locale_13, t10.translatable_id AS translatable_id_14 FROM web_template t0 LEFT JOIN web_template_translation t10 ON t10.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
2
]
|
42 | 0.22 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9, t10.name AS name_11, t10.id AS id_12, t10.locale AS locale_13, t10.translatable_id AS translatable_id_14 FROM web_template t0 LEFT JOIN web_template_translation t10 ON t10.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
6
]
|
43 | 0.26 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9, t10.name AS name_11, t10.id AS id_12, t10.locale AS locale_13, t10.translatable_id AS translatable_id_14 FROM web_template t0 LEFT JOIN web_template_translation t10 ON t10.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
44 | 0.21 ms |
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0 WHERE t0.homepage = ? LIMIT 1
Parameters:
[
1
]
|
45 | 0.20 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
1
]
|
46 | 0.12 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
1
]
|
47 | 0.12 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
"cs"
]
|
48 | 0.13 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
1
]
|
49 | 0.11 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
1
]
|
50 | 0.10 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
"cs"
]
|
51 | 0.53 ms |
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"instagram_client_id"
]
|
52 | 0.13 ms |
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"instagram_client_secret"
]
|
53 | 0.15 ms |
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"instagram_token"
]
|
54 | 0.50 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
1
]
|
55 | 0.19 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
1
]
|
56 | 0.20 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
"cs"
]
|
57 | 0.20 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
1
]
|
58 | 0.18 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
1
]
|
59 | 0.15 ms |
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
"cs"
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
NexCRM\BaseBundle\Entity\Lang | No errors. |
NexCRM\BaseBundle\Entity\Country | No errors. |
NexCRM\BaseBundle\Entity\Setting | No errors. |
NexCRM\ShopBundle\Entity\Product | No errors. |
NexCRM\BaseBundle\Entity\SettingTranslation | No errors. |
NexCRM\WebBundle\Entity\Page | No errors. |
NexCRM\WebBundle\Entity\SEO | No errors. |
NexCRM\WebBundle\Entity\Template | No errors. |
NexCRM\BaseBundle\Entity\MediaFile | No errors. |
NexCRM\DMSBundle\Entity\File | No errors. |
NexCRM\WebBundle\Entity\PageTranslation | No errors. |
NexCRM\WebBundle\Entity\Content | No errors. |
NexCRM\WebBundle\Entity\Menu | No errors. |
NexCRM\WebBundle\Entity\MenuGroup | No errors. |
NexCRM\WebBundle\Entity\MenuGroupTranslation | No errors. |
NexCRM\WebBundle\Entity\Module | No errors. |
NexCRM\WebBundle\Entity\MenuTranslation | No errors. |
NexCRM\WebBundle\Entity\ModuleTranslation | No errors. |
NexCRM\WebBundle\Entity\SEOTranslation | No errors. |
NexCRM\WebBundle\Entity\Slider | No errors. |
NexCRM\WebBundle\Entity\SliderGroup | No errors. |
NexCRM\BaseBundle\Entity\User | No errors. |
NexCRM\WebBundle\Entity\SliderTranslation | No errors. |
NexCRM\WebBundle\Entity\Block | No errors. |
NexCRM\WebBundle\Entity\BlockTranslation | No errors. |
NexCRM\ShopBundle\Entity\Category |
|
NexCRM\ShopBundle\Entity\CategoryTranslation | No errors. |
NexCRM\ShopBundle\Entity\CategoryParameter | No errors. |
NexCRM\WebBundle\Entity\TemplateTranslation | No errors. |
NexCRM\ShopBundle\Entity\ParameterGroup | No errors. |
NexCRM\ShopBundle\Entity\ParameterValue | No errors. |
NexCRM\ShopBundle\Entity\ProductTranslation | No errors. |
NexCRM\BaseBundle\Entity\Folder | No errors. |
NexCRM\BaseBundle\Entity\MediaFileTranslation | No errors. |
NexCRM\DMSBundle\Entity\Folder | No errors. |
NexCRM\DMSBundle\Entity\FileLog | No errors. |
NexCRM\DMSBundle\Entity\FileParameters | No errors. |
NexCRM\DMSBundle\Entity\FileTranslation | No errors. |
NexCRM\WebBundle\Entity\ContentTranslation | No errors. |
NexCRM\BaseBundle\Entity\Role | No errors. |
NexCRM\BaseBundle\Entity\AbstractTranslatableEntity | No errors. |
NexCRM\BaseBundle\Entity\BruteForceBlock | No errors. |
NexCRM\BaseBundle\Entity\BruteForceLoginAttempt | No errors. |
NexCRM\BaseBundle\Entity\LangToken | No errors. |
NexCRM\BaseBundle\Entity\LangTranslation | No errors. |
NexCRM\BaseBundle\Entity\Log | No errors. |
NexCRM\BaseBundle\Entity\MediaOrderRecord | No errors. |
NexCRM\BaseBundle\Entity\MediaSize | No errors. |
NexCRM\BaseBundle\Entity\RoleTranslation | No errors. |
NexCRM\WebBundle\Entity\Web | No errors. |
NexCRM\WebBundle\Entity\Contact | No errors. |
NexCRM\WebBundle\Entity\News | No errors. |
NexCRM\WebBundle\Entity\NewsTranslation | No errors. |
NexCRM\WebBundle\Entity\Setting | No errors. |
NexCRM\WebBundle\Entity\SettingTranslation | No errors. |
NexCRM\WebBundle\Entity\Tag | No errors. |
NexCRM\WebBundle\Entity\TagTranslation | No errors. |
NexCRM\WebBundle\Entity\Code | No errors. |
NexCRM\WebBundle\Entity\CodeTranslation | No errors. |
NexCRM\WebBundle\Entity\Cookie | No errors. |
NexCRM\WebBundle\Entity\CookieTranslation | No errors. |
NexCRM\ShopBundle\Entity\Basket | No errors. |
NexCRM\ShopBundle\Entity\BasketItem | No errors. |
NexCRM\ShopBundle\Entity\DeliveryData | No errors. |
NexCRM\ShopBundle\Entity\OrderItem | No errors. |
NexCRM\ShopBundle\Entity\Parameter | No errors. |
NexCRM\ShopBundle\Entity\ParameterGroupTranslation | No errors. |
NexCRM\ShopBundle\Entity\ParameterTranslation | No errors. |
NexCRM\ShopBundle\Entity\PaymentMethod | No errors. |
NexCRM\ShopBundle\Entity\PaymentMethodTranslation | No errors. |
NexCRM\ShopBundle\Entity\ShippingMethod | No errors. |
NexCRM\ShopBundle\Entity\ShippingMethodTranslation | No errors. |
NexCRM\ShopBundle\Entity\Status | No errors. |
NexCRM\ShopBundle\Entity\StatusTranslation | No errors. |
NexCRM\ShopBundle\Entity\Order | No errors. |
NexCRM\NotificationBundle\Entity\DatabaseNotification | No errors. |
NexCRM\NotificationBundle\Entity\Entity | No errors. |
NexCRM\NotificationBundle\Entity\EntityProperty | No errors. |
NexCRM\NotificationBundle\Entity\EntityTranslation | No errors. |
NexCRM\NotificationBundle\Entity\Notification | No errors. |
NexCRM\NotificationBundle\Entity\NotificationContent | No errors. |
NexCRM\NotificationBundle\Entity\NotificationContentTranslation | No errors. |
NexCRM\NotificationBundle\Entity\NotificationRule | No errors. |
NexCRM\NotificationBundle\Entity\Notificator | No errors. |
NexCRM\NotificationBundle\Entity\NotificatorTranslation | No errors. |
NexCRM\NotificationBundle\Entity\Recipient | No errors. |
NexCRM\NotificationBundle\Entity\SystemNotification | No errors. |
NexCRM\NotificationBundle\Entity\Template | No errors. |
NexCRM\NotificationBundle\Entity\TemplateTranslation | No errors. |
NexCRM\NotificationBundle\Entity\Watcher | No errors. |
NexCRM\NotificationBundle\Entity\WatcherContent | No errors. |
NexCRM\NotificationBundle\Entity\WatcherContentTranslation | No errors. |
NexCRM\PersonBundle\Entity\Person |
|
NexCRM\PersonBundle\Entity\Address | No errors. |
NexCRM\PersonBundle\Entity\BankDetail | No errors. |
NexCRM\PersonBundle\Entity\PersonalData | No errors. |
NexCRM\CompanyBundle\Entity\Company | No errors. |
NexCRM\CompanyBundle\Entity\CompanyContact | No errors. |
NexCRM\CompanyBundle\Entity\EvidenceType | No errors. |
NexCRM\CompanyBundle\Entity\Subject | No errors. |
NexCRM\CompanyBundle\Entity\VatPayer | No errors. |
NexCRM\DMSBundle\Entity\FavoriteFolder | No errors. |
NexCRM\DMSBundle\Entity\FileComment | No errors. |
NexCRM\DMSBundle\Entity\FileField | No errors. |
NexCRM\DMSBundle\Entity\FileTemplate | No errors. |
NexCRM\DMSBundle\Entity\FileTemplateField | No errors. |
NexCRM\DMSBundle\Entity\FileTemplateFieldSetting | No errors. |
NexCRM\DMSBundle\Entity\FileType | No errors. |
NexCRM\DMSBundle\Entity\Filter | No errors. |
NexCRM\DMSBundle\Entity\FilterField | No errors. |
NexCRM\DMSBundle\Entity\FilterItem | No errors. |
NexCRM\DMSBundle\Entity\FolderRule | No errors. |
NexCRM\DMSBundle\Entity\NumericalRoot | No errors. |
NexCRM\DMSBundle\Entity\NumericalRootDefinition | No errors. |
NexCRM\DMSBundle\Entity\OrderRecord | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |