PHP Notice

Message

Undefined index: custom_company_headquarters_address

Error at

app/addons/sd_seo_jsonld/schemas/jsonld_objects/website_schema.php, line: 2

Backtrace

File:app/addons/sd_seo_jsonld/schemas/jsonld_objects/website_schema.php
Line:2
Function:{closure}
File:app/functions/fn.common.php
Line:2142
Function:include
File:app/addons/sd_seo_jsonld/func.php
Line:2
Function:fn_get_schema
File:app/addons/sd_seo_jsonld/controllers/frontend/init.post.php
Line:2
Function:fn_sd_seo_jsonld_create_object
File:app/functions/fn.control.php
Line:700
Function:include
File:app/functions/fn.control.php
Line:456
Function:fn_run_controller
File:index.php
Line:26
Function:fn_dispatch
Queries total time: 0.14237 s.
№ Query Time
1 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
 0.00037
2 
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
 0.00036
3 
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
 0.00081
4 
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'storage'
0.00032
5 
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 2725 ORDER BY cscart_settings_objects.position
 0.00028
6 
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?byggbay.se'
 0.00032
7 
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 2
 0.00021
8 
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (2) AND status IN ('A', 'P', 'N')
 0.00023
9 
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
 0.00015
10 
SELECT entry_page FROM cscart_companies WHERE company_id = 2 AND redirect_customer != 'Y'
 0.00021
11 
SET time_zone = '+01:00'
 0.00019
12 
SELECT type FROM cscart_seo_names WHERE name = 'cellular-concrete-u-block'  AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0)
 0.00040
13 
SELECT * FROM cscart_seo_names WHERE name = 'cellular-concrete-u-block'  AND cscart_seo_names.company_id IN (0, 2) AND lang_code = 'se'
 0.00039
14 
SELECT * FROM cscart_seo_names WHERE name = 'cellular-concrete-u-block'  AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0)
 0.00038
15 
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
0.00034
16 
SELECT * FROM cscart_settings_sections WHERE name = 'seo' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
 0.00039
17 
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2  WHERE 1  AND section_id = '287' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
 0.00042
18 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00020
19 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00025
20 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 8352 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 2)
 0.00038
21 
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
0.00034
22 
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
 0.00038
23 
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en'  WHERE 1  AND a.is_primary = 'Y' ORDER BY a.position
 0.00029
24 
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 2
0.00033
25 
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name'
0.00032
26 
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
 0.00029
27 
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 2 AND is_default = 1 AND theme_name = 'responsive'
 0.00026
28 
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name'
0.00032
29 
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
 0.00030
30 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
 0.00031
31 
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718247
 0.00018
32 
DELETE FROM cscart_access_restriction_block WHERE expires < 1772425046
 0.00023
33 
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1772425046
 0.00022
34 
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE ip_from <= 3628718247 AND ip_to >= 3628718247 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
 0.00021
35 
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
 0.00016
36 
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718247
 0.00028
37 
DELETE FROM cscart_access_restriction_block WHERE expires < 1772425046
 0.00022
38 
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1772425046
 0.00015
39 
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE ip_from <= 3628718247 AND ip_to >= 3628718247 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
 0.00019
40 
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
 0.00014
41 
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
 0.00020
42 
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 10, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Byggbay', 1, 0))  AND company_id = 2
 0.00034
43 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (78, 76, 79, 80) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00056
44 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
 0.00026
45 
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 2 AND layout_id = 10
 0.00031
46 
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.dispatch = 'products.view' AND (FIND_IN_SET(8352, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
 0.00033
47 
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc
0.00043
48 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label7'
 0.00026
49 
SELECT FOUND_ROWS()
 0.00010
50 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label4'
 0.00022
51 
SELECT FOUND_ROWS()
 0.00011
52 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label10'
 0.00023
53 
SELECT FOUND_ROWS()
 0.00010
54 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label5'
 0.00022
55 
SELECT FOUND_ROWS()
 0.00011
56 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label3'
 0.00023
57 
SELECT FOUND_ROWS()
 0.00011
58 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label1'
 0.00023
59 
SELECT FOUND_ROWS()
 0.00011
60 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label8'
 0.00023
61 
SELECT FOUND_ROWS()
 0.00011
62 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label9'
 0.00022
63 
SELECT FOUND_ROWS()
 0.00017
64 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label2'
 0.00022
65 
SELECT FOUND_ROWS()
 0.00009
66 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label6'
 0.00017
67 
SELECT FOUND_ROWS()
 0.00009
68 
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc
0.00044
69 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00045
70 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00040
71 
SElECT usergroup_ids FROM cscart_products WHERE product_id = 8352
 0.00026
72 
SELECT category_id FROM cscart_products_categories WHERE product_id = 8352 AND link_type = 'M'
 0.00026
73 
SELECT cscart_products.*, cscart_product_descriptions.*, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price, GROUP_CONCAT(IF(cscart_products_categories.link_type = 'M', CONCAT(cscart_products_categories.category_id, 'M'), cscart_products_categories.category_id)) as category_ids, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100))) as price, companies.company as company_name, cscart_product_sales.amount as sales_amount, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, cscart_discussion.type as discussion_type FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'en'  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id AND shared_prices.company_id = 2 AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id  AND cscart_categories.company_id = 2 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id AND cscart_product_sales.category_id = 436 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 8352 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' AND cscart_seo_names.company_id = 2 LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id AND cscart_discussion.object_type = 'P' AND cscart_discussion.company_id = 2 WHERE cscart_products.product_id = 8352  AND (companies.status = 'A' OR cscart_products.company_id = 0)  GROUP BY cscart_products.product_id
 0.00121
74 
SELECT MAX(amount) FROM cscart_product_options_inventory WHERE product_id = 8352
 0.00035
75 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00038
76 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00038
77 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00041
78 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00053
79 
SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM cscart_product_prices prices WHERE prices.product_id = 8352  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
 0.00037
80 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352  GROUP BY c.company_id LIMIT 2
 0.00030
81 
SELECT id_path FROM cscart_categories WHERE category_id IN (279)
 0.00019
