Query Metrics
126
Database Queries
33
Different statements
1682.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
363.60 ms (21.61%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN products__metas p1_ ON p0_.id = p1_.product_id LEFT JOIN vendors v2_ ON p0_.vendor_id = v2_.id LEFT JOIN product_types p3_ ON p0_.type_id = p3_.id LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_product_types c6_ ON p4_.id = c6_.product_type_id LEFT JOIN pages_category p5_ ON p5_.id = c6_.category_page_id AND (p5_.id = ?) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p7_ ON p7_.id = c8_.category_page_id AND (p7_.id = ?) WHERE (p7_.id = ? OR p5_.id IS NOT NULL) AND p0_.quality_status <> ? AND p1_.domain_id = ? AND p1_.price > 0 AND p0_.archived = 0 AND p1_.active = ? AND p1_.listed = ? AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4))
Parameters:
[ 93 93 93 9 1 1 1 ] |
|
362.02 ms (21.51%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, available_25 FROM (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, p1_.id AS id_49, p1_.created AS created_50, p1_.updated AS updated_51, p1_.updated_by_time AS updated_by_time_52, p1_.published AS published_53, p1_.indexable AS indexable_54, p1_.social_share_image AS social_share_image_55, p1_.type AS type_56, p1_.badges AS badges_57, p1_.show_only_discounted AS show_only_discounted_58, p1_.show_only_flash_sales AS show_only_flash_sales_59, p1_.show_only_bazaar AS show_only_bazaar_60, p1_.include_bazaar AS include_bazaar_61, p1_.show_popular_products AS show_popular_products_62, p2_.id AS id_63, p2_.created AS created_64, p2_.updated AS updated_65, p2_.updated_by_time AS updated_by_time_66, p2_.published AS published_67, p2_.indexable AS indexable_68, p2_.social_share_image AS social_share_image_69, p2_.type AS type_70, p2_.badges AS badges_71, p2_.show_only_discounted AS show_only_discounted_72, p2_.show_only_flash_sales AS show_only_flash_sales_73, p2_.show_only_bazaar AS show_only_bazaar_74, p2_.include_bazaar AS include_bazaar_75, p2_.show_popular_products AS show_popular_products_76, p3_.id AS id_77, p3_.created AS created_78, p3_.updated AS updated_79, p3_.price AS price_80, p3_.suggested_price AS suggested_price_81, p3_.current_vat_price AS current_vat_price_82, p3_.discount AS discount_83, p3_.discounted AS discounted_84, p3_.active AS active_85, p3_.listed AS listed_86, p3_.orderable AS orderable_87, p3_.vat AS vat_88, p3_.warranty AS warranty_89, p3_.bazaar AS bazaar_90, p3_.best_seller AS best_seller_91, p3_.re_lenovo AS re_lenovo_92, p3_.hp_renew AS hp_renew_93, p3_.special_promotion AS special_promotion_94, p3_.detail AS detail_95, p3_.sale_start AS sale_start_96, p3_.sale_end AS sale_end_97, p3_.activation_date AS activation_date_98, p3_.discounted_date AS discounted_date_99, p3_.flash_sale_date AS flash_sale_date_100 FROM products p0_ LEFT JOIN products__metas p3_ ON p0_.id = p3_.product_id LEFT JOIN vendors v4_ ON p0_.vendor_id = v4_.id LEFT JOIN product_types p5_ ON p0_.type_id = p5_.id LEFT JOIN product_types p6_ ON p0_.type_id = p6_.id LEFT JOIN category_pages_product_types c7_ ON p6_.id = c7_.product_type_id LEFT JOIN pages_category p1_ ON p1_.id = c7_.category_page_id AND (p1_.id = ?) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p2_ ON p2_.id = c8_.category_page_id AND (p2_.id = ?) WHERE (p2_.id = ? OR p1_.id IS NOT NULL) AND p0_.quality_status <> ? AND p3_.domain_id = ? AND p3_.price > 0 AND p0_.archived = 0 AND p3_.active = ? AND p3_.listed = ? AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4)) AND p3_.orderable = ? ORDER BY p1_.id DESC, p2_.id DESC) dctrn_result_inner ORDER BY available_25 DESC) dctrn_result LIMIT 3
Parameters:
[ 93 93 93 9 1 1 1 1 ] |
|
315.38 ms (18.74%) |
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 p0_.id = p1_.product_id LEFT JOIN vendors v2_ ON p0_.vendor_id = v2_.id LEFT JOIN product_types p3_ ON p0_.type_id = p3_.id LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_product_types c6_ ON p4_.id = c6_.product_type_id LEFT JOIN pages_category p5_ ON p5_.id = c6_.category_page_id AND (p5_.id = ?) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p7_ ON p7_.id = c8_.category_page_id AND (p7_.id = ?) WHERE (p7_.id = ? OR p5_.id IS NOT NULL) AND p0_.quality_status <> ? AND p1_.domain_id = ? AND p1_.price > 0 AND p0_.archived = 0 AND p1_.active = ? AND p1_.listed = ? AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4))
Parameters:
[ 93 93 93 9 1 1 1 ] |
|
305.45 ms (18.15%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, available_25 FROM (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, p1_.id AS id_49, p1_.created AS created_50, p1_.updated AS updated_51, p1_.updated_by_time AS updated_by_time_52, p1_.published AS published_53, p1_.indexable AS indexable_54, p1_.social_share_image AS social_share_image_55, p1_.type AS type_56, p1_.badges AS badges_57, p1_.show_only_discounted AS show_only_discounted_58, p1_.show_only_flash_sales AS show_only_flash_sales_59, p1_.show_only_bazaar AS show_only_bazaar_60, p1_.include_bazaar AS include_bazaar_61, p1_.show_popular_products AS show_popular_products_62, p2_.id AS id_63, p2_.created AS created_64, p2_.updated AS updated_65, p2_.updated_by_time AS updated_by_time_66, p2_.published AS published_67, p2_.indexable AS indexable_68, p2_.social_share_image AS social_share_image_69, p2_.type AS type_70, p2_.badges AS badges_71, p2_.show_only_discounted AS show_only_discounted_72, p2_.show_only_flash_sales AS show_only_flash_sales_73, p2_.show_only_bazaar AS show_only_bazaar_74, p2_.include_bazaar AS include_bazaar_75, p2_.show_popular_products AS show_popular_products_76, p3_.id AS id_77, p3_.created AS created_78, p3_.updated AS updated_79, p3_.price AS price_80, p3_.suggested_price AS suggested_price_81, p3_.current_vat_price AS current_vat_price_82, p3_.discount AS discount_83, p3_.discounted AS discounted_84, p3_.active AS active_85, p3_.listed AS listed_86, p3_.orderable AS orderable_87, p3_.vat AS vat_88, p3_.warranty AS warranty_89, p3_.bazaar AS bazaar_90, p3_.best_seller AS best_seller_91, p3_.re_lenovo AS re_lenovo_92, p3_.hp_renew AS hp_renew_93, p3_.special_promotion AS special_promotion_94, p3_.detail AS detail_95, p3_.sale_start AS sale_start_96, p3_.sale_end AS sale_end_97, p3_.activation_date AS activation_date_98, p3_.discounted_date AS discounted_date_99, p3_.flash_sale_date AS flash_sale_date_100 FROM products p0_ LEFT JOIN products__metas p3_ ON p0_.id = p3_.product_id LEFT JOIN vendors v4_ ON p0_.vendor_id = v4_.id LEFT JOIN product_types p5_ ON p0_.type_id = p5_.id LEFT JOIN product_types p6_ ON p0_.type_id = p6_.id LEFT JOIN category_pages_product_types c7_ ON p6_.id = c7_.product_type_id LEFT JOIN pages_category p1_ ON p1_.id = c7_.category_page_id AND (p1_.id = ?) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p2_ ON p2_.id = c8_.category_page_id AND (p2_.id = ?) WHERE (p2_.id = ? OR p1_.id IS NOT NULL) AND p3_.discounted = ? AND p0_.quality_status <> ? AND p3_.domain_id = ? AND p3_.price > 0 AND p0_.archived = 0 AND p3_.active = ? AND p3_.listed = ? AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4)) AND p3_.orderable = ? ORDER BY p1_.id DESC, p2_.id DESC) dctrn_result_inner ORDER BY available_25 DESC) dctrn_result LIMIT 3
Parameters:
[ 93 93 93 1 9 1 1 1 1 ] |
|
226.55 ms (13.46%) |
2 |
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:
[ "category_id=" 1 0 ] |
|
27.12 ms (1.61%) |
8 |
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
]
|
|
21.03 ms (1.25%) |
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 "HDMI kábel 10m" 1 3 ] |
|
16.53 ms (0.98%) |
46 |
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
]
|
|
14.82 ms (0.88%) |
19 |
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=93" 1 1 0 ] |
|
11.95 ms (0.71%) |
2 |
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.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "interaktivna-technika" 1 0 1 null ] |
|
1.95 ms (0.12%) |
7 |
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 = ? LIMIT 1
Parameters:
[
93
]
|
|
1.74 ms (0.10%) |
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
]
|
|
1.54 ms (0.09%) |
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 "Categories" ] |
|
1.52 ms (0.09%) |
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.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.type = ? AND t0.published = ? AND t0.show_only_discounted = ? AND t0.show_only_flash_sales = ? AND t0.show_only_bazaar = ? AND t0.include_bazaar = ? ORDER BY t0.updated DESC
Parameters:
[ 1 1 0 0 0 0 ] |
|
1.26 ms (0.07%) |
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 p0_.id = p1_.product_id LEFT JOIN vendors v2_ ON p0_.vendor_id = v2_.id LEFT JOIN product_types p3_ ON p0_.type_id = p3_.id LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_product_types c6_ ON p4_.id = c6_.product_type_id LEFT JOIN pages_category p5_ ON p5_.id = c6_.category_page_id AND (p5_.id = ?) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p7_ ON p7_.id = c8_.category_page_id AND (p7_.id = ?) WHERE (p7_.id = ? OR p5_.id IS NOT NULL) AND p0_.quality_status <> ? AND p1_.domain_id = ? AND p1_.price > 0 AND p0_.archived = 0 AND p1_.active = ? AND p1_.listed = ? AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4)) AND p1_.orderable = ? AND p0_.id IN (?) ORDER BY p0_.available DESC
Parameters:
[ 93 93 93 9 1 1 1 1 9311 ] |
|
1.13 ms (0.07%) |
1 |
SELECT t0.delta AS delta_1, t0.category_page_id AS category_page_id_2, t0.attribute_id AS attribute_id_3 FROM category_pages_filter_attributes t0 WHERE t0.category_page_id = ? ORDER BY t0.delta ASC
Parameters:
[
93
]
|
|
0.95 ms (0.06%) |
2 |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
|
0.90 ms (0.05%) |
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.omega_plu AS omega_plu_5, t0.code AS code_6, t0.name AS name_7, t0.warranty AS warranty_8, t0.part_number AS part_number_9, t0.ean AS ean_10, t0.gtin AS gtin_11, t0.amazon_code AS amazon_code_12, t0.length AS length_13, t0.width AS width_14, t0.height AS height_15, t0.weight AS weight_16, t0.unit AS unit_17, t0.badges AS badges_18, t0.detail AS detail_19, t0.stock_position AS stock_position_20, t0.out_of_stock_status AS out_of_stock_status_21, t0.quality_status AS quality_status_22, t0.sold_out_date AS sold_out_date_23, t0.cache_description AS cache_description_24, t0.cache_item_last_updated AS cache_item_last_updated_25, t0.available AS available_26, t0.in_stock AS in_stock_27, t0.archived AS archived_28, t0.scannable AS scannable_29, t0.last_price AS last_price_30, t0.avg_price AS avg_price_31, t0.container AS container_32, t0.last_sale AS last_sale_33, t0.cpu_mark AS cpu_mark_34, t0.spare_part_card AS spare_part_card_35, t0.spare_part_price AS spare_part_price_36, t0.sold_during_time_frame AS sold_during_time_frame_37, t0.spare_part_created AS spare_part_created_38, t0.spare_part_updated AS spare_part_updated_39, t0.margin_level AS margin_level_40, t0.quantity_limit AS quantity_limit_41, t0.availability_paused_for_product_model AS availability_paused_for_product_model_42, t0.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_43, t0.calculated_qty_grade_new AS calculated_qty_grade_new_44, t0.calculated_qty_grade_a AS calculated_qty_grade_a_45, t0.calculated_qty_grade_b AS calculated_qty_grade_b_46, t0.calculated_qty_grade_c AS calculated_qty_grade_c_47, t0.calculated_qty_grade_d AS calculated_qty_grade_d_48, t0.calculated_qty_date AS calculated_qty_date_49, t0.created_by AS created_by_50, t0.updated_by AS updated_by_51, t0.vendor_id AS vendor_id_52, t0.type_id AS type_id_53, t0.photo_album_id AS photo_album_id_54, t0.current_alternative_product_id AS current_alternative_product_id_55, t0.product_model_id AS product_model_id_56, t0.spare_part_created_by AS spare_part_created_by_57, t0.spare_part_updated_by AS spare_part_updated_by_58, t0.fixed_attribute_option_combination_id AS fixed_attribute_option_combination_id_59 FROM products t0 INNER JOIN category_pages_popular_products ON t0.id = category_pages_popular_products.product_id WHERE category_pages_popular_products.category_page_id = ? ORDER BY t0.id DESC
Parameters:
[
93
]
|
|
0.86 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.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:
[
9336
]
|
|
0.82 ms (0.05%) |
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.link AS link_6, t0.content AS content_7, t0.short_desc AS short_desc_8, t0.seo_title AS seo_title_9, t0.seo_desc AS seo_desc_10, t0.extra_seo_desc AS extra_seo_desc_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.language_id AS language_id_14, t0.category_page_id AS category_page_id_15, t0.blog_category_id AS blog_category_id_16, t0.static_page_id AS static_page_id_17 FROM pages_meta t0 WHERE t0.category_page_id = ? ORDER BY t0.id ASC
Parameters:
[
93
]
|
|
0.79 ms (0.05%) |
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 07:51:44" "2026-10-10 07:51:44" 119 ] |
|
0.67 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:
[
9336
]
|
|
0.63 ms (0.04%) |
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.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"interaktivna-technika"
]
|
|
0.60 ms (0.04%) |
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.48 ms (0.03%) |
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.code AS code_5, t0.enabled AS enabled_6, t0.description AS description_7, t0.valid_form AS valid_form_8, t0.valid_to AS valid_to_9, t0.discount_type AS discount_type_10, t0.discount AS discount_11, t0.total AS total_12, t0.available_for_discounted_products AS available_for_discounted_products_13, t0.only_once_use AS only_once_use_14, t0.only_once_customer_use AS only_once_customer_use_15, t0.free_shipping AS free_shipping_16, t0.product_tags AS product_tags_17, t0.show_badge_on_website AS show_badge_on_website_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20, t0.domain_id AS domain_id_21 FROM coupons t0 INNER JOIN coupons__products ON t0.id = coupons__products.coupon_id WHERE coupons__products.product_id = ?
Parameters:
[
9311
]
|
|
0.43 ms (0.03%) |
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:
[
9311
]
|
|
0.32 ms (0.02%) |
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.username AS username_5, t0.password AS password_6, t0.salt AS salt_7, t0.email AS email_8, t0.roles AS roles_9, t0.is_active AS is_active_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.nick_name AS nick_name_13, t0.locale AS locale_14, t0.work_since AS work_since_15, t0.work_until AS work_until_16, t0.birthday AS birthday_17, t0.allowedDaysOff AS allowedDaysOff_18, t0.phone AS phone_19, t0.sales_manager AS sales_manager_20, t0.permissions AS permissions_21, t0.birthday_visibility AS birthday_visibility_22, t0.avatar AS avatar_23, t0.fingera_id AS fingera_id_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26, t27.id AS id_28, t27.created AS created_29, t27.updated AS updated_30, t27.updated_by_time AS updated_by_time_31, t27.created_by AS created_by_32, t27.updated_by AS updated_by_33, t27.user_id AS user_id_34, t27.stock_position_id AS stock_position_id_35 FROM users t0 LEFT JOIN users_stock_position t27 ON t27.user_id = t0.id WHERE t0.id = ?
Parameters:
[
68
]
|
|
0.31 ms (0.02%) |
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.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 = ? AND t0.published = ? AND t0.type = ? LIMIT 1
Parameters:
[ 93 1 1 ] |
|
0.31 ms (0.02%) |
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:
[
59
]
|
|
0.30 ms (0.02%) |
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 INNER JOIN category_pages_product_types ON t0.id = category_pages_product_types.product_type_id WHERE category_pages_product_types.category_page_id = ? ORDER BY t0.id DESC
Parameters:
[
93
]
|
|
0.27 ms (0.02%) |
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.24 ms (0.01%) |
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 INNER JOIN category_pages_vendors ON t0.id = category_pages_vendors.vendor_id WHERE category_pages_vendors.category_page_id = ? ORDER BY t0.id DESC
Parameters:
[
93
]
|
|
0.22 ms (0.01%) |
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
]
|
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.