https://furbify-staging.lacne-pc.sk/bazar

Query Metrics

193 Database Queries
34 Different statements
463.75 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
205.71 ms
(44.36%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[
  "product_id=69110"
  1
  0
]
139.39 ms
(30.06%)
1
SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.updated AS updated_2, p0_.updated_by_time AS updated_by_time_3, p0_.omega_plu AS omega_plu_4, p0_.code AS code_5, p0_.name AS name_6, p0_.warranty AS warranty_7, p0_.part_number AS part_number_8, p0_.ean AS ean_9, p0_.gtin AS gtin_10, p0_.amazon_code AS amazon_code_11, p0_.length AS length_12, p0_.width AS width_13, p0_.height AS height_14, p0_.weight AS weight_15, p0_.unit AS unit_16, p0_.badges AS badges_17, p0_.detail AS detail_18, p0_.stock_position AS stock_position_19, p0_.out_of_stock_status AS out_of_stock_status_20, p0_.quality_status AS quality_status_21, p0_.sold_out_date AS sold_out_date_22, p0_.cache_description AS cache_description_23, p0_.cache_item_last_updated AS cache_item_last_updated_24, p0_.available AS available_25, p0_.in_stock AS in_stock_26, p0_.archived AS archived_27, p0_.scannable AS scannable_28, p0_.last_price AS last_price_29, p0_.avg_price AS avg_price_30, p0_.container AS container_31, p0_.last_sale AS last_sale_32, p0_.cpu_mark AS cpu_mark_33, p0_.spare_part_card AS spare_part_card_34, p0_.spare_part_price AS spare_part_price_35, p0_.sold_during_time_frame AS sold_during_time_frame_36, p0_.spare_part_created AS spare_part_created_37, p0_.spare_part_updated AS spare_part_updated_38, p0_.margin_level AS margin_level_39, p0_.quantity_limit AS quantity_limit_40, p0_.availability_paused_for_product_model AS availability_paused_for_product_model_41, p0_.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_42, p0_.calculated_qty_grade_new AS calculated_qty_grade_new_43, p0_.calculated_qty_grade_a AS calculated_qty_grade_a_44, p0_.calculated_qty_grade_b AS calculated_qty_grade_b_45, p0_.calculated_qty_grade_c AS calculated_qty_grade_c_46, p0_.calculated_qty_grade_d AS calculated_qty_grade_d_47, p0_.calculated_qty_date AS calculated_qty_date_48, p0_.created_by AS created_by_49, p0_.updated_by AS updated_by_50, p0_.vendor_id AS vendor_id_51, p0_.type_id AS type_id_52, p0_.photo_album_id AS photo_album_id_53, p0_.current_alternative_product_id AS current_alternative_product_id_54, p0_.product_model_id AS product_model_id_55, p0_.spare_part_created_by AS spare_part_created_by_56, p0_.spare_part_updated_by AS spare_part_updated_by_57, p0_.fixed_attribute_option_combination_id AS fixed_attribute_option_combination_id_58 FROM products p0_ LEFT JOIN products__metas p1_ ON (p1_.id = (SELECT p2_.id FROM products__metas p2_ WHERE p2_.product_id = p0_.id AND p2_.domain_id = 1)) WHERE p0_.type_id = 52 AND p1_.active = 1 AND p0_.available > 0 AND p1_.orderable = 1 AND p1_.listed = 1 AND p0_.quality_status = 9 ORDER BY p1_.current_vat_price ASC, p0_.updated DESC LIMIT 1
Parameters:
[]
31.90 ms
(6.88%)
9
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = ?
Parameters:
[
  1
]
13.79 ms
(2.97%)
50
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.title AS title_5, t0.long_title AS long_title_6, t0.private AS private_7, t0.in_short_desc AS in_short_desc_8, t0.archived AS archived_9, t0.sort_index AS sort_index_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.attribute_id AS attribute_id_13, t0.parent_id AS parent_id_14, t0.product_id AS product_id_15 FROM attribute_options t0 WHERE t0.id = ?
Parameters:
[
  117
]
10.93 ms
(2.36%)
13
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[
  "category_id=5"
  1
  1
  0
]
10.40 ms
(2.24%)
28
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
7.53 ms
(1.62%)
27
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.type AS type_5, t0.title AS title_6, t0.help_file AS help_file_7, t0.sort_index AS sort_index_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  5
]
6.56 ms
(1.41%)
1
SELECT DISTINCT r0_.id AS id_0, r0_.created AS created_1, r0_.updated AS updated_2, r0_.updated_by_time AS updated_by_time_3, r0_.type AS type_4, r0_.name AS name_5, r0_.text AS text_6, r0_.stars AS stars_7, r0_.approved AS approved_8, r0_.show_at_homepage AS show_at_homepage_9, r0_.created_by AS created_by_10, r0_.updated_by AS updated_by_11, r0_.language_id AS language_id_12, r0_.product_id AS product_id_13, r0_.customer_id AS customer_id_14, r0_.order_id AS order_id_15 FROM reviews r0_ LEFT JOIN review_survey_media r1_ ON r0_.id = r1_.review_id WHERE r0_.language_id IN (?, ?) AND r0_.type = ? AND r0_.approved = ? AND r1_.id IS NOT NULL AND r1_.approved = 1 AND r0_.show_at_homepage = 1 ORDER BY r0_.created DESC LIMIT 5
Parameters:
[
  1
  3
  2
  1
]
4.41 ms
(0.95%)
1
SELECT r0_.id AS id_0, r0_.created AS created_1, r0_.updated AS updated_2, r0_.updated_by_time AS updated_by_time_3, r0_.type AS type_4, r0_.name AS name_5, r0_.text AS text_6, r0_.stars AS stars_7, r0_.approved AS approved_8, r0_.show_at_homepage AS show_at_homepage_9, r0_.created_by AS created_by_10, r0_.updated_by AS updated_by_11, r0_.language_id AS language_id_12, r0_.product_id AS product_id_13, r0_.customer_id AS customer_id_14, r0_.order_id AS order_id_15 FROM reviews r0_ LEFT JOIN products p1_ ON r0_.product_id = p1_.id WHERE r0_.type = ? AND p1_.name = ? AND r0_.language_id IN (?, ?) AND r0_.approved = 1 ORDER BY r0_.created DESC
Parameters:
[
  2
  "ThinkPad X1 Yoga Gen 6 (32GB) (Touchscreen) (Quality: Bazár)"
  1
  3
]
4.37 ms
(0.94%)
2
SELECT COUNT(r0_.id) AS sclr_0 FROM reviews r0_ WHERE r0_.language_id IN (?, ?) AND r0_.type = ? AND r0_.approved = ?
Parameters:
[
  1
  3
  2
  1
]
3.49 ms
(0.75%)
1
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.updated AS updated_2, c0_.updated_by_time AS updated_by_time_3, c0_.code AS code_4, c0_.enabled AS enabled_5, c0_.description AS description_6, c0_.valid_form AS valid_form_7, c0_.valid_to AS valid_to_8, c0_.discount_type AS discount_type_9, c0_.discount AS discount_10, c0_.total AS total_11, c0_.available_for_discounted_products AS available_for_discounted_products_12, c0_.only_once_use AS only_once_use_13, c0_.only_once_customer_use AS only_once_customer_use_14, c0_.free_shipping AS free_shipping_15, c0_.product_tags AS product_tags_16, c0_.show_badge_on_website AS show_badge_on_website_17, c0_.created_by AS created_by_18, c0_.updated_by AS updated_by_19, c0_.domain_id AS domain_id_20 FROM coupons c0_ INNER JOIN coupons__product_types c2_ ON c0_.id = c2_.coupon_id INNER JOIN product_types p1_ ON p1_.id = c2_.product_type_id WHERE c0_.show_badge_on_website = 1 AND c0_.domain_id = ? AND ((c0_.valid_form IS NULL OR c0_.valid_form < ?)) AND ((c0_.valid_to IS NULL OR c0_.valid_to > ?)) AND p1_.id IN (?)
Parameters:
[
  1
  "2026-10-10 03:06:24"
  "2026-10-10 03:06:24"
  52
]
2.27 ms
(0.49%)
5
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.status AS status_5, t0.payment_status AS payment_status_6, t0.invoice_code AS invoice_code_7, t0.payment_type AS payment_type_8, t0.payment_price AS payment_price_9, t0.shipping_type AS shipping_type_10, t0.shipping_price AS shipping_price_11, t0.billing_first_name AS billing_first_name_12, t0.billing_last_name AS billing_last_name_13, t0.billing_business_name AS billing_business_name_14, t0.billing_street AS billing_street_15, t0.billing_city AS billing_city_16, t0.billing_zip AS billing_zip_17, t0.billing_country AS billing_country_18, t0.billing_business_id AS billing_business_id_19, t0.billing_tax_id AS billing_tax_id_20, t0.billing_vat_id AS billing_vat_id_21, t0.billing_email AS billing_email_22, t0.billing_phone_number AS billing_phone_number_23, t0.shipping_first_name AS shipping_first_name_24, t0.shipping_last_name AS shipping_last_name_25, t0.shipping_business_name AS shipping_business_name_26, t0.shipping_street AS shipping_street_27, t0.shipping_city AS shipping_city_28, t0.shipping_zip AS shipping_zip_29, t0.shipping_country AS shipping_country_30, t0.shipping_email AS shipping_email_31, t0.shipping_phone_number AS shipping_phone_number_32, t0.message AS message_33, t0.coupon_code AS coupon_code_34, t0.ship_date AS ship_date_35, t0.planned_ship_date AS planned_ship_date_36, t0.delivery_date AS delivery_date_37, t0.box_count AS box_count_38, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_39, t0.full_price AS full_price_40, t0.presta_order_code AS presta_order_code_41, t0.external_order_source AS external_order_source_42, t0.external_order_code AS external_order_code_43, t0.message_done AS message_done_44, t0.message_done_time AS message_done_time_45, t0.force_free_shipping AS force_free_shipping_46, t0.warranty AS warranty_47, t0.created_by_type AS created_by_type_48, t0.archived AS archived_49, t0.discount AS discount_50, t0.tracking_url AS tracking_url_51, t0.parcelNumber AS parcelNumber_52, t0.dhlShipmentNumber AS dhlShipmentNumber_53, t0.parcelStatus AS parcelStatus_54, t0.priority AS priority_55, t0.base_order_id AS base_order_id_56, t0.vat AS vat_57, t0.created_by AS created_by_58, t0.updated_by AS updated_by_59, t0.domain_id AS domain_id_60, t0.customer_id AS customer_id_61, t0.message_done_by AS message_done_by_62 FROM orders t0 WHERE t0.id = ?
Parameters:
[
  202464144
]
2.26 ms
(0.49%)
7
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ?
Parameters:
[
  2
]
2.04 ms
(0.44%)
7
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.tr_key AS tr_key_4, t0.value AS value_5, t0.language_id AS language_id_6 FROM translations t0 WHERE t0.language_id = ? AND t0.tr_key = ?
Parameters:
[
  1
  "i7-1165G7"
]
1.95 ms
(0.42%)
2
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.active AS active_5, t0.type_id AS type_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.domain_id AS domain_id_9 FROM category_group t0 WHERE t0.type_id = ? AND t0.domain_id = ? AND t0.active = ? LIMIT 1
Parameters:
[
  3
  1
  1
]
1.92 ms
(0.41%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.original_name AS original_name_5, t0.cloudflare_id AS cloudflare_id_6, t0.context_array AS context_array_7, t0.salt AS salt_8, t0.mime_type AS mime_type_9, t0.album_id AS album_id_10 FROM photos t0 WHERE t0.album_id = ? ORDER BY t0.sort_index ASC
Parameters:
[
  73314
]
1.56 ms
(0.34%)
5
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.approved AS approved_5, t0.cloudflare_id AS cloudflare_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.review_id AS review_id_9, t0.survey_media_id AS survey_media_id_10 FROM review_survey_media t0 WHERE t0.review_id = ?
Parameters:
[
  7949
]
1.42 ms
(0.31%)
5
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.directory AS directory_4, t0.filename AS filename_5, t0.mime_type AS mime_type_6, t0.survey_question_id AS survey_question_id_7, t0.order_id AS order_id_8, t0.domain_id AS domain_id_9 FROM survey_medias t0 WHERE t0.id = ?
Parameters:
[
  3062
]
1.38 ms
(0.30%)
2
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.type AS type_5, t0.title AS title_6, t0.sub_title AS sub_title_7, t0.icon AS icon_8, t0.route AS route_9, t0.query AS query_10, t0.mobile AS mobile_11, t0.desktop AS desktop_12, t0.label_id AS label_id_13, t0.sort_index AS sort_index_14, t0.bazaar AS bazaar_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.domain_id AS domain_id_18, t0.parent_id AS parent_id_19, t0.category_page_id AS category_page_id_20 FROM domain_navigation t0 WHERE t0.domain_id = ? AND t0.parent_id IS NULL AND t0.bazaar = ? ORDER BY t0.sort_index ASC
Parameters:
[
  1
  1
]
1.31 ms
(0.28%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.used AS used_4, t0.multiplier AS multiplier_5, t0.always AS always_6, t0.product_id AS product_id_7, t0.option_id AS option_id_8 FROM products__attributes t0 WHERE t0.product_id = ?
Parameters:
[
  69110
]
1.27 ms
(0.27%)
3
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.count_down AS count_down_5, t0.type AS type_6, t0.display_type AS display_type_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.domain_id AS domain_id_10 FROM banners t0 WHERE t0.domain_id = ? AND t0.type = ? LIMIT 1
Parameters:
[
  1
  4
]
1.11 ms
(0.24%)
3
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.type AS type_8, t0.badges AS badges_9, t0.show_only_discounted AS show_only_discounted_10, t0.show_only_flash_sales AS show_only_flash_sales_11, t0.show_only_bazaar AS show_only_bazaar_12, t0.include_bazaar AS include_bazaar_13, t0.show_popular_products AS show_popular_products_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.domain_id AS domain_id_17, t0.parent_category_id AS parent_category_id_18 FROM pages_category t0 WHERE t0.id = ?
Parameters:
[
  5
]
1.01 ms
(0.22%)
4
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.type AS type_5, t0.title AS title_6, t0.sub_title AS sub_title_7, t0.icon AS icon_8, t0.route AS route_9, t0.query AS query_10, t0.mobile AS mobile_11, t0.desktop AS desktop_12, t0.label_id AS label_id_13, t0.sort_index AS sort_index_14, t0.bazaar AS bazaar_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.domain_id AS domain_id_18, t0.parent_id AS parent_id_19, t0.category_page_id AS category_page_id_20 FROM domain_navigation t0 WHERE t0.parent_id = ? ORDER BY t0.sort_index ASC
Parameters:
[
  13
]
0.92 ms
(0.20%)
2
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[]
0.92 ms
(0.20%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.sort_index AS sort_index_5, t0.title AS title_6, t0.description AS description_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.group_id AS group_id_10, t0.product_id AS product_id_11 FROM product_group_member t0 WHERE t0.group_id = ?
Parameters:
[
  71
]
0.67 ms
(0.15%)
3
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.57 ms
(0.12%)
1
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.updated_by_time AS updated_by_time_3, d0_.type AS type_4, d0_.price AS price_5, d0_.free_ship_limit AS free_ship_limit_6, d0_.active_on_web AS active_on_web_7, d0_.sort_index AS sort_index_8, d0_.shipping_days AS shipping_days_9, d0_.free_shipping_product_types AS free_shipping_product_types_10, d0_.free_shipping_start_date AS free_shipping_start_date_11, d0_.free_shipping_end_date AS free_shipping_end_date_12, d0_.created_by AS created_by_13, d0_.updated_by AS updated_by_14, d0_.domain_id AS domain_id_15 FROM domain_shipping_types d0_ WHERE d0_.domain_id = ? AND d0_.active_on_web = 1 AND d0_.price > 0
Parameters:
[
  1
]
0.50 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.title AS title_5, t0.products_to_display AS products_to_display_6, t0.only_flash_sales AS only_flash_sales_7, t0.show_random AS show_random_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.domain_id AS domain_id_11 FROM product_group t0 WHERE t0.title = ? AND t0.domain_id = ? LIMIT 1
Parameters:
[
  "homepage.bazaar.main"
  1
]
0.47 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.payment_method AS payment_method_4, t0.shipping_method AS shipping_method_5, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_6, t0.message AS message_7, t0.coupon_code AS coupon_code_8, t0.active AS active_9, t0.abandoned_cart_email AS abandoned_cart_email_10, t0.domain_id AS domain_id_11, t0.customer_id AS customer_id_12, t0.billing_address_id AS billing_address_id_13, t0.shipping_address_id AS shipping_address_id_14 FROM baskets t0 WHERE t0.id IS NULL AND t0.active = ? LIMIT 1
Parameters:
[
  1
]
0.45 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.price AS price_4, t0.suggested_price AS suggested_price_5, t0.current_vat_price AS current_vat_price_6, t0.discount AS discount_7, t0.discounted AS discounted_8, t0.active AS active_9, t0.listed AS listed_10, t0.orderable AS orderable_11, t0.vat AS vat_12, t0.warranty AS warranty_13, t0.bazaar AS bazaar_14, t0.best_seller AS best_seller_15, t0.re_lenovo AS re_lenovo_16, t0.hp_renew AS hp_renew_17, t0.special_promotion AS special_promotion_18, t0.detail AS detail_19, t0.sale_start AS sale_start_20, t0.sale_end AS sale_end_21, t0.activation_date AS activation_date_22, t0.discounted_date AS discounted_date_23, t0.flash_sale_date AS flash_sale_date_24, t0.domain_id AS domain_id_25, t0.product_id AS product_id_26 FROM products__metas t0 WHERE t0.product_id = ?
Parameters:
[
  69110
]
0.45 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.original_name AS original_name_5, t0.filename AS filename_6, t0.link AS link_7, t0.startDate AS startDate_8, t0.endDate AS endDate_9, t0.salt AS salt_10, t0.mime_type AS mime_type_11, t0.banner_id AS banner_id_12 FROM banner_items t0 WHERE t0.banner_id = ? ORDER BY t0.created DESC
Parameters:
[
  214
]
0.40 ms
(0.09%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.name AS name_5, t0.priority AS priority_6, t0.base_manufacturer_id AS base_manufacturer_id_7 FROM vendors t0 WHERE t0.id = ?
Parameters:
[
  32
]
0.23 ms
(0.05%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.title AS title_5, t0.code AS code_6, t0.scannable AS scannable_7, t0.priority AS priority_8, t0.average_weight AS average_weight_9, t0.archived AS archived_10 FROM product_types t0 WHERE t0.id = ?
Parameters:
[
  52
]
0.20 ms
(0.04%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3 FROM albums t0 WHERE t0.id = ?
Parameters:
[
  73314
]

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
App\AtechNet\CoreBundle\Entity\AbstractEntity No errors.
App\AtechNet\CoreBundle\Entity\AbstractSortableEntity No errors.
App\AtechNet\CoreBundle\Entity\Domain No errors.
App\AtechNet\CoreBundle\Entity\Language No errors.
App\AtechNet\CoreBundle\Entity\Translation No errors.
App\AtechNet\CoreBundle\Entity\Company No errors.
App\AtechNet\CoreBundle\Entity\AbstractSignedEntity No errors.
App\AtechNet\CoreBundle\Entity\User No errors.
App\AtechNet\CoreBundle\Entity\Customer No errors.
App\AtechNet\CoreBundle\Entity\DomainShippingType No errors.
App\AtechNet\CoreBundle\Entity\DomainPaymentType No errors.
App\AtechNet\CoreBundle\Entity\Order No errors.
App\AtechNet\CoreBundle\Entity\DocumentGroup No errors.
App\AtechNet\CoreBundle\Entity\Banner No errors.
App\AtechNet\CoreBundle\Entity\Nanobar No errors.
App\AtechNet\CoreBundle\Entity\Country No errors.
App\AtechNet\CoreBundle\Entity\AbstractFile No errors.
App\AtechNet\CoreBundle\Entity\BannerItem No errors.
App\AtechNet\CoreBundle\Entity\ProductGroup No errors.
App\AtechNet\CoreBundle\Entity\ProductGroupMember No errors.
App\AtechNet\CoreBundle\Entity\Product No errors.
App\AtechNet\CoreBundle\Entity\ProductMeta No errors.
App\AtechNet\CoreBundle\Entity\Vendor No errors.
App\AtechNet\CoreBundle\Entity\ProductType No errors.
App\AtechNet\CoreBundle\Entity\Album No errors.
App\AtechNet\CoreBundle\Entity\ProductModel No errors.
App\AtechNet\CoreBundle\Entity\FixedAttributeOptionCombination No errors.
App\AtechNet\CoreBundle\Entity\ProductAttribute No errors.
App\AtechNet\CoreBundle\Entity\ProductContainer No errors.
App\AtechNet\CoreBundle\Entity\ProductCommission No errors.
App\AtechNet\CoreBundle\Entity\OrderItem No errors.
App\AtechNet\CoreBundle\Entity\StockMovementItem No errors.
App\AtechNet\CoreBundle\Entity\AbstractPage No errors.
App\AtechNet\CoreBundle\Entity\CategoryPage No errors.
App\AtechNet\CoreBundle\Entity\ProductTag No errors.
App\AtechNet\CoreBundle\Entity\CustomerNotification No errors.
App\AtechNet\CoreBundle\Entity\ProductPriceLog No errors.
App\AtechNet\CoreBundle\Entity\ProductExternalFeedName No errors.
App\AtechNet\CoreBundle\Entity\Coupon No errors.
App\AtechNet\CoreBundle\Entity\ProductVariation No errors.
App\AtechNet\CoreBundle\Entity\CustomerClaimProduct No errors.
App\AtechNet\CoreBundle\Entity\AttributeOption No errors.
App\AtechNet\CoreBundle\Entity\Attribute No errors.
App\AtechNet\CoreBundle\Entity\AttributeOptionMeta No errors.
App\AtechNet\CoreBundle\Entity\AttributeMeta No errors.
App\AtechNet\CoreBundle\Entity\CategoryPageFilterAttribute No errors.
App\AtechNet\CoreBundle\Entity\Photo No errors.
App\AtechNet\CoreBundle\Entity\Review No errors.
App\AtechNet\CoreBundle\Entity\VendorMeta No errors.
App\AtechNet\CoreBundle\Entity\StockReview No errors.
App\AtechNet\CoreBundle\Entity\ProductTypeMeta No errors.
App\AtechNet\CoreBundle\Entity\SeoUrl No errors.
App\AtechNet\CoreBundle\Entity\CategoryGroup No errors.
App\AtechNet\CoreBundle\Entity\DomainNavigation No errors.
App\AtechNet\CoreBundle\Entity\PageMeta No errors.
App\AtechNet\CoreBundle\Entity\CategoryPagesPriorityProducts No errors.
App\AtechNet\CoreBundle\Entity\Basket No errors.
App\AtechNet\CoreBundle\Entity\CustomerAddress No errors.
App\AtechNet\CoreBundle\Entity\ReviewSurveyMedia No errors.
App\AtechNet\CoreBundle\Entity\SurveyMedia No errors.
App\AtechNet\CoreBundle\Entity\SurveyQuestion No errors.
App\AtechNet\CoreBundle\Entity\CustomerBillingoData No errors.
App\AtechNet\CoreBundle\Entity\Document No errors.
App\AtechNet\CoreBundle\Entity\StockMovement No errors.
App\AtechNet\CoreBundle\Entity\OrderComment No errors.
App\AtechNet\CoreBundle\Entity\OrderSetting No errors.
App\AtechNet\CoreBundle\Entity\OrderPackage No errors.
App\AtechNet\CoreBundle\Entity\Claim No errors.