82 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf  LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 8352 AND cscart_product_features_values.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(257, pf.categories_path) OR FIND_IN_SET(384, pf.categories_path) OR FIND_IN_SET(279, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description
0.00098
83 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position FROM cscart_product_features AS pf LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_product_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(257, pf.categories_path) OR FIND_IN_SET(384, pf.categories_path) OR FIND_IN_SET(279, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description
 0.00083
84 
SELECT id_path FROM cscart_categories WHERE category_id IN (279)
 0.00017
85 
SELECT v.feature_id, v.value, v.value_int, v.variant_id, f.feature_type, fd.description, fd.prefix, fd.suffix, vd.variant, f.parent_id, f.position, gf.position as gposition FROM cscart_product_features as f LEFT JOIN cscart_product_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN cscart_product_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN cscart_product_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN cscart_product_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN cscart_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = f.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 8352  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(257, f.categories_path) OR FIND_IN_SET(384, f.categories_path) OR FIND_IN_SET(279, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM cscart_product_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.description, fv.position
 0.00074
86 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352  GROUP BY c.company_id LIMIT 2
 0.00030
87 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00028
88 
SELECT * FROM cscart_ult_product_descriptions WHERE product_id = 8352 AND company_id = 2 AND lang_code = 'en'
 0.00025
89 
SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM cscart_ult_product_prices prices WHERE prices.product_id = 8352  AND prices.company_id = 2 AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
 0.00026
90 
SELECT * FROM cscart_image_gallery_settings WHERE id=8352 AND type='P'
 0.00026
91 
SELECT description FROM cscart_image_gallery_settings_description WHERE id = 8352 AND lang_code = 'en' AND type = 'P'
 0.00016
92 
SELECT * FROM cscart_image_gallery_settings WHERE id=8352 AND type='P'
 0.00017
93 
SELECT SQL_CALC_FOUND_ROWS cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id DESC
0.00031
94 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id
0.00034
95 
SELECT gallery_id FROM cscart_image_gallery_ext_settings WHERE FIND_IN_SET(8352, products)
 0.00018
96 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00015
97 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00221
98 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352  GROUP BY c.company_id LIMIT 2
 0.00033
99 
SELECT video_id, product_id, comment, youtube_link, position FROM  cscart_ult_product_videos WHERE product_id = 8352 AND company_id = 2 ORDER BY position
 0.00022
100 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 0.00015
101 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 0.00015
102 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 0.00015
103 
SELECT company FROM cscart_companies WHERE company_id = 1
 0.00014
104 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
0.00024
105 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 0.00048
106 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 0.00020
107 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 0.00014
108 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 0.00018
109 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 0.00014
110 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
0.00024
111 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 0.00045
112 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 0.00019
113 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 0.00013
114 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 0.00016
115 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 0.00014
116 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
0.00024
117 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 0.00048
118 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 0.00019
119 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 0.00013
120 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 0.00013
121 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 0.00013
122 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
0.00023
123 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 0.00047
124 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 0.00019
125 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 0.00013
126 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 0.00013
127 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 0.00013
128 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
0.00024
129 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 0.00044
130 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 0.00024
131 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 0.00015
132 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 0.00022
133 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 0.00022
134 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
0.00038
135 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 0.00058
136 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 0.00029
137 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 0.00020
138 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 0.00015
139 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 0.00013
140 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
0.00025
141 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 0.00057
142 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 0.00039
143 
SELECT s.title, d.descr FROM cscart_unit_price_descr d INNER JOIN cscart_unit_prices s ON s.unit_price_id = d.unit_price_id WHERE s.unit_price_id=26 AND d.lang_code='en' AND s.status='A'
 0.00035
144 
SELECT d.descr FROM cscart_aval_statuses_descr d INNER JOIN cscart_aval_statuses s ON s.aval_status_id = d.aval_status_id WHERE s.aval_status_id=0 AND d.lang_code='en' AND s.status='A'
 0.00021
145 
SELECT id_path FROM cscart_categories WHERE category_id = 279
 0.00030
146 
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (257, 384, 279) AND lang_code = 'en'
 0.00031
147 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (8352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00046
148 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (8352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00038
149 
SELECT a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (8352) AND status = 'A' ORDER BY a.position
 0.00041
150 
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (8352) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
 0.00059
151 
SELECT a.variant_id, a.option_id, a.position, a.modifier, a.modifier_type, a.weight_modifier, a.weight_modifier_type,  b.variant_name, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type FROM cscart_product_option_variants as a LEFT JOIN cscart_product_option_variants_descriptions as b ON a.variant_id = b.variant_id AND b.lang_code = 'en' LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 2 WHERE a.option_id IN (439)  AND a.status='A' ORDER BY a.position, a.variant_id
 0.00041
152 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (11850, 11851, 11852, 11853, 11854, 11855, 11856) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00045
153 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (11850, 11851, 11852, 11853, 11854, 11855, 11856) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00042
154 
SELECT MIN(price) as min_price, MAX(price) as max_price FROM cscart_product_options_inventory WHERE product_id = 8352 AND price > 0 GROUP BY product_id
 0.00033
155 
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 8352 ORDER BY exception_id
 0.00022
156 
SELECT inventory FROM cscart_product_options WHERE option_id = 439
 0.00015
157 
SELECT product_code, amount FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 0.00015
158 
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 8352
 0.00022
159 
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 0.00028
160 
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 0.00019
161 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 4200418605 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00033
162 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 4200418605 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00041
163 
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 8352 ORDER BY exception_id
 0.00032
164 
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 8352 ORDER BY exception_id
 0.00024
165 
SELECT option_type as type, option_id FROM cscart_product_options INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_options.option_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_options') WHERE option_id IN (439)
0.00019
166 
SELECT a.modifier, a.modifier_type, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type, a.variant_id FROM cscart_product_option_variants a  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 2 WHERE 1 AND a.variant_id IN (11850)
 0.00019
167 
SELECT inventory FROM cscart_product_options WHERE option_id = 439
 0.00013
168 
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 0.00014
169 
SELECT a.modifier, a.modifier_type, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type, a.variant_id FROM cscart_product_option_variants a  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 2 WHERE 1 AND a.variant_id IN (11850)
 0.00019
170 
SELECT inventory FROM cscart_product_options WHERE option_id = 439
 0.00013
171 
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 0.00016
172 
SELECT a.modifier, a.modifier_type, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type, a.variant_id FROM cscart_product_option_variants a  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 2 WHERE 1 AND a.variant_id IN (11850)
 0.00017
173 
SELECT inventory FROM cscart_product_options WHERE option_id = 439
 0.00015
174 
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 0.00013
175 
SELECT a.modifier, a.modifier_type, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type, a.variant_id FROM cscart_product_option_variants a  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 2 WHERE 1 AND a.variant_id IN (11850)
 0.00022
176 
SELECT inventory FROM cscart_product_options WHERE option_id = 439
 0.00018
177 
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 0.00025
178 
SELECT cscart_categories.*, cscart_category_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 279  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE cscart_categories.category_id = 279 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.company_id = 2
 0.00045
179 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 279 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00217
180 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 279 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00043
181 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00020
182 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00222
183 
SELECT cscart_categories.*, cscart_category_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 384  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE cscart_categories.category_id = 384 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.company_id = 2
 0.00044
184 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 384 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00033
185 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 384 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00033
186 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00019
187 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00219
188 
SELECT cscart_categories.*, cscart_category_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 257  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE cscart_categories.category_id = 257 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.company_id = 2
 0.00037
189 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 257 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00030
190 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 257 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00033
191 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00019
192 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00218
193 
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='4200418605'
 0.00025
194 
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_promotions.promotion_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'promotions') WHERE 1  AND IF(from_date, from_date <= 1772425046, 1) AND IF(to_date, to_date >= 1772425046, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc
0.00084
195 
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority
 0.00028
196 
SELECT COUNT(*) FROM cscart_countries WHERE code = 'SE' AND status = 'A'
 0.00020
197 
SELECT a.* FROM cscart_destination_elements as a LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A'
0.01609
198 
SELECT COUNT(*) FROM cscart_countries WHERE code = 'SE' AND status = 'A'
 0.00030
199 
SELECT a.* FROM cscart_destination_elements as a LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A'
0.01629
200 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00030
201 
SELECT tax FROM cscart_tax_descriptions WHERE tax_id = 6 AND lang_code = 'en'
 0.00023
202 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00021
203 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00015
204 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00014
205 
SELECT * FROM cscart_product_sd_labels WHERE product_id = 8352
 0.00019
206 
SELECT * FROM cscart_product_options_inventory WHERE product_id = 8352 AND combination_hash = '4200418605'
 0.00019
207 
SELECT list_price FROM cscart_products WHERE product_id = 8352
 0.00014
208 
SELECT s.title, d.descr FROM cscart_unit_price_descr d INNER JOIN cscart_unit_prices s ON s.unit_price_id = d.unit_price_id WHERE s.unit_price_id=26 AND d.lang_code='en' AND s.status='A'
 0.00019
209 
SELECT cscart_product_files.*, cscart_product_file_descriptions.file_name, cscart_product_file_descriptions.license, cscart_product_file_descriptions.readme FROM cscart_product_files  LEFT JOIN cscart_product_file_descriptions ON cscart_product_file_descriptions.file_id = cscart_product_files.file_id AND cscart_product_file_descriptions.lang_code = 'en' WHERE cscart_product_files.product_id = 8352 AND preview_path != '' AND cscart_product_files.status = 'A' ORDER BY position, file_name
 0.00028
210 
SELECT *,cscart_product_tabs.status as status,cscart_product_tabs.block_id as block_id,cscart_product_tabs.company_id as company_id,cscart_product_tabs_descriptions.name as name  FROM cscart_product_tabs LEFT JOIN cscart_product_tabs_descriptions ON cscart_product_tabs.tab_id = cscart_product_tabs_descriptions.tab_id LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_product_tabs.block_id  WHERE cscart_product_tabs_descriptions.lang_code = 'en'  AND cscart_product_tabs.company_id = 2  ORDER BY position
 0.00082
211 
SHOW COLUMNS FROM cscart_product_popularity
 0.00054
212 
INSERT INTO cscart_product_popularity (`product_id`, `viewed`, `total`) VALUES (8352, 1, 3) ON DUPLICATE KEY UPDATE viewed = viewed + 1, total = total + 3
 0.00023
213 
SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 8352 AND user_id = 0
 0.00015
214 
SELECT cscart_attachments.*, cscart_attachment_descriptions.description FROM cscart_attachments LEFT JOIN cscart_attachment_descriptions ON cscart_attachments.attachment_id = cscart_attachment_descriptions.attachment_id AND lang_code = 'en' WHERE object_type = 'product' AND object_id = 8352 AND type = 'M'  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status = 'A' ORDER BY position
 0.00041
215 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf  LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' LEFT JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 8352 AND cscart_product_features_values.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1  AND pf.feature_type != 'G' AND pf.feature_id IN (30) AND pf.status IN ('A') GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description
0.00072
216 
SELECT cscart_product_feature_variant_descriptions.*, cscart_product_feature_variants.*, cscart_product_features_values.variant_id as selected, cscart_product_features.feature_type, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_product_feature_variants  LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_feature_variant_descriptions.lang_code = 'en' LEFT JOIN cscart_product_features_values ON cscart_product_features_values.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_features_values.lang_code = 'en' AND cscart_product_features_values.product_id = 8352 LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_feature_variants.feature_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_product_feature_variants.variant_id AND cscart_seo_names.type = 'e' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0) WHERE 1  AND cscart_product_feature_variants.feature_id IN (30)  GROUP BY cscart_product_feature_variants.variant_id ORDER BY cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant
0.00305
217 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (6243, 6288, 6289, 6300, 6278, 128, 130, 125, 5891, 129, 240, 6131, 5870, 126, 6124, 5771, 5890, 5893, 5773, 123, 212, 6223, 6221, 6222, 5936, 5937, 5933, 5935, 5892, 5938, 5932, 5894, 158) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00151
218 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (6243, 6288, 6289, 6300, 6278, 128, 130, 125, 5891, 129, 240, 6131, 5870, 126, 6124, 5771, 5890, 5893, 5773, 123, 212, 6223, 6221, 6222, 5936, 5937, 5933, 5935, 5892, 5938, 5932, 5894, 158) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 0.00116
219 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_id IN (30) AND feature_type = 'E'
0.00031
220 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position FROM cscart_product_features AS pf LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_product_features)) ORDER BY pf.position, cscart_product_features_descriptions.description
 0.00086
221 
SELECT cscart_product_features.feature_id,cscart_product_features.feature_code,cscart_product_features.company_id,cscart_product_features.feature_type,cscart_product_features.parent_id,cscart_product_features.display_on_product,cscart_product_features.display_on_catalog,cscart_product_features.display_on_header,cscart_product_features_descriptions.description,cscart_product_features_descriptions.lang_code,cscart_product_features_descriptions.prefix,cscart_product_features_descriptions.suffix,cscart_product_features.categories_path,cscart_product_features_descriptions.full_description,cscart_product_features.status,cscart_product_features.comparison,cscart_product_features.position FROM cscart_product_features LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = cscart_product_features.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE cscart_product_features.feature_id = 30
0.00037
222 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00021
223 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00025
224 
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority
 0.00022
225 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00015
226 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00021
227 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00014
228 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 0.00022
229 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00018
230 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00023
231 
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 257  AND cscart_categories.company_id = 2
 0.00023
232 
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 384  AND cscart_categories.company_id = 2
 0.00022
233 
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 279  AND cscart_categories.company_id = 2
 0.00017
234 
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 8352 AND object_type = 'P'  AND cscart_discussion.company_id = 2
0.00024
235 
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 5382  AND cscart_discussion.company_id = 2
 0.00019
236 
SELECT COUNT(*) FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  LEFT JOIN cscart_discussion_rating ON cscart_discussion_rating.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 5382 AND cscart_discussion_posts.status = 'A'
 0.00024
237 
SELECT cscart_discussion_posts.* , cscart_discussion_messages.message, cscart_discussion_rating.rating_value FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  LEFT JOIN cscart_discussion_rating ON cscart_discussion_rating.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 5382 AND cscart_discussion_posts.status = 'A' ORDER BY cscart_discussion_posts.timestamp DESC  LIMIT 0, 10
 0.00037
238 
SELECT AVG(a.rating_value) as val FROM cscart_discussion_rating as a LEFT JOIN cscart_discussion_posts as b ON a.post_id = b.post_id WHERE a.thread_id = 5382 AND b.status = 'A' AND a.rating_value > 0
 0.00022
239 
SELECT c.category_id, IF(pc.link_type = 'M', 1, 0) as is_main FROM cscart_categories AS c LEFT JOIN cscart_products_categories AS pc ON c.category_id = pc.category_id WHERE pc.product_id = 8352  AND c.company_id = 2 ORDER BY is_main DESC
 0.00035
240 
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc
0.00038
241 
SET @r = 0;
 0.00016
242 
SELECT b.row FROM (SELECT product_id, @r := @r + 1 as row FROM(SELECT products.product_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 2 AND shared_descr.lang_code = 'en' LEFT JOIN cscart_aval_statuses ON cscart_aval_statuses.aval_status_id = products.aval_status LEFT JOIN cscart_aval_statuses_descr ON cscart_aval_statuses.aval_status_id = cscart_aval_statuses_descr.aval_status_id AND cscart_aval_statuses.status='A'  AND cscart_aval_statuses_descr.lang_code = 'en' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (279) AND cscart_categories.company_id = 2 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product asc) AS a) AS b WHERE b.product_id = 8352
 0.00107
243 
SELECT SQL_CALC_FOUND_ROWS products.product_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 2 AND shared_descr.lang_code = 'en' LEFT JOIN cscart_aval_statuses ON cscart_aval_statuses.aval_status_id = products.aval_status LEFT JOIN cscart_aval_statuses_descr ON cscart_aval_statuses.aval_status_id = cscart_aval_statuses_descr.aval_status_id AND cscart_aval_statuses.status='A'  AND cscart_aval_statuses_descr.lang_code = 'en' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (279) AND cscart_categories.company_id = 2 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product asc  LIMIT 0, 12
 0.00092
244 
SELECT FOUND_ROWS()
 0.00014
245 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8373
 0.00014
246 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8373 GROUP BY c.company_id
 0.00026
247 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 8373 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 2)
 0.00033
248 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 9463
 0.00019
249 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 9463 GROUP BY c.company_id
 0.00022
250 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9463 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 2)
 0.00030
