Query Metrics
53
Database Queries
19
Different statements
61.03 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 2.90 ms |
SELECT e0_.eshop_id AS eshop_id_0, e0_.eshop_name AS eshop_name_1, e0_.user_id AS user_id_2, e0_.eshop_type AS eshop_type_3, e0_.priority AS priority_4, e0_.status AS status_5, e0_.date_inserted AS date_inserted_6, e0_.date_last_control AS date_last_control_7, e0_.logo_url AS logo_url_8, e0_.notes AS notes_9, e0_.admin_user_id AS admin_user_id_10, e0_.eshop_email AS eshop_email_11, e0_.order_email AS order_email_12, e0_.eshop_price AS eshop_price_13, e0_.eshop_current AS eshop_current_14, e0_.eshop_css AS eshop_css_15, e0_.product_view AS product_view_16, e0_.image_thumb_width AS image_thumb_width_17, e0_.image_thumb_height AS image_thumb_height_18, e0_.wire_frame_id AS wire_frame_id_19, e0_.product_list_wire_frame_id AS product_list_wire_frame_id_20, e0_.product_detail_wire_frame_id AS product_detail_wire_frame_id_21, e0_.preferred_language_id AS preferred_language_id_22, e0_.preferred_currency_id AS preferred_currency_id_23, e0_.round_price AS round_price_24, e0_.cut_long_description AS cut_long_description_25, e0_.display_products_from_subfolders AS display_products_from_subfolders_26, e0_.count_per_page AS count_per_page_27, e0_.is_product_catalogue AS is_product_catalogue_28, e0_.is_price_display AS is_price_display_29, e0_.display_netto_prices AS display_netto_prices_30, e0_.preferred_vat AS preferred_vat_31, e0_.category_image_thumb_width AS category_image_thumb_width_32, e0_.is_stock AS is_stock_33, e0_.display_products_from_subfolders_level AS display_products_from_subfolders_level_34, e0_.is_asynchrounous_shopping AS is_asynchrounous_shopping_35, e0_.is_virtual_reality AS is_virtual_reality_36 FROM eshop e0_ WHERE e0_.eshop_id = ?
Parameters:
[
"14"
]
|
2 | 8.31 ms |
SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ?
Parameters:
[
28
]
|
3 | 4.78 ms |
SELECT e0_.eshop_id AS eshop_id_0, e0_.eshop_name AS eshop_name_1, e0_.user_id AS user_id_2, e0_.eshop_type AS eshop_type_3, e0_.priority AS priority_4, e0_.status AS status_5, e0_.date_inserted AS date_inserted_6, e0_.date_last_control AS date_last_control_7, e0_.logo_url AS logo_url_8, e0_.notes AS notes_9, e0_.admin_user_id AS admin_user_id_10, e0_.eshop_email AS eshop_email_11, e0_.order_email AS order_email_12, e0_.eshop_price AS eshop_price_13, e0_.eshop_current AS eshop_current_14, e0_.eshop_css AS eshop_css_15, e0_.product_view AS product_view_16, e0_.image_thumb_width AS image_thumb_width_17, e0_.image_thumb_height AS image_thumb_height_18, e0_.wire_frame_id AS wire_frame_id_19, e0_.product_list_wire_frame_id AS product_list_wire_frame_id_20, e0_.product_detail_wire_frame_id AS product_detail_wire_frame_id_21, e0_.preferred_language_id AS preferred_language_id_22, e0_.preferred_currency_id AS preferred_currency_id_23, e0_.round_price AS round_price_24, e0_.cut_long_description AS cut_long_description_25, e0_.display_products_from_subfolders AS display_products_from_subfolders_26, e0_.count_per_page AS count_per_page_27, e0_.is_product_catalogue AS is_product_catalogue_28, e0_.is_price_display AS is_price_display_29, e0_.display_netto_prices AS display_netto_prices_30, e0_.preferred_vat AS preferred_vat_31, e0_.category_image_thumb_width AS category_image_thumb_width_32, e0_.is_stock AS is_stock_33, e0_.display_products_from_subfolders_level AS display_products_from_subfolders_level_34, e0_.is_asynchrounous_shopping AS is_asynchrounous_shopping_35, e0_.is_virtual_reality AS is_virtual_reality_36 FROM eshop e0_ WHERE e0_.eshop_id = ?
Parameters:
[
"14"
]
|
4 | 0.05 ms |
SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ?
Parameters:
[
28
]
|
5 | 0.05 ms |
SELECT w0_.wire_frame_id AS wire_frame_id_0, w0_.wire_frame_name AS wire_frame_name_1, w0_.wire_frame_file AS wire_frame_file_2, w0_.wire_frame_image AS wire_frame_image_3, w0_.service_id AS service_id_4 FROM wire_frame w0_ WHERE w0_.wire_frame_id = ?
Parameters:
[
5
]
|
6 | 4.57 ms |
SELECT m0_.module_id AS module_id_0, m0_.module_name AS module_name_1, m0_.action AS action_2, m0_.service_type AS service_type_3, m0_.is_live AS is_live_4, m0_.image AS image_5, m0_.importance AS importance_6, m0_.trial_months AS trial_months_7, m0_.landing_url AS landing_url_8, m0_.register_url AS register_url_9, m0_.price AS price_10, m0_.background_image AS background_image_11, m0_.module_description AS module_description_12 FROM module m0_ WHERE m0_.module_id = ?
Parameters:
[
30
]
|
7 | 7.33 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "30" "en_US" "App\Entity\Module" ] |
8 | 0.05 ms |
SELECT t0.module_id AS module_id_1, t0.module_name AS module_name_2, t0.action AS action_3, t0.service_type AS service_type_4, t0.is_live AS is_live_5, t0.image AS image_6, t0.importance AS importance_7, t0.trial_months AS trial_months_8, t0.landing_url AS landing_url_9, t0.register_url AS register_url_10, t0.price AS price_11, t0.background_image AS background_image_12, t0.module_description AS module_description_13 FROM module t0 INNER JOIN user_module ON t0.module_id = user_module.module_id WHERE user_module.user_id = ?
Parameters:
[
28
]
|
9 | 0.04 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\Module" ] |
10 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "2" "en_US" "App\Entity\Module" ] |
11 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "3" "en_US" "App\Entity\Module" ] |
12 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "10" "en_US" "App\Entity\Module" ] |
13 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "14" "en_US" "App\Entity\Module" ] |
14 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "15" "en_US" "App\Entity\Module" ] |
15 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "16" "en_US" "App\Entity\Module" ] |
16 | 0.86 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "17" "en_US" "App\Entity\Module" ] |
17 | 0.04 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "21" "en_US" "App\Entity\Module" ] |
18 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "22" "en_US" "App\Entity\Module" ] |
19 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "24" "en_US" "App\Entity\Module" ] |
20 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "27" "en_US" "App\Entity\Module" ] |
21 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "39" "en_US" "App\Entity\Module" ] |
22 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "41" "en_US" "App\Entity\Module" ] |
23 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "42" "en_US" "App\Entity\Module" ] |
24 | 2.06 ms |
SELECT m0_.module_id AS module_id_0, m0_.module_name AS module_name_1, m0_.action AS action_2, m0_.service_type AS service_type_3, m0_.is_live AS is_live_4, m0_.image AS image_5, m0_.importance AS importance_6, m0_.trial_months AS trial_months_7, m0_.landing_url AS landing_url_8, m0_.register_url AS register_url_9, m0_.price AS price_10, m0_.background_image AS background_image_11, m0_.module_description AS module_description_12 FROM module m0_ WHERE m0_.module_id = ?
Parameters:
[
41
]
|
25 | 0.05 ms |
SELECT t0.lang_id AS lang_id_1, t0.lang_name AS lang_name_2, t0.lang_key AS lang_key_3, t0.is_live AS is_live_4 FROM language t0 INNER JOIN eshop_language ON t0.lang_id = eshop_language.lang_id WHERE eshop_language.eshop_id = ?
Parameters:
[
14
]
|
26 | 0.05 ms |
SELECT t0.currency_id AS currency_id_1, t0.currency_name AS currency_name_2, t0.currency_key AS currency_key_3, t0.is_live AS is_live_4, t0.rate_eur AS rate_eur_5 FROM currency t0 INNER JOIN eshop_currency ON t0.currency_id = eshop_currency.currency_id WHERE eshop_currency.eshop_id = ?
Parameters:
[
14
]
|
dynamic_conn connection
#▲ | Time | Info |
---|---|---|
1 | 0.76 ms |
SELECT w0_.web_page_id AS web_page_id_0, w0_.web_page_name AS web_page_name_1, w0_.web_page_content AS web_page_content_2, w0_.web_page_description AS web_page_description_3, w0_.website_id AS website_id_4, w0_.eshop_id AS eshop_id_5, w0_.date_inserted AS date_inserted_6, w0_.date_last_control AS date_last_control_7, w0_.date_published AS date_published_8, w0_.web_page_type AS web_page_type_9, w0_.seo_title AS seo_title_10, w0_.seo_description AS seo_description_11, w0_.priority AS priority_12, w0_.image_file AS image_file_13, w0_.score AS score_14, w0_.auction_hall_id AS auction_hall_id_15 FROM web_page w0_ WHERE w0_.eshop_id = ? AND w0_.web_page_type = ?
Parameters:
[ "14" 2 ] |
2 | 6.95 ms |
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\WebPage" ] |
3 | 0.05 ms |
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ?
Parameters:
[
1
]
|
4 | 0.04 ms |
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
Parameters:
[ "1" "sk" "App\Entity\WebPage" ] |
5 | 0.04 ms |
SELECT w0_.web_page_id AS web_page_id_0, w0_.web_page_name AS web_page_name_1, w0_.web_page_content AS web_page_content_2, w0_.web_page_description AS web_page_description_3, w0_.website_id AS website_id_4, w0_.eshop_id AS eshop_id_5, w0_.date_inserted AS date_inserted_6, w0_.date_last_control AS date_last_control_7, w0_.date_published AS date_published_8, w0_.web_page_type AS web_page_type_9, w0_.seo_title AS seo_title_10, w0_.seo_description AS seo_description_11, w0_.priority AS priority_12, w0_.image_file AS image_file_13, w0_.score AS score_14, w0_.auction_hall_id AS auction_hall_id_15 FROM web_page w0_ WHERE w0_.eshop_id = ? AND w0_.web_page_type = ?
Parameters:
[ "14" 3 ] |
6 | 0.03 ms |
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
Parameters:
[ "5" "en_US" "App\Entity\WebPage" ] |
7 | 0.03 ms |
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ?
Parameters:
[
5
]
|
8 | 0.03 ms |
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
Parameters:
[ "5" "sk" "App\Entity\WebPage" ] |
9 | 0.04 ms |
SELECT w0_.web_page_id AS web_page_id_0, w0_.web_page_name AS web_page_name_1, w0_.web_page_content AS web_page_content_2, w0_.web_page_description AS web_page_description_3, w0_.website_id AS website_id_4, w0_.eshop_id AS eshop_id_5, w0_.date_inserted AS date_inserted_6, w0_.date_last_control AS date_last_control_7, w0_.date_published AS date_published_8, w0_.web_page_type AS web_page_type_9, w0_.seo_title AS seo_title_10, w0_.seo_description AS seo_description_11, w0_.priority AS priority_12, w0_.image_file AS image_file_13, w0_.score AS score_14, w0_.auction_hall_id AS auction_hall_id_15 FROM web_page w0_ WHERE w0_.eshop_id = ? AND w0_.web_page_type = ?
Parameters:
[ "14" 1 ] |
10 | 0.03 ms |
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
Parameters:
[ "7" "en_US" "App\Entity\WebPage" ] |
11 | 4.26 ms |
SELECT c0_.consent_id AS consent_id_0, c0_.consent_name AS consent_name_1, c0_.consent_description AS consent_description_2, c0_.consent_type AS consent_type_3, c0_.priority AS priority_4, c0_.status AS status_5, c0_.date_inserted AS date_inserted_6, c0_.date_valid AS date_valid_7, c0_.notes AS notes_8, c0_.date_modified AS date_modified_9, c0_.double_opt AS double_opt_10, c0_.block_order AS block_order_11, c0_.active AS active_12 FROM consent c0_
Parameters:
[] |
12 | 3.38 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM consent_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\Consent" ] |
13 | 0.04 ms |
SELECT t0.consent_id AS consent_id_1, t0.consent_name AS consent_name_2, t0.consent_description AS consent_description_3, t0.consent_type AS consent_type_4, t0.priority AS priority_5, t0.status AS status_6, t0.date_inserted AS date_inserted_7, t0.date_valid AS date_valid_8, t0.notes AS notes_9, t0.date_modified AS date_modified_10, t0.double_opt AS double_opt_11, t0.block_order AS block_order_12, t0.active AS active_13 FROM consent t0 WHERE t0.consent_id = ?
Parameters:
[
1
]
|
14 | 0.03 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM consent_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "1" "sk" "App\Entity\Consent" ] |
15 | 3.51 ms |
SELECT t0.re_captcha_id AS re_captcha_id_1, t0.site_key AS site_key_2, t0.is_active AS is_active_3 FROM re_captcha t0 WHERE t0.re_captcha_id = ? LIMIT 1
Parameters:
[
1
]
|
16 | 9.57 ms |
SELECT c0_.category_id AS category_id_0, c0_.category_key AS category_key_1, c0_.category_name AS category_name_2, c0_.category_description AS category_description_3, c0_.image1 AS image1_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.eshop_id AS eshop_id_8, c0_.erpkey AS erpkey_9, c0_.is_active AS is_active_10, c0_.is_hidden AS is_hidden_11, c0_.image_thumb_width AS image_thumb_width_12, c0_.image_thumb_height AS image_thumb_height_13, c0_.auction_hall_id AS auction_hall_id_14, c0_.marketplace_department_id AS marketplace_department_id_15, c0_.priority AS priority_16 FROM category c0_ ORDER BY c0_.root_id ASC, c0_.lft ASC
Parameters:
[] |
17 | 0.38 ms |
SELECT c0_.category_id AS category_id_0, c0_.category_key AS category_key_1, c0_.category_name AS category_name_2, c0_.category_description AS category_description_3, c0_.image1 AS image1_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.eshop_id AS eshop_id_8, c0_.erpkey AS erpkey_9, c0_.is_active AS is_active_10, c0_.is_hidden AS is_hidden_11, c0_.image_thumb_width AS image_thumb_width_12, c0_.image_thumb_height AS image_thumb_height_13, c0_.auction_hall_id AS auction_hall_id_14, c0_.marketplace_department_id AS marketplace_department_id_15, c0_.priority AS priority_16, c0_.root_id AS root_id_17, c0_.parent_id AS parent_id_18 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.lft ASC
Parameters:
[] |
18 | 0.05 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\Category" ] |
19 | 0.03 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "2" "en_US" "App\Entity\Category" ] |
20 | 0.03 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "4" "en_US" "App\Entity\Category" ] |
21 | 0.03 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "46" "en_US" "App\Entity\Category" ] |
22 | 0.05 ms |
SELECT t0.category_id AS category_id_1, t0.category_key AS category_key_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.eshop_id AS eshop_id_9, t0.erpkey AS erpkey_10, t0.is_active AS is_active_11, t0.is_hidden AS is_hidden_12, t0.image_thumb_width AS image_thumb_width_13, t0.image_thumb_height AS image_thumb_height_14, t0.auction_hall_id AS auction_hall_id_15, t0.marketplace_department_id AS marketplace_department_id_16, t0.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
23 | 0.03 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "1" "sk" "App\Entity\Category" ] |
24 | 0.04 ms |
SELECT t0.category_id AS category_id_1, t0.category_key AS category_key_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.eshop_id AS eshop_id_9, t0.erpkey AS erpkey_10, t0.is_active AS is_active_11, t0.is_hidden AS is_hidden_12, t0.image_thumb_width AS image_thumb_width_13, t0.image_thumb_height AS image_thumb_height_14, t0.auction_hall_id AS auction_hall_id_15, t0.marketplace_department_id AS marketplace_department_id_16, t0.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
2
]
|
25 | 0.03 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "2" "sk" "App\Entity\Category" ] |
26 | 0.04 ms |
SELECT t0.category_id AS category_id_1, t0.category_key AS category_key_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.eshop_id AS eshop_id_9, t0.erpkey AS erpkey_10, t0.is_active AS is_active_11, t0.is_hidden AS is_hidden_12, t0.image_thumb_width AS image_thumb_width_13, t0.image_thumb_height AS image_thumb_height_14, t0.auction_hall_id AS auction_hall_id_15, t0.marketplace_department_id AS marketplace_department_id_16, t0.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
4
]
|
27 | 0.03 ms |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "4" "sk" "App\Entity\Category" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
dynamic_conn | doctrine.dbal.dynamic_conn_connection |
eshop_conn | doctrine.dbal.eshop_conn_connection |
eshop_demo_conn | doctrine.dbal.eshop_demo_conn_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
dynamic_em | doctrine.orm.dynamic_em_entity_manager |
eshop_em | doctrine.orm.eshop_em_entity_manager |
eshop_demo_em | doctrine.orm.eshop_demo_em_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Eshop | No errors. |
App\Entity\Language | No errors. |
App\Entity\Currency | No errors. |
App\Entity\User | No errors. |
App\Entity\Service | No errors. |
App\Entity\Module | No errors. |
App\Entity\WireFrame | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
App\Entity\ModuleTranslation | No errors. |
App\Entity\Contact | No errors. |
dynamic_em entity manager
Class | Mapping errors |
---|---|
App\Entity\Eshop | No errors. |
App\Entity\WebPage | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
App\Entity\WebPageTranslation | No errors. |
App\Entity\Consent | No errors. |
App\Entity\ConsentTranslation | No errors. |
App\Entity\ReCaptcha | No errors. |
App\Entity\Contact | No errors. |
App\Entity\Category | No errors. |
App\Entity\CategoryTranslation | No errors. |
eshop_em entity manager
Class | Mapping errors |
---|---|
App\Entity\Contact | No errors. |
eshop_demo_em entity manager
Class | Mapping errors |
---|---|
App\Entity\Contact | No errors. |