https://dev58.nexgen.cz/?rest_route=%2Fwp%2Fv2%2Fusers%2F

Query Metrics

59 Database Queries
20 Different statements
85.92 ms Query time
2 Invalid entities

Queries

Group similar statements

# 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
  • The field NexCRM\ShopBundle\Entity\Category#products is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity NexCRM\ShopBundle\Entity\Product#category does not contain the required 'inversedBy="products"' attribute.
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
  • The field NexCRM\PersonBundle\Entity\Person#addresses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity NexCRM\PersonBundle\Entity\Address#person does not contain the required 'inversedBy="addresses"' attribute.
  • The field NexCRM\PersonBundle\Entity\Person#bankDetails is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity NexCRM\PersonBundle\Entity\BankDetail#person does not contain the required 'inversedBy="bankDetails"' attribute.
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.