251 
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
 0.00028
252 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00029
253 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00029
254 
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
0.00027
255 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00024
256 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00023
257 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00018
258 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00022
259 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
 0.00027
260 
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 2 AND layout_id = 10
 0.00031
261 
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 431
 0.00035
262 
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 431
 0.00020
263 
SELECT c.*, IF (c.location_id != 431, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
 0.00185
264 
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1530, 1531, 1572, 1533) ORDER BY g.order, g.parent_id, g.grid_id ASC
 0.00066
265 
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'products' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 8352 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (1958, 1959, 1960, 1961, 1962, 2001, 2002, 2004, 2003, 2005, 2045, 2050, 1964, 2052, 1965, 2051, 2210, 1945, 1947, 1956, 1950, 1948, 1952, 1957, 1955, 1949, 1953, 1946, 1954, 2207)  AND cscart_bm_blocks_descriptions.lang_code='en'  AND cscart_bm_blocks.company_id = 2 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
0.00275
266 
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
0.00036
267 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00025
268 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00025
269 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00022
270 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00031
271 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 8352 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se'  AND cscart_seo_names.company_id IN (0, 2)
 0.00040
272 
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A') ORDER BY a.position
 0.00039
273 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00031
274 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00232
275 
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc
0.00044
276 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00025
277 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00218
278 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 47
0.00029
279 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 48
0.00021
280 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 51
0.00016
281 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00014
282 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00217
283 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 2
0.00028
284 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
0.00031
285 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 59
0.00023
286 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 61
0.00016
287 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 43
0.00015
288 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 62
0.00016
289 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 62 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
0.00027
290 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 64
0.00022
291 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 0.00013
292 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 0.00216
293 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 70
0.00031
294 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 70 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
0.00030
295 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 0.00025
296 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 0.00024

