Query Metrics
93
Database Queries
33
Different statements
16.22 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.14 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 | 0.08 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 | 0.06 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 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
]
|
| 6 | 0.05 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:
[
42
]
|
| 7 | 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:
[ "42" "en_US" "App\Entity\Module" ] |
| 8 | 0.06 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.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:
[ "17" "en_US" "App\Entity\Module" ] |
| 17 | 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:
[ "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.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:
[ "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:
[ "30" "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:
[ "39" "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:
[ "41" "en_US" "App\Entity\Module" ] |
| 24 | 0.04 ms |
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_ WHERE c0_.currency_id = ?
Parameters:
[
4
]
|
| 25 | 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
]
|
| 26 | 0.04 ms |
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_ WHERE c0_.currency_id = ?
Parameters:
[
4
]
|
| 27 | 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
]
|
| 28 | 0.04 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.05 ms |
SELECT p0_.price_level_id AS price_level_id_0, p0_.price_level_name AS price_level_name_1, p0_.price_level_description AS price_level_description_2 FROM price_level p0_
Parameters:
[] |
| 2 | 0.04 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\PriceLevel" ] |
| 3 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "2" "en_US" "App\Entity\PriceLevel" ] |
| 4 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "3" "en_US" "App\Entity\PriceLevel" ] |
| 5 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "4" "en_US" "App\Entity\PriceLevel" ] |
| 6 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "6" "en_US" "App\Entity\PriceLevel" ] |
| 7 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "8" "en_US" "App\Entity\PriceLevel" ] |
| 8 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "10" "en_US" "App\Entity\PriceLevel" ] |
| 9 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "11" "en_US" "App\Entity\PriceLevel" ] |
| 10 | 0.33 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
"9209"
]
|
| 11 | 0.25 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "9209" "en_US" "App\Entity\Product" ] |
| 12 | 0.19 ms |
SELECT t0.product_id AS product_id_1, t0.product_key AS product_key_2, t0.ean AS ean_3, t0.erpkey AS erpkey_4, t0.parent_product_id AS parent_product_id_5, t0.product_name AS product_name_6, t0.product_description AS product_description_7, t0.product_short_description AS product_short_description_8, t0.image1 AS image1_9, t0.image2 AS image2_10, t0.image3 AS image3_11, t0.is_active AS is_active_12, t0.active_from AS active_from_13, t0.active_to AS active_to_14, t0.unit_name AS unit_name_15, t0.marketplace_department_id AS marketplace_department_id_16, t0.product_link AS product_link_17, t0.viewed_count AS viewed_count_18, t0.clicked_count AS clicked_count_19, t0.product_vat AS product_vat_20, t0.stock AS stock_21, t0.title_seo AS title_seo_22, t0.keywords_seo AS keywords_seo_23, t0.priority AS priority_24, t0.pieces_in_pack AS pieces_in_pack_25, t0.pack_price AS pack_price_26, t0.is_strict_pack_sale AS is_strict_pack_sale_27, t0.product_model_link AS product_model_link_28, t0.manufacturer AS manufacturer_29, t0.gallery3d_id AS gallery3d_id_30, t0.minimal_amount AS minimal_amount_31 FROM product t0 WHERE t0.product_id = ?
Parameters:
[
9209
]
|
| 13 | 0.71 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.parent_product_id = ? ORDER BY p0_.product_id ASC
Parameters:
[
"9209"
]
|
| 14 | 0.23 ms |
SELECT t0.gallery_id AS gallery_id_1, t0.gallery_name AS gallery_name_2, t0.user_id AS user_id_3, t0.gallery_description AS gallery_description_4, t0.is_public AS is_public_5, t0.is_web_based AS is_web_based_6, t0.date_created AS date_created_7, t0.slide_gallery_width AS slide_gallery_width_8, t0.slide_gallery_height AS slide_gallery_height_9, t0.slideshow_width AS slideshow_width_10, t0.slideshow_height AS slideshow_height_11, t0.folder_name AS folder_name_12, t0.slideshow_effect AS slideshow_effect_13, t0.thumb_size AS thumb_size_14, t0.is_file_lock AS is_file_lock_15, t0.slide_gallery_is_vertical AS slide_gallery_is_vertical_16, t0.slideshow_time AS slideshow_time_17, t0.gallery_logo_url AS gallery_logo_url_18, t0.gallery_css AS gallery_css_19 FROM gallery t0 INNER JOIN product_gallery ON t0.gallery_id = product_gallery.gallery_id WHERE product_gallery.product_id = ?
Parameters:
[
9209
]
|
| 15 | 0.05 ms |
SELECT p0_.product_parameter_id AS product_parameter_id_0, p0_.product_parameter_name AS product_parameter_name_1, p0_.product_parameter_description AS product_parameter_description_2, p0_.product_parameter_choices AS product_parameter_choices_3, p0_.unit_name AS unit_name_4, p0_.product_parameter_key AS product_parameter_key_5, p0_.priority AS priority_6, p0_.parameter_type AS parameter_type_7, p0_.is_visible AS is_visible_8, p0_.is_filterable AS is_filterable_9 FROM product_parameter p0_
Parameters:
[] |
| 16 | 0.05 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\ProductParameter" ] |
| 17 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "2" "en_US" "App\Entity\ProductParameter" ] |
| 18 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "3" "en_US" "App\Entity\ProductParameter" ] |
| 19 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "4" "en_US" "App\Entity\ProductParameter" ] |
| 20 | 0.04 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "5" "en_US" "App\Entity\ProductParameter" ] |
| 21 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "6" "en_US" "App\Entity\ProductParameter" ] |
| 22 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "7" "en_US" "App\Entity\ProductParameter" ] |
| 23 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "8" "en_US" "App\Entity\ProductParameter" ] |
| 24 | 0.03 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "9" "en_US" "App\Entity\ProductParameter" ] |
| 25 | 1.26 ms |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?)
Parameters:
[
"9209"
]
|
| 26 | 7.94 ms |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM package_price p0_ WHERE p0_.product_id IN (?)
Parameters:
[
"9209"
]
|
| 27 | 0.07 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 ] |
| 28 | 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" "en_US" "App\Entity\WebPage" ] |
| 29 | 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
]
|
| 30 | 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 ] |
| 31 | 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:
[ "5" "en_US" "App\Entity\WebPage" ] |
| 32 | 0.04 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
]
|
| 33 | 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 ] |
| 34 | 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:
[ "7" "en_US" "App\Entity\WebPage" ] |
| 35 | 0.37 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 INNER JOIN product_category ON t0.category_id = product_category.category_id WHERE product_category.product_id = ?
Parameters:
[
9209
]
|
| 36 | 0.04 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:
[ "41" "en_US" "App\Entity\Category" ] |
| 37 | 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:
[
41
]
|
| 38 | 0.05 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_.lft <= 8 AND c0_.rgt >= 9 AND c0_.root_id = ? ORDER BY c0_.lft ASC
Parameters:
[
4
]
|
| 39 | 0.04 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" ] |
| 40 | 0.04 ms |
SELECT p0_.product_parameter_id AS product_parameter_id_0, p0_.product_parameter_name AS product_parameter_name_1, p0_.product_parameter_description AS product_parameter_description_2, p0_.product_parameter_choices AS product_parameter_choices_3, p0_.unit_name AS unit_name_4, p0_.product_parameter_key AS product_parameter_key_5, p0_.priority AS priority_6, p0_.parameter_type AS parameter_type_7, p0_.is_visible AS is_visible_8, p0_.is_filterable AS is_filterable_9 FROM product_parameter p0_
Parameters:
[] |
| 41 | 1.46 ms |
SELECT p0_.product_parameter_value_id AS product_parameter_value_id_0, p0_.product_parameter_id AS product_parameter_id_1, p0_.product_id AS product_id_2, p0_.product_parameter_value AS product_parameter_value_3, p0_.unit_name AS unit_name_4, p0_.erp_key AS erp_key_5, p0_.priority AS priority_6 FROM product_parameter_value p0_ WHERE p0_.product_id = ?
Parameters:
[
"9209"
]
|
| 42 | 0.04 ms |
SELECT p0_.product_parameter_group_id AS product_parameter_group_id_0, p0_.product_parameter_group_name AS product_parameter_group_name_1, p0_.product_parameter_group_description AS product_parameter_group_description_2, p0_.product_parameter_key AS product_parameter_key_3, p0_.priority AS priority_4, p0_.is_visible AS is_visible_5 FROM product_parameter_group p0_
Parameters:
[] |
| 43 | 0.05 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:
[] |
| 44 | 0.05 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:
[] |
| 45 | 0.04 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" ] |
| 46 | 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" ] |
| 47 | 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" ] |
| 48 | 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:
[
1
]
|
| 49 | 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
]
|
| 50 | 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
]
|
| 51 | 0.05 ms |
SELECT e0_.order_item_title AS order_item_title_0, e0_.product_id AS product_id_1, COUNT(e0_.product_id) AS sclr_2 FROM eshop_order_item e0_ WHERE e0_.product_id > 0 AND e0_.order_item_title <> ? GROUP BY e0_.product_id ORDER BY sclr_2 DESC LIMIT 7
Parameters:
[ "" ] |
| 52 | 0.07 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
8949
]
|
| 53 | 0.04 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "8949" "en_US" "App\Entity\Product" ] |
| 54 | 0.05 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
8998
]
|
| 55 | 0.04 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "8998" "en_US" "App\Entity\Product" ] |
| 56 | 0.05 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
2
]
|
| 57 | 0.05 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
8999
]
|
| 58 | 0.04 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "8999" "en_US" "App\Entity\Product" ] |
| 59 | 0.05 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
9001
]
|
| 60 | 0.04 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "9001" "en_US" "App\Entity\Product" ] |
| 61 | 0.04 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
9345
]
|
| 62 | 0.05 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "9345" "en_US" "App\Entity\Product" ] |
| 63 | 0.05 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
8963
]
|
| 64 | 0.05 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "8963" "en_US" "App\Entity\Product" ] |
| 65 | 0.05 ms |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 8949 8998 8999 9001 9345 8963 ] |
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. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| App\Entity\ModuleTranslation | No errors. |
| App\Entity\WireFrame | No errors. |
dynamic_em entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\PriceLevel | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| App\Entity\PriceLevelTranslation | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Price | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\ProductGroup | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\ProductTranslation | No errors. |
| App\Entity\ProductParameter | No errors. |
| App\Entity\ProductParameterGroup | No errors. |
| App\Entity\ProductParameterTranslation | No errors. |
| App\Entity\PackagePrice | No errors. |
| App\Entity\Eshop | No errors. |
| App\Entity\WebPage | No errors. |
| App\Entity\WebPageTranslation | No errors. |
| App\Entity\CategoryTranslation | No errors. |
| App\Entity\ProductParameterValue | No errors. |
| App\Entity\OrderItem | No errors. |
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.