Query Metrics
143
Database Queries
38
Different statements
1175.55 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.56 ms |
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:
[
"notebook-reproduktor-hp-for-spectre-13-x2-pro-pn-736899-001-2340abp002-2450094"
]
|
| 2 | 0.23 ms |
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
]
|
| 3 | 92.53 ms |
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:
[ "notebook-reproduktor-hp-for-spectre-13-x2-pro-pn-736899-001-2340abp002-2450094" 1 0 1 null ] |
| 4 | 2.65 ms |
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
]
|
| 5 | 0.47 ms |
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
]
|
| 6 | 0.24 ms |
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 | 3.78 ms |
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
]
|
| 8 | 0.31 ms |
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
]
|
| 9 | 0.52 ms |
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
42032
]
|
| 10 | 0.45 ms |
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:
[
42032
]
|
| 11 | 0.46 ms |
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
]
|
| 12 | 0.24 ms |
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:
[
4
]
|
| 13 | 0.25 ms |
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:
[
5
]
|
| 14 | 0.24 ms |
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:
[
7
]
|
| 15 | 0.34 ms |
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:
[
3
]
|
| 16 | 0.56 ms |
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:
[
9
]
|
| 17 | 0.25 ms |
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:
[
11
]
|
| 18 | 0.28 ms |
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:
[
42032
]
|
| 19 | 0.59 ms |
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:
[
743
]
|
| 20 | 0.29 ms |
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:
[
101
]
|
| 21 | 0.24 ms |
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:
[
3403
]
|
| 22 | 0.22 ms |
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:
[
242
]
|
| 23 | 0.37 ms |
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:
[
3411
]
|
| 24 | 0.27 ms |
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:
[
243
]
|
| 25 | 0.24 ms |
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 "HP" ] |
| 26 | 0.40 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3 FROM albums t0 WHERE t0.id = ?
Parameters:
[
43115
]
|
| 27 | 4.03 ms |
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 "for Spectre 13 x2 Pro (PN: 736899-001, 23.40ABP.002)" 1 3 ] |
| 28 | 0.46 ms |
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 INNER JOIN category_pages_products ON t0.id = category_pages_products.category_page_id WHERE category_pages_products.product_id = ? ORDER BY t0.id DESC
Parameters:
[
42032
]
|
| 29 | 1.23 ms |
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 14:34:31" "2026-10-10 14:34:31" 151 ] |
| 30 | 0.32 ms |
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:
[
42032
]
|
| 31 | 0.23 ms |
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:
[
28
]
|
| 32 | 0.28 ms |
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:
[
151
]
|
| 33 | 3.11 ms |
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_.published AS published_4, p0_.indexable AS indexable_5, p0_.social_share_image AS social_share_image_6, p0_.type AS type_7, p0_.badges AS badges_8, p0_.show_only_discounted AS show_only_discounted_9, p0_.show_only_flash_sales AS show_only_flash_sales_10, p0_.show_only_bazaar AS show_only_bazaar_11, p0_.include_bazaar AS include_bazaar_12, p0_.show_popular_products AS show_popular_products_13, p0_.created_by AS created_by_14, p0_.updated_by AS updated_by_15, p0_.domain_id AS domain_id_16, p0_.parent_category_id AS parent_category_id_17 FROM pages_category p0_ LEFT JOIN category_pages_product_types c2_ ON p0_.id = c2_.category_page_id LEFT JOIN product_types p1_ ON p1_.id = c2_.product_type_id LEFT JOIN category_pages_vendors c4_ ON p0_.id = c4_.category_page_id LEFT JOIN vendors v3_ ON v3_.id = c4_.vendor_id WHERE p1_.id = ? AND v3_.id IS NULL AND p0_.domain_id = ? AND p0_.show_only_bazaar = ? LIMIT 1
Parameters:
[ 151 1 0 ] |
| 34 | 0.23 ms |
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
]
|
| 35 | 0.31 ms |
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:
[
411
]
|
| 36 | 0.28 ms |
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
]
|
| 37 | 1.42 ms |
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=411" 1 1 0 ] |
| 38 | 0.29 ms |
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
]
|
| 39 | 79.40 ms |
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=42032" 1 0 ] |
| 40 | 0.38 ms |
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
]
|
| 41 | 0.59 ms |
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:
[ "static_id=11" 1 1 0 ] |
| 42 | 0.32 ms |
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
]
|
| 43 | 0.52 ms |
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:
[ "static_id=14" 1 1 0 ] |
| 44 | 0.30 ms |
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
]
|
| 45 | 0.67 ms |
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:
[ "static_id=41" 1 1 0 ] |
| 46 | 0.35 ms |
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
]
|
| 47 | 0.56 ms |
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:
[ "static_id=16" 1 1 0 ] |
| 48 | 0.38 ms |
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:
[
43115
]
|
| 49 | 2.64 ms |
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
]
|
| 50 | 0.54 ms |
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
]
|
| 51 | 2.55 ms |
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
]
|
| 52 | 0.42 ms |
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_.free_shipping_start_date IS NOT NULL AND d0_.free_shipping_end_date IS NOT NULL) AND (d0_.free_shipping_start_date <= ? AND d0_.free_shipping_end_date >= ?)
Parameters:
[ 1 "2026-10-10" "2026-10-10" ] |
| 53 | 0.30 ms |
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
]
|
| 54 | 79.92 ms |
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=42032" 1 0 ] |
| 55 | 0.63 ms |
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
42032
]
|
| 56 | 1.75 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN products__metas p1_ ON (p1_.product_id = p0_.id AND p1_.domain_id = ?) WHERE p0_.type_id = ? AND p0_.vendor_id = ? AND p0_.id <> ? AND p0_.available > 0 AND p1_.active = 1 AND p1_.orderable = 1 AND p0_.quality_status <> ? LIMIT 3
Parameters:
[ 1 151 28 42032 9 ] |
| 57 | 2.24 ms |
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, (CASE WHEN v1_.name = 'HP' THEN 1 ELSE 0 END) AS sclr_49, p0_.created_by AS created_by_50, p0_.updated_by AS updated_by_51, p0_.vendor_id AS vendor_id_52, p0_.type_id AS type_id_53, p0_.photo_album_id AS photo_album_id_54, p0_.current_alternative_product_id AS current_alternative_product_id_55, p0_.product_model_id AS product_model_id_56, p0_.spare_part_created_by AS spare_part_created_by_57, p0_.spare_part_updated_by AS spare_part_updated_by_58, p0_.fixed_attribute_option_combination_id AS fixed_attribute_option_combination_id_59 FROM products p0_ LEFT JOIN products__metas p2_ ON (p2_.product_id = p0_.id AND p2_.domain_id = ?) LEFT JOIN vendors v1_ ON p0_.vendor_id = v1_.id WHERE p0_.type_id = ? AND p0_.vendor_id = ? AND p0_.id <> ? AND p0_.available > 0 AND p2_.active = 1 AND p2_.orderable = 1 AND p0_.quality_status <> ? ORDER BY sclr_49 DESC, p2_.current_vat_price ASC LIMIT 3
Parameters:
[ 1 151 28 42032 9 ] |
| 58 | 0.29 ms |
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:
[
26447
]
|
| 59 | 0.26 ms |
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:
[
26447
]
|
| 60 | 0.21 ms |
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:
[
3634
]
|
| 61 | 0.19 ms |
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:
[
91
]
|
| 62 | 0.19 ms |
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 "4 pin" ] |
| 63 | 0.16 ms |
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 "Gold" ] |
| 64 | 0.16 ms |
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 "HP" ] |
| 65 | 0.17 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3 FROM albums t0 WHERE t0.id = ?
Parameters:
[
26609
]
|
| 66 | 0.24 ms |
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:
[
26609
]
|
| 67 | 3.93 ms |
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 "for ZBook 15 G1, ZBook 15 G2 (PN: 734292-001)" 1 3 ] |
| 68 | 0.42 ms |
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 14:34:32" "2026-10-10 14:34:32" 151 ] |
| 69 | 0.27 ms |
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:
[
26447
]
|
| 70 | 0.28 ms |
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:
[
26417
]
|
| 71 | 0.27 ms |
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:
[
26417
]
|
| 72 | 0.22 ms |
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:
[
744
]
|
| 73 | 0.19 ms |
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 "Silver" ] |
| 74 | 0.19 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3 FROM albums t0 WHERE t0.id = ?
Parameters:
[
26579
]
|
| 75 | 0.23 ms |
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:
[
26579
]
|
| 76 | 3.42 ms |
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 "for EliteBook 820 G3 (PN: 821684-001)" 1 3 ] |
| 77 | 0.56 ms |
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 14:34:32" "2026-10-10 14:34:32" 151 ] |
| 78 | 0.26 ms |
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:
[
26417
]
|
| 79 | 0.28 ms |
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:
[
26363
]
|
| 80 | 0.23 ms |
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:
[
26363
]
|
| 81 | 0.18 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3 FROM albums t0 WHERE t0.id = ?
Parameters:
[
26522
]
|
| 82 | 0.27 ms |
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:
[
26522
]
|
| 83 | 3.36 ms |
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 "for EliteBook 840 G3, 840 G4, 850 G3 (PN: 821170-001)" 1 3 ] |
| 84 | 0.67 ms |
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 14:34:32" "2026-10-10 14:34:32" 151 ] |
| 85 | 0.34 ms |
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:
[
26363
]
|
| 86 | 0.34 ms |
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
]
|
| 87 | 37.72 ms |
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=26447" 1 0 ] |
| 88 | 2.67 ms |
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
]
|
| 89 | 0.44 ms |
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
]
|
| 90 | 0.32 ms |
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
]
|
| 91 | 38.21 ms |
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=26417" 1 0 ] |
| 92 | 2.81 ms |
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
]
|
| 93 | 0.43 ms |
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
]
|
| 94 | 0.25 ms |
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
]
|
| 95 | 47.48 ms |
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=26363" 1 0 ] |
| 96 | 2.77 ms |
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
]
|
| 97 | 0.42 ms |
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
]
|
| 98 | 0.59 ms |
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
42032
]
|
| 99 | 0.20 ms |
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
]
|
| 100 | 0.24 ms |
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
]
|
| 101 | 0.75 ms |
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:
[ "static_id=79" 1 1 0 ] |
| 102 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.updated AS updated_2, c0_.visitor AS visitor_3, c0_.type AS type_4, c0_.email AS email_5, c0_.name AS name_6, c0_.price AS price_7, c0_.source_price AS source_price_8, c0_.notified_price AS notified_price_9, c0_.notified AS notified_10, c0_.unsubscribe_key AS unsubscribe_key_11, c0_.domain_id AS domain_id_12, c0_.customer_id AS customer_id_13, c0_.product_id AS product_id_14, c0_.order_id AS order_id_15 FROM customers__notification c0_ WHERE c0_.product_id = ? AND c0_.domain_id = ?
Parameters:
[ 42032 1 ] |
| 103 | 2.48 ms |
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
]
|
| 104 | 0.33 ms |
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
]
|
| 105 | 5.05 ms |
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
]
|
| 106 | 1.10 ms |
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
]
|
| 107 | 0.77 ms |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
| 108 | 0.28 ms |
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
]
|
| 109 | 0.27 ms |
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
]
|
| 110 | 0.63 ms |
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:
[ "static_id=50" 1 1 0 ] |
| 111 | 0.39 ms |
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
]
|
| 112 | 1.31 ms |
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:
[ "static_id=4" 1 1 0 ] |
| 113 | 0.27 ms |
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
]
|
| 114 | 0.40 ms |
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:
[ "static_id=10" 1 1 0 ] |
| 115 | 0.23 ms |
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
]
|
| 116 | 0.98 ms |
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:
[ "static_id=203" 1 1 0 ] |
| 117 | 0.24 ms |
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
]
|
| 118 | 0.32 ms |
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
]
|
| 119 | 0.37 ms |
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
]
|
| 120 | 84.71 ms |
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:
[ "notebook-reproduktor-hp-for-spectre-13-x2-pro-pn-736899-001-2340abp002-2450094" 1 0 1 null ] |
| 121 | 0.67 ms |
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
42032
]
|
| 122 | 136.03 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '1' AND `query` = 'product_id=42032'
Parameters:
[] |
| 123 | 179.45 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '2' AND `query` = 'product_id=42032'
Parameters:
[] |
| 124 | 141.78 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '3' AND `query` = 'product_id=42032'
Parameters:
[] |
| 125 | 150.58 ms |
SELECT `keyword` FROM seo_url WHERE archived = '0' AND domain_id IS NULL AND language_id = '4' AND `query` = 'product_id=42032'
Parameters:
[] |
| 126 | 0.76 ms |
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
]
|
| 127 | 0.27 ms |
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
]
|
| 128 | 0.45 ms |
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:
[ "static_id=12" 1 1 0 ] |
| 129 | 0.29 ms |
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
]
|
| 130 | 0.51 ms |
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:
[ "static_id=13" 1 1 0 ] |
| 131 | 0.28 ms |
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
]
|
| 132 | 0.39 ms |
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:
[ "static_id=15" 1 1 0 ] |
| 133 | 0.24 ms |
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
]
|
| 134 | 0.55 ms |
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:
[ "static_id=37" 1 1 0 ] |
| 135 | 0.25 ms |
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
]
|
| 136 | 0.37 ms |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
| 137 | 0.49 ms |
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.price AS price_6, t0.free_ship_limit AS free_ship_limit_7, t0.active_on_web AS active_on_web_8, t0.sort_index AS sort_index_9, t0.shipping_days AS shipping_days_10, t0.free_shipping_product_types AS free_shipping_product_types_11, t0.free_shipping_start_date AS free_shipping_start_date_12, t0.free_shipping_end_date AS free_shipping_end_date_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.domain_id AS domain_id_16 FROM domain_shipping_types t0 WHERE t0.domain_id = ? AND t0.active_on_web = ? ORDER BY t0.sort_index ASC
Parameters:
[ 1 1 ] |
| 138 | 4.50 ms |
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
]
|
| 139 | 0.32 ms |
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
]
|
| 140 | 0.38 ms |
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 AND d0_.type <> ?
Parameters:
[ 1 10 ] |
| 141 | 6.58 ms |
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
]
|
| 142 | 0.52 ms |
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_.active_on_web AS active_on_web_6, d0_.integrated AS integrated_7, d0_.sort_order AS sort_order_8, d0_.created_by AS created_by_9, d0_.updated_by AS updated_by_10, d0_.domain_id AS domain_id_11 FROM domain_payment_types d0_ WHERE d0_.domain_id = ? AND d0_.integrated = ? ORDER BY d0_.sort_order ASC
Parameters:
[ 1 1 ] |
| 143 | 2.69 ms |
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
]
|
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.