Warning Some queries are being executed multiple times

Queries max count: 11
Query Count Min time Max time Average time 
SELECT FOUND_ROWS()
 11 0.00009 0.00017 0.00011 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352 GROUP BY c.company_id
 10 0.00022 0.00031 0.00026 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8352
 9 0.00018 0.00029 0.00022 
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
 8 0.00014 0.00030 0.00019 
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
 8 0.00013 0.00031 0.00020 
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
 8 0.00216 0.00232 0.00221 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_type = 'E' AND status = 'A'
7 0.00023 0.00038 0.00026 
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 8352 AND lang_code = 'en'
 7 0.00044 0.00058 0.00050 
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5773 AND lang_code = 'en'
 7 0.00019 0.00039 0.00024 
SELECT category FROM cscart_category_descriptions WHERE category_id = 279 AND lang_code = 'en'
 7 0.00013 0.00022 0.00015 
SELECT category FROM cscart_category_descriptions WHERE category_id = 384 AND lang_code = 'en'
 7 0.00013 0.00022 0.00016 
SELECT parent_id FROM cscart_categories WHERE category_id = 279
 7 0.00013 0.00020 0.00015 
SELECT inventory FROM cscart_product_options WHERE option_id = 439
 5 0.00013 0.00018 0.00015 
SELECT a.modifier, a.modifier_type, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type, a.variant_id FROM cscart_product_option_variants a  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 2 WHERE 1 AND a.variant_id IN (11850)
 4 0.00017 0.00022 0.00019 
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc
4 0.00038 0.00044 0.00042 
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 4 0.00013 0.00025 0.00017 
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 8352 ORDER BY exception_id
 3 0.00022 0.00032 0.00026 
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
3 0.00027 0.00036 0.00033 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8352  GROUP BY c.company_id LIMIT 2
 3 0.00030 0.00033 0.00031 
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 2 AND layout_id = 10
 2 0.00031 0.00031 0.00031 
SELECT * FROM cscart_image_gallery_settings WHERE id=8352 AND type='P'
 2 0.00017 0.00026 0.00022 
SELECT id_path FROM cscart_categories WHERE category_id IN (279)
 2 0.00017 0.00019 0.00018 
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
 2 0.00014 0.00016 0.00015 
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE ip_from <= 3628718247 AND ip_to >= 3628718247 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
 2 0.00019 0.00021 0.00020 
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1772425046
 2 0.00015 0.00022 0.00018 
DELETE FROM cscart_access_restriction_block WHERE expires < 1772425046
 2 0.00022 0.00023 0.00023 
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718247
 2 0.00018 0.00028 0.00023 
SELECT a.* FROM cscart_destination_elements as a LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A'
2 0.01609 0.01629 0.01619 
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
 2 0.00029 0.00030 0.00030 
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name'
2 0.00032 0.00032 0.00032 
SELECT s.title, d.descr FROM cscart_unit_price_descr d INNER JOIN cscart_unit_prices s ON s.unit_price_id = d.unit_price_id WHERE s.unit_price_id=26 AND d.lang_code='en' AND s.status='A'
 2 0.00019 0.00035 0.00027 
SELECT COUNT(*) FROM cscart_countries WHERE code = 'SE' AND status = 'A'
 2 0.00020 0.00030 0.00025 
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority
 2 0.00022 0.00028 0.00025 
INSERT INTO cscart_product_popularity (`product_id`, `viewed`, `total`) VALUES (8352, 1, 3) ON DUPLICATE KEY UPDATE viewed = viewed + 1, total = total + 3
 1 0.00023 0.00023 0.00023 
SELECT cscart_product_files.*, cscart_product_file_descriptions.file_name, cscart_product_file_descriptions.license, cscart_product_file_descriptions.readme FROM cscart_product_files  LEFT JOIN cscart_product_file_descriptions ON cscart_product_file_descriptions.file_id = cscart_product_files.file_id AND cscart_product_file_descriptions.lang_code = 'en' WHERE cscart_product_files.product_id = 8352 AND preview_path != '' AND cscart_product_files.status = 'A' ORDER BY position, file_name
 1 0.00028 0.00028 0.00028 
SELECT *,cscart_product_tabs.status as status,cscart_product_tabs.block_id as block_id,cscart_product_tabs.company_id as company_id,cscart_product_tabs_descriptions.name as name  FROM cscart_product_tabs LEFT JOIN cscart_product_tabs_descriptions ON cscart_product_tabs.tab_id = cscart_product_tabs_descriptions.tab_id LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_product_tabs.block_id  WHERE cscart_product_tabs_descriptions.lang_code = 'en'  AND cscart_product_tabs.company_id = 2  ORDER BY position
 1 0.00082 0.00082 0.00082 
SHOW COLUMNS FROM cscart_product_popularity
 1 0.00054 0.00054 0.00054 
SELECT cscart_attachments.*, cscart_attachment_descriptions.description FROM cscart_attachments LEFT JOIN cscart_attachment_descriptions ON cscart_attachments.attachment_id = cscart_attachment_descriptions.attachment_id AND lang_code = 'en' WHERE object_type = 'product' AND object_id = 8352 AND type = 'M'  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status = 'A' ORDER BY position
 1 0.00041 0.00041 0.00041 
SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 8352 AND user_id = 0
 1 0.00015 0.00015 0.00015 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 279 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00217 0.00217 0.00217 
SELECT cscart_categories.*, cscart_category_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 279  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE cscart_categories.category_id = 279 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.company_id = 2
 1 0.00045 0.00045 0.00045 
SELECT list_price FROM cscart_products WHERE product_id = 8352
 1 0.00014 0.00014 0.00014 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf  LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' LEFT JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 8352 AND cscart_product_features_values.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1  AND pf.feature_type != 'G' AND pf.feature_id IN (30) AND pf.status IN ('A') GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description
1 0.00072 0.00072 0.00072 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 279 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00043 0.00043 0.00043 
SELECT tax FROM cscart_tax_descriptions WHERE tax_id = 6 AND lang_code = 'en'
 1 0.00023 0.00023 0.00023 
SELECT * FROM cscart_product_options_inventory WHERE product_id = 8352 AND combination_hash = '4200418605'
 1 0.00019 0.00019 0.00019 
SELECT * FROM cscart_product_sd_labels WHERE product_id = 8352
 1 0.00019 0.00019 0.00019 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (6243, 6288, 6289, 6300, 6278, 128, 130, 125, 5891, 129, 240, 6131, 5870, 126, 6124, 5771, 5890, 5893, 5773, 123, 212, 6223, 6221, 6222, 5936, 5937, 5933, 5935, 5892, 5938, 5932, 5894, 158) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00151 0.00151 0.00151 
SELECT cscart_categories.*, cscart_category_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 384  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE cscart_categories.category_id = 384 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.company_id = 2
 1 0.00044 0.00044 0.00044 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 384 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00033 0.00033 0.00033 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 384 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00033 0.00033 0.00033 
SELECT cscart_categories.*, cscart_category_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 257  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE cscart_categories.category_id = 257 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.company_id = 2
 1 0.00037 0.00037 0.00037 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 257 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00030 0.00030 0.00030 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 257 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00033 0.00033 0.00033 
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='4200418605'
 1 0.00025 0.00025 0.00025 
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_promotions.promotion_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'promotions') WHERE 1  AND IF(from_date, from_date <= 1772425046, 1) AND IF(to_date, to_date >= 1772425046, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc
1 0.00084 0.00084 0.00084 
SELECT cscart_product_feature_variant_descriptions.*, cscart_product_feature_variants.*, cscart_product_features_values.variant_id as selected, cscart_product_features.feature_type, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_product_feature_variants  LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_feature_variant_descriptions.lang_code = 'en' LEFT JOIN cscart_product_features_values ON cscart_product_features_values.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_features_values.lang_code = 'en' AND cscart_product_features_values.product_id = 8352 LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_feature_variants.feature_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_product_feature_variants.variant_id AND cscart_seo_names.type = 'e' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0) WHERE 1  AND cscart_product_feature_variants.feature_id IN (30)  GROUP BY cscart_product_feature_variants.variant_id ORDER BY cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant
1 0.00305 0.00305 0.00305 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
 1 0.00037 0.00037 0.00037 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'feature_variant' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (6243, 6288, 6289, 6300, 6278, 128, 130, 125, 5891, 129, 240, 6131, 5870, 126, 6124, 5771, 5890, 5893, 5773, 123, 212, 6223, 6221, 6222, 5936, 5937, 5933, 5935, 5892, 5938, 5932, 5894, 158) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00116 0.00116 0.00116 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 51
1 0.00016 0.00016 0.00016 
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 431
 1 0.00020 0.00020 0.00020 
SELECT c.*, IF (c.location_id != 431, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
 1 0.00185 0.00185 0.00185 
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1530, 1531, 1572, 1533) ORDER BY g.order, g.parent_id, g.grid_id ASC
 1 0.00066 0.00066 0.00066 
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'products' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 8352 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (1958, 1959, 1960, 1961, 1962, 2001, 2002, 2004, 2003, 2005, 2045, 2050, 1964, 2052, 1965, 2051, 2210, 1945, 1947, 1956, 1950, 1948, 1952, 1957, 1955, 1949, 1953, 1946, 1954, 2207)  AND cscart_bm_blocks_descriptions.lang_code='en'  AND cscart_bm_blocks.company_id = 2 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
1 0.00275 0.00275 0.00275 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 8352 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se'  AND cscart_seo_names.company_id IN (0, 2)
 1 0.00040 0.00040 0.00040 
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A') ORDER BY a.position
 1 0.00039 0.00039 0.00039 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 47
1 0.00029 0.00029 0.00029 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 48
1 0.00021 0.00021 0.00021 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 2
1 0.00028 0.00028 0.00028 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
 1 0.00027 0.00027 0.00027 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
1 0.00031 0.00031 0.00031 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 59
1 0.00023 0.00023 0.00023 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 61
1 0.00016 0.00016 0.00016 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 43
1 0.00015 0.00015 0.00015 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 62
1 0.00016 0.00016 0.00016 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 62 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
1 0.00027 0.00027 0.00027 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 64
1 0.00022 0.00022 0.00022 
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 70
1 0.00031 0.00031 0.00031 
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 431
 1 0.00035 0.00035 0.00035 
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
 1 0.00028 0.00028 0.00028 
SELECT feature_id FROM cscart_product_features INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE feature_id IN (30) AND feature_type = 'E'
1 0.00031 0.00031 0.00031 
SELECT cscart_discussion_posts.* , cscart_discussion_messages.message, cscart_discussion_rating.rating_value FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  LEFT JOIN cscart_discussion_rating ON cscart_discussion_rating.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 5382 AND cscart_discussion_posts.status = 'A' ORDER BY cscart_discussion_posts.timestamp DESC  LIMIT 0, 10
 1 0.00037 0.00037 0.00037 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position FROM cscart_product_features AS pf LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_product_features)) ORDER BY pf.position, cscart_product_features_descriptions.description
 1 0.00086 0.00086 0.00086 
SELECT cscart_product_features.feature_id,cscart_product_features.feature_code,cscart_product_features.company_id,cscart_product_features.feature_type,cscart_product_features.parent_id,cscart_product_features.display_on_product,cscart_product_features.display_on_catalog,cscart_product_features.display_on_header,cscart_product_features_descriptions.description,cscart_product_features_descriptions.lang_code,cscart_product_features_descriptions.prefix,cscart_product_features_descriptions.suffix,cscart_product_features.categories_path,cscart_product_features_descriptions.full_description,cscart_product_features.status,cscart_product_features.comparison,cscart_product_features.position FROM cscart_product_features LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = cscart_product_features.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE cscart_product_features.feature_id = 30
1 0.00037 0.00037 0.00037 
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 257  AND cscart_categories.company_id = 2
 1 0.00023 0.00023 0.00023 
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 384  AND cscart_categories.company_id = 2
 1 0.00022 0.00022 0.00022 
SELECT option_type as type, option_id FROM cscart_product_options INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_options.option_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_options') WHERE option_id IN (439)
1 0.00019 0.00019 0.00019 
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 8352 AND object_type = 'P'  AND cscart_discussion.company_id = 2
1 0.00024 0.00024 0.00024 
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 5382  AND cscart_discussion.company_id = 2
 1 0.00019 0.00019 0.00019 
SELECT COUNT(*) FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  LEFT JOIN cscart_discussion_rating ON cscart_discussion_rating.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 5382 AND cscart_discussion_posts.status = 'A'
 1 0.00024 0.00024 0.00024 
SELECT AVG(a.rating_value) as val FROM cscart_discussion_rating as a LEFT JOIN cscart_discussion_posts as b ON a.post_id = b.post_id WHERE a.thread_id = 5382 AND b.status = 'A' AND a.rating_value > 0
 1 0.00022 0.00022 0.00022 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9463 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 2)
 1 0.00030 0.00030 0.00030 
SELECT c.category_id, IF(pc.link_type = 'M', 1, 0) as is_main FROM cscart_categories AS c LEFT JOIN cscart_products_categories AS pc ON c.category_id = pc.category_id WHERE pc.product_id = 8352  AND c.company_id = 2 ORDER BY is_main DESC
 1 0.00035 0.00035 0.00035 
SET @r = 0;
 1 0.00016 0.00016 0.00016 
SELECT b.row FROM (SELECT product_id, @r := @r + 1 as row FROM(SELECT products.product_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 2 AND shared_descr.lang_code = 'en' LEFT JOIN cscart_aval_statuses ON cscart_aval_statuses.aval_status_id = products.aval_status LEFT JOIN cscart_aval_statuses_descr ON cscart_aval_statuses.aval_status_id = cscart_aval_statuses_descr.aval_status_id AND cscart_aval_statuses.status='A'  AND cscart_aval_statuses_descr.lang_code = 'en' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (279) AND cscart_categories.company_id = 2 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product asc) AS a) AS b WHERE b.product_id = 8352
 1 0.00107 0.00107 0.00107 
SELECT SQL_CALC_FOUND_ROWS products.product_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 2 AND shared_descr.lang_code = 'en' LEFT JOIN cscart_aval_statuses ON cscart_aval_statuses.aval_status_id = products.aval_status LEFT JOIN cscart_aval_statuses_descr ON cscart_aval_statuses.aval_status_id = cscart_aval_statuses_descr.aval_status_id AND cscart_aval_statuses.status='A'  AND cscart_aval_statuses_descr.lang_code = 'en' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (279) AND cscart_categories.company_id = 2 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product asc  LIMIT 0, 12
 1 0.00092 0.00092 0.00092 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 8373
 1 0.00014 0.00014 0.00014 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 8373 GROUP BY c.company_id
 1 0.00026 0.00026 0.00026 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 8373 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 2)
 1 0.00033 0.00033 0.00033 
SELECT COUNT(*) FROM cscart_products WHERE product_id = 9463
 1 0.00019 0.00019 0.00019 
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 9463 GROUP BY c.company_id
 1 0.00022 0.00022 0.00022 
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 279  AND cscart_categories.company_id = 2
 1 0.00017 0.00017 0.00017 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (8352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00038 0.00038 0.00038 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 4200418605 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00041 0.00041 0.00041 
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.dispatch = 'products.view' AND (FIND_IN_SET(8352, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
 1 0.00033 0.00033 0.00033 
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 2 AND is_default = 1 AND theme_name = 'responsive'
 1 0.00026 0.00026 0.00026 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
 1 0.00031 0.00031 0.00031 
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
 1 0.00020 0.00020 0.00020 
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 10, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Byggbay', 1, 0))  AND company_id = 2
 1 0.00034 0.00034 0.00034 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (78, 76, 79, 80) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00056 0.00056 0.00056 
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
 1 0.00026 0.00026 0.00026 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label7'
 1 0.00026 0.00026 0.00026 
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en'  WHERE 1  AND a.is_primary = 'Y' ORDER BY a.position
 1 0.00029 0.00029 0.00029 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label4'
 1 0.00022 0.00022 0.00022 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label10'
 1 0.00023 0.00023 0.00023 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label5'
 1 0.00022 0.00022 0.00022 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label3'
 1 0.00023 0.00023 0.00023 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label1'
 1 0.00023 0.00023 0.00023 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label8'
 1 0.00023 0.00023 0.00023 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label9'
 1 0.00022 0.00022 0.00022 
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 2
1 0.00033 0.00033 0.00033 
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
 1 0.00038 0.00038 0.00038 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label6'
 1 0.00017 0.00017 0.00017 
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
 1 0.00015 0.00015 0.00015 
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
 1 0.00081 0.00081 0.00081 
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'storage'
1 0.00032 0.00032 0.00032 
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 2725 ORDER BY cscart_settings_objects.position
 1 0.00028 0.00028 0.00028 
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?byggbay.se'
 1 0.00032 0.00032 0.00032 
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 2
 1 0.00021 0.00021 0.00021 
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (2) AND status IN ('A', 'P', 'N')
 1 0.00023 0.00023 0.00023 
SELECT entry_page FROM cscart_companies WHERE company_id = 2 AND redirect_customer != 'Y'
 1 0.00021 0.00021 0.00021 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 8352 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 2)
 1 0.00038 0.00038 0.00038 
SET time_zone = '+01:00'
 1 0.00019 0.00019 0.00019 
SELECT type FROM cscart_seo_names WHERE name = 'cellular-concrete-u-block'  AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0)
 1 0.00040 0.00040 0.00040 
SELECT * FROM cscart_seo_names WHERE name = 'cellular-concrete-u-block'  AND cscart_seo_names.company_id IN (0, 2) AND lang_code = 'se'
 1 0.00039 0.00039 0.00039 
SELECT * FROM cscart_seo_names WHERE name = 'cellular-concrete-u-block'  AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0)
 1 0.00038 0.00038 0.00038 
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
1 0.00034 0.00034 0.00034 
SELECT * FROM cscart_settings_sections WHERE name = 'seo' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
 1 0.00039 0.00039 0.00039 
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2  WHERE 1  AND section_id = '287' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
 1 0.00042 0.00042 0.00042 
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label2'
 1 0.00022 0.00022 0.00022 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00045 0.00045 0.00045 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 4200418605 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00033 0.00033 0.00033 
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (8352) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
 1 0.00059 0.00059 0.00059 
SELECT d.descr FROM cscart_aval_statuses_descr d INNER JOIN cscart_aval_statuses s ON s.aval_status_id = d.aval_status_id WHERE s.aval_status_id=0 AND d.lang_code='en' AND s.status='A'
 1 0.00021 0.00021 0.00021 
SELECT id_path FROM cscart_categories WHERE category_id = 279
 1 0.00030 0.00030 0.00030 
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (257, 384, 279) AND lang_code = 'en'
 1 0.00031 0.00031 0.00031 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (8352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00046 0.00046 0.00046 
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
 1 0.00036 0.00036 0.00036 
SELECT a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (8352) AND status = 'A' ORDER BY a.position
 1 0.00041 0.00041 0.00041 
SELECT a.variant_id, a.option_id, a.position, a.modifier, a.modifier_type, a.weight_modifier, a.weight_modifier_type,  b.variant_name, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier, a.modifier) as modifier, IF(shared_option_variants.variant_id IS NOT NULL, shared_option_variants.modifier_type, a.modifier_type) as modifier_type FROM cscart_product_option_variants as a LEFT JOIN cscart_product_option_variants_descriptions as b ON a.variant_id = b.variant_id AND b.lang_code = 'en' LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id AND shared_option_variants.company_id = 2 WHERE a.option_id IN (439)  AND a.status='A' ORDER BY a.position, a.variant_id
 1 0.00041 0.00041 0.00041 
SELECT video_id, product_id, comment, youtube_link, position FROM  cscart_ult_product_videos WHERE product_id = 8352 AND company_id = 2 ORDER BY position
 1 0.00022 0.00022 0.00022 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (11850, 11851, 11852, 11853, 11854, 11855, 11856) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00045 0.00045 0.00045 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (11850, 11851, 11852, 11853, 11854, 11855, 11856) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00042 0.00042 0.00042 
SELECT MIN(price) as min_price, MAX(price) as max_price FROM cscart_product_options_inventory WHERE product_id = 8352 AND price > 0 GROUP BY product_id
 1 0.00033 0.00033 0.00033 
SELECT product_code, amount FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 1 0.00015 0.00015 0.00015 
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 8352
 1 0.00022 0.00022 0.00022 
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 1 0.00028 0.00028 0.00028 
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 4200418605
 1 0.00019 0.00019 0.00019 
SELECT company FROM cscart_companies WHERE company_id = 1
 1 0.00014 0.00014 0.00014 
SELECT gallery_id FROM cscart_image_gallery_ext_settings WHERE FIND_IN_SET(8352, products)
 1 0.00018 0.00018 0.00018 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00040 0.00040 0.00040 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00053 0.00053 0.00053 
SElECT usergroup_ids FROM cscart_products WHERE product_id = 8352
 1 0.00026 0.00026 0.00026 
SELECT category_id FROM cscart_products_categories WHERE product_id = 8352 AND link_type = 'M'
 1 0.00026 0.00026 0.00026 
SELECT cscart_products.*, cscart_product_descriptions.*, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price, GROUP_CONCAT(IF(cscart_products_categories.link_type = 'M', CONCAT(cscart_products_categories.category_id, 'M'), cscart_products_categories.category_id)) as category_ids, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100))) as price, companies.company as company_name, cscart_product_sales.amount as sales_amount, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, cscart_discussion.type as discussion_type FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'en'  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id AND shared_prices.company_id = 2 AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id  AND cscart_categories.company_id = 2 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id AND cscart_product_sales.category_id = 436 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 8352 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' AND cscart_seo_names.company_id = 2 LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id AND cscart_discussion.object_type = 'P' AND cscart_discussion.company_id = 2 WHERE cscart_products.product_id = 8352  AND (companies.status = 'A' OR cscart_products.company_id = 0)  GROUP BY cscart_products.product_id
 1 0.00121 0.00121 0.00121 
SELECT MAX(amount) FROM cscart_product_options_inventory WHERE product_id = 8352
 1 0.00035 0.00035 0.00035 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00038 0.00038 0.00038 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00038 0.00038 0.00038 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
 1 0.00041 0.00041 0.00041 
SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM cscart_product_prices prices WHERE prices.product_id = 8352  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
 1 0.00037 0.00037 0.00037 
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id
1 0.00034 0.00034 0.00034 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf  LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 8352 AND cscart_product_features_values.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(257, pf.categories_path) OR FIND_IN_SET(384, pf.categories_path) OR FIND_IN_SET(279, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description
1 0.00098 0.00098 0.00098 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position FROM cscart_product_features AS pf LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_product_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(257, pf.categories_path) OR FIND_IN_SET(384, pf.categories_path) OR FIND_IN_SET(279, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description
 1 0.00083 0.00083 0.00083 
SELECT v.feature_id, v.value, v.value_int, v.variant_id, f.feature_type, fd.description, fd.prefix, fd.suffix, vd.variant, f.parent_id, f.position, gf.position as gposition FROM cscart_product_features as f LEFT JOIN cscart_product_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN cscart_product_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN cscart_product_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN cscart_product_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN cscart_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = f.feature_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 8352  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(257, f.categories_path) OR FIND_IN_SET(384, f.categories_path) OR FIND_IN_SET(279, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM cscart_product_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.description, fv.position
 1 0.00074 0.00074 0.00074 
SELECT * FROM cscart_ult_product_descriptions WHERE product_id = 8352 AND company_id = 2 AND lang_code = 'en'
 1 0.00025 0.00025 0.00025 
SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM cscart_ult_product_prices prices WHERE prices.product_id = 8352  AND prices.company_id = 2 AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
 1 0.00026 0.00026 0.00026 
SELECT description FROM cscart_image_gallery_settings_description WHERE id = 8352 AND lang_code = 'en' AND type = 'P'
 1 0.00016 0.00016 0.00016 
SELECT SQL_CALC_FOUND_ROWS cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 8352 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id DESC
1 0.00031 0.00031 0.00031 
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 70 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
1 0.00030 0.00030 0.00030