Queries total time: 0.04101 s.
Query Time
1
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
0.00022
2
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
0.00027
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.00056
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.00030
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 = 291 ORDER BY cscart_settings_objects.position
0.00028
6
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 = 'cdn' 
0.00029
7
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 = 294 ORDER BY cscart_settings_objects.position
0.00026
8
SELECT company_id, storefront FROM cscart_companies WHERE storefront RLIKE '^(www[0-9]*.)?fish.ee'
0.00025
9
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1
0.00020
10
SELECT company_id, storefront FROM cscart_companies WHERE FIND_IN_SET('US', countries_list) LIMIT 1
0.00026
11
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (1) AND status IN ('A', 'P', 'N')
0.00022
12
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
0.00016
13
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
0.00015
14
SELECT company_id FROM cscart_companies
0.00013
15
SELECT type FROM cscart_seo_names WHERE name = 'kaheksajalg-ee'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
0.00040
16
SELECT * FROM cscart_seo_names WHERE name = 'kaheksajalg-ee'  AND cscart_seo_names.company_id IN (0, 1) AND lang_code = 'ee'
0.00042
17
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00031
18
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('shop', 'gourmet', 'seafood-ee') AND type = 'c' AND lang_code = 'ee'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
0.00050
19
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.00032
20
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 = 1  WHERE 1  AND section_id = '47' 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.00046
21
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
0.00038
22
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 4 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
0.00030
23
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 3 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
0.00031
24
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
0.00031
25
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00036
26
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 = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
0.00042
27
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 1 
0.00032
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.00025
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 = 1  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.00031
30
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00027
31
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.00012
32
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 = 1  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.00008
33
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
0.00024
34
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 1, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'RusCaviar', 1, 0))  AND company_id = 1
0.00033
35
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 = 'ee' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (7, 8, 9, 10) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00059
36
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
0.00026
37
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 1
0.00032
38
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 = 'ee' WHERE l.layout_id = 1  AND l.dispatch = 'products.view'  ORDER BY l.object_ids desc  LIMIT 1
0.00036
39
SElECT usergroup_ids FROM cscart_products WHERE product_id = 11
0.00021
40
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_seo_names.name as seo_name, cscart_seo_names.path as seo_path 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 = 'ee'  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id AND shared_prices.company_id = 1 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 = 1 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_seo_names ON cscart_seo_names.object_id = 11 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' AND cscart_seo_names.company_id = 1 WHERE cscart_products.product_id = 11  AND (companies.status = 'A' OR cscart_products.company_id = 0)  GROUP BY cscart_products.product_id
0.00132
41
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 11 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00042
42
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 11 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00042
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 11 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00038
44
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 11 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00039
45
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 = 11  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
0.00031
46
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 = 11  GROUP BY c.company_id LIMIT 2
0.00029
47
SELECT company_id FROM cscart_products WHERE product_id = 11
0.00019
48
SELECT id_path FROM cscart_categories WHERE category_id = 9
0.00015
49
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 = 'ee' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 11 AND cscart_product_features_values.lang_code = 'ee' 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 = 1 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(4, pf.categories_path) OR FIND_IN_SET(3, pf.categories_path) OR FIND_IN_SET(9, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description 
0.00049
50
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 = 'ee' 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 = 1 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(4, pf.categories_path) OR FIND_IN_SET(3, pf.categories_path) OR FIND_IN_SET(9, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description
0.00037
51
SELECT id_path FROM cscart_categories WHERE category_id = 9
0.00008
52
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 = 11  GROUP BY c.company_id LIMIT 2
0.00007
53
SELECT company_id FROM cscart_products WHERE product_id = 11
0.00007
54
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 = 'ee' 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 = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 11  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(4, f.categories_path) OR FIND_IN_SET(3, f.categories_path) OR FIND_IN_SET(9, 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 = 'ee' ORDER BY fd.description, fv.position
0.00051
55
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 = 11  GROUP BY c.company_id LIMIT 2
0.00012
56
SELECT company_id FROM cscart_products WHERE product_id = 11
0.00007
57
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 = 11 GROUP BY c.company_id
0.00024
58
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ee'  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 = 1 AND shared_descr.lang_code = 'ee' LEFT JOIN cscart_product_required_products ON products.product_id = cscart_product_required_products.required_id WHERE 1  AND cscart_categories.company_id = 1 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) AND cscart_product_required_products.product_id = 11 GROUP BY products.product_id   ORDER BY NULL asc 
0.00234
59
SELECT id_path FROM cscart_categories WHERE category_id = 9
0.00112
60
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (4, 3, 9) AND lang_code = 'ee'
0.00032
61
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (11) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00047
62
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (11) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00042
63
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 = 'ee'  WHERE a.product_id IN (11) AND status = 'A' ORDER BY a.position
0.00050
64
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 = 'ee' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (11) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
0.00032
65
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 = 'ee' 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 = 1 WHERE a.option_id IN (18)  AND a.status='A' ORDER BY a.position, a.variant_id
0.00041
66
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 = 'ee' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (42, 83) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00041
67
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 = 'ee' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (42, 83) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00040
68
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 11 ORDER BY exception_id
0.00018
69
SELECT inventory FROM cscart_product_options WHERE option_id = 18
0.00015
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.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 = 'ee' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 3596227959 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00035
71
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 = 'ee' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 3596227959 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00036
72
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 11 ORDER BY exception_id
0.00011
73
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_options') WHERE option_id IN (18) 
0.00022
74
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 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 = 1 WHERE 1 AND a.variant_id = 42
0.00025
75
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 = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'promotions') WHERE 1  AND IF(from_date, from_date <= 1675187875, 1) AND IF(to_date, to_date >= 1675187875, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc 
0.00046
76
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 = 'ee' WHERE cscart_product_files.product_id = 11 AND preview_path != '' AND cscart_product_files.status = 'A' ORDER BY position, file_name
0.00036
77
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 = 'ee'  AND cscart_product_tabs.company_id = 1  ORDER BY position
0.00046
78
SHOW COLUMNS FROM cscart_product_popularity
0.00067
79
INSERT INTO cscart_product_popularity (`product_id`, `viewed`, `total`) VALUES (11, 1, 3) ON DUPLICATE KEY UPDATE viewed = viewed + 1, total = total + 3
0.00027
80
SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 11 AND user_id = 0
0.00016
81
SELECT cscart_tags.tag_id, cscart_tag_links.object_id, cscart_tag_links.object_type, cscart_tags.tag, cscart_tags.status, COUNT(cscart_tag_links.tag_id) as popularity FROM cscart_tags LEFT JOIN cscart_tag_links ON cscart_tag_links.tag_id = cscart_tags.tag_id WHERE 1  AND cscart_tags.company_id = 1 AND cscart_tag_links.object_type = 'P' AND cscart_tags.status IN ('A') AND cscart_tag_links.object_id = 11 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 
0.00025
82
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 = 11  AND c.company_id = 1 ORDER BY is_main DESC
0.00027
83
SET @r = 0;
0.00010
84
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 = 'ee'  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 = 1 AND shared_descr.lang_code = 'ee' WHERE 1  AND cscart_categories.category_id IN (9) AND cscart_categories.company_id = 1 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 = 11
0.00082
85
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 = 'ee'  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 = 1 AND shared_descr.lang_code = 'ee' WHERE 1  AND cscart_categories.category_id IN (9) AND cscart_categories.company_id = 1 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, 30
0.00074
86
SELECT FOUND_ROWS()
0.00011
87
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 31 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
0.00029
88
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
0.00030
89
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
0.00019
90
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
0.00027
91
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 1
0.00018
92
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 = 'ee' WHERE l.layout_id = 1  AND l.dispatch = 'products.view' AND (FIND_IN_SET(11, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
0.00032
93
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 3
0.00023
94
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 3
0.00015
95
SELECT c.*, IF (c.location_id != 3, 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 = 1 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
0.00048
96
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 (1, 2, 11, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
0.00050
97
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 = 11 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (1, 2, 3, 7, 10, 14, 15, 16, 17, 19, 20, 13, 18, 29, 30, 125)  AND cscart_bm_blocks_descriptions.lang_code='ee'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
0.00136
98
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00018
99
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY `position`;
0.00023
100
SELECT status FROM cscart_menus WHERE menu_id = 3
0.00023
101
SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'ee' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position
0.00042
102
SELECT id_path FROM cscart_categories WHERE category_id = 4
0.00021
103
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'ee'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1  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') AND cscart_categories.id_path LIKE '4/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00085
104
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(9, 1, 10, 2, 3, 11, 18, 21, 26, 6, 30, 27, 28, 31, 32, 29) 
0.00027
105
SELECT id_path 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 12 
0.00033
106
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'ee' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.id_path LIKE '12/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1675187875 AND avail_till_timestamp >= 1675187875)) ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
0.00127
107
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 12 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'ee' 
0.00040
108
SELECT id_path 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 15 
0.00026
109
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'ee' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.id_path LIKE '15/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1675187875 AND avail_till_timestamp >= 1675187875)) ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
0.00100
110
SELECT details_layout FROM cscart_products WHERE product_id = 11
0.00024
111
SELECT c.product_details_view FROM cscart_products_categories as pc LEFT JOIN cscart_categories as c ON pc.category_id = c.category_id WHERE pc.product_id = 11 AND pc.link_type = 'M'
0.00027

Warning Some queries are being executed multiple times

Queries max count: 3
Query Count Min time Max time Average time
SELECT id_path FROM cscart_categories WHERE category_id = 9
3 0.00008 0.00112 0.00045
SELECT company_id FROM cscart_products WHERE product_id = 11
3 0.00007 0.00019 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 = 11  GROUP BY c.company_id LIMIT 2
3 0.00007 0.00029 0.00016
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 = 1  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.00008 0.00031 0.00020
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
2 0.00018 0.00036 0.00027
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 11 ORDER BY exception_id
2 0.00011 0.00018 0.00015
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 1
2 0.00018 0.00032 0.00025
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.00012 0.00025 0.00018
SHOW COLUMNS FROM cscart_product_popularity
1 0.00067 0.00067 0.00067
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 = 'ee'  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 = 1 AND shared_descr.lang_code = 'ee' WHERE 1  AND cscart_categories.category_id IN (9) AND cscart_categories.company_id = 1 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 = 11
1 0.00082 0.00082 0.00082
SET @r = 0;
1 0.00010 0.00010 0.00010
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 = 11  AND c.company_id = 1 ORDER BY is_main DESC
1 0.00027 0.00027 0.00027
SELECT cscart_tags.tag_id, cscart_tag_links.object_id, cscart_tag_links.object_type, cscart_tags.tag, cscart_tags.status, COUNT(cscart_tag_links.tag_id) as popularity FROM cscart_tags LEFT JOIN cscart_tag_links ON cscart_tag_links.tag_id = cscart_tags.tag_id WHERE 1  AND cscart_tags.company_id = 1 AND cscart_tag_links.object_type = 'P' AND cscart_tags.status IN ('A') AND cscart_tag_links.object_id = 11 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 
1 0.00025 0.00025 0.00025
SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 11 AND user_id = 0
1 0.00016 0.00016 0.00016
INSERT INTO cscart_product_popularity (`product_id`, `viewed`, `total`) VALUES (11, 1, 3) ON DUPLICATE KEY UPDATE viewed = viewed + 1, total = total + 3
1 0.00027 0.00027 0.00027
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
1 0.00022 0.00022 0.00022
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 = 'ee'  AND cscart_product_tabs.company_id = 1  ORDER BY position
1 0.00046 0.00046 0.00046
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 = 'ee' WHERE cscart_product_files.product_id = 11 AND preview_path != '' AND cscart_product_files.status = 'A' ORDER BY position, file_name
1 0.00036 0.00036 0.00036
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 = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'promotions') WHERE 1  AND IF(from_date, from_date <= 1675187875, 1) AND IF(to_date, to_date >= 1675187875, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc 
1 0.00046 0.00046 0.00046
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_options') WHERE option_id IN (18) 
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.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 = 'ee' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 3596227959 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00036 0.00036 0.00036
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 = 'ee' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 3596227959 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00035 0.00035 0.00035
SELECT inventory FROM cscart_product_options WHERE option_id = 18
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.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 = 'ee' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (42, 83) 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.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 = 'ee' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (42, 83) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
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 = 'ee' 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 = 1 WHERE a.option_id IN (18)  AND a.status='A' ORDER BY a.position, a.variant_id
1 0.00041 0.00041 0.00041
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 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 = 1 WHERE 1 AND a.variant_id = 42
1 0.00025 0.00025 0.00025
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 = 'ee'  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 = 1 AND shared_descr.lang_code = 'ee' WHERE 1  AND cscart_categories.category_id IN (9) AND cscart_categories.company_id = 1 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, 30
1 0.00074 0.00074 0.00074
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 = 'ee'  WHERE a.product_id IN (11) AND status = 'A' ORDER BY a.position
1 0.00050 0.00050 0.00050
SELECT status FROM cscart_menus WHERE menu_id = 3
1 0.00023 0.00023 0.00023
SELECT details_layout FROM cscart_products WHERE product_id = 11
1 0.00024 0.00024 0.00024
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'ee' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.id_path LIKE '15/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1675187875 AND avail_till_timestamp >= 1675187875)) ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
1 0.00100 0.00100 0.00100
SELECT id_path 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 15 
1 0.00026 0.00026 0.00026
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 12 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'ee' 
1 0.00040 0.00040 0.00040
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'ee' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.id_path LIKE '12/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1675187875 AND avail_till_timestamp >= 1675187875)) ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
1 0.00127 0.00127 0.00127
SELECT id_path 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 12 
1 0.00033 0.00033 0.00033
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(9, 1, 10, 2, 3, 11, 18, 21, 26, 6, 30, 27, 28, 31, 32, 29) 
1 0.00027 0.00027 0.00027
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'ee'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee'  AND cscart_seo_names.company_id = cscart_categories.company_id  WHERE 1  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') AND cscart_categories.id_path LIKE '4/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00085 0.00085 0.00085
SELECT id_path FROM cscart_categories WHERE category_id = 4
1 0.00021 0.00021 0.00021
SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'ee' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position
1 0.00042 0.00042 0.00042
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY `position`;
1 0.00023 0.00023 0.00023
SELECT FOUND_ROWS()
1 0.00011 0.00011 0.00011
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 = 11 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (1, 2, 3, 7, 10, 14, 15, 16, 17, 19, 20, 13, 18, 29, 30, 125)  AND cscart_bm_blocks_descriptions.lang_code='ee'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00136 0.00136 0.00136
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 (1, 2, 11, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00050 0.00050 0.00050
SELECT c.*, IF (c.location_id != 3, 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 = 1 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
1 0.00048 0.00048 0.00048
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 3
1 0.00015 0.00015 0.00015
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 3
1 0.00023 0.00023 0.00023
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 = 'ee' WHERE l.layout_id = 1  AND l.dispatch = 'products.view' AND (FIND_IN_SET(11, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00032 0.00032 0.00032
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
1 0.00027 0.00027 0.00027
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00030 0.00030 0.00030
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 31 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00029 0.00029 0.00029
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 = 'ee' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (11) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
1 0.00032 0.00032 0.00032
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ee'  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 = 1 AND shared_descr.lang_code = 'ee' LEFT JOIN cscart_product_required_products ON products.product_id = cscart_product_required_products.required_id WHERE 1  AND cscart_categories.company_id = 1 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) AND cscart_product_required_products.product_id = 11 GROUP BY products.product_id   ORDER BY NULL asc 
1 0.00234 0.00234 0.00234
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (11) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00042 0.00042 0.00042
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
1 0.00015 0.00015 0.00015
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 11 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00038 0.00038 0.00038
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 = 1  WHERE 1  AND section_id = '47' 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.00046 0.00046 0.00046
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.00032 0.00032 0.00032
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('shop', 'gourmet', 'seafood-ee') AND type = 'c' AND lang_code = 'ee'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
1 0.00050 0.00050 0.00050
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
1 0.00031 0.00031 0.00031
SELECT * FROM cscart_seo_names WHERE name = 'kaheksajalg-ee'  AND cscart_seo_names.company_id IN (0, 1) AND lang_code = 'ee'
1 0.00042 0.00042 0.00042
SELECT type FROM cscart_seo_names WHERE name = 'kaheksajalg-ee'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
1 0.00040 0.00040 0.00040
SELECT company_id FROM cscart_companies
1 0.00013 0.00013 0.00013
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
1 0.00016 0.00016 0.00016
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 3 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00031 0.00031 0.00031
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (1) AND status IN ('A', 'P', 'N')
1 0.00022 0.00022 0.00022
SELECT company_id, storefront FROM cscart_companies WHERE FIND_IN_SET('US', countries_list) LIMIT 1
1 0.00026 0.00026 0.00026
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1
1 0.00020 0.00020 0.00020
SELECT company_id, storefront FROM cscart_companies WHERE storefront RLIKE '^(www[0-9]*.)?fish.ee'
1 0.00025 0.00025 0.00025
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 = 294 ORDER BY cscart_settings_objects.position
1 0.00026 0.00026 0.00026
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 = 'cdn' 
1 0.00029 0.00029 0.00029
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 = 291 ORDER BY cscart_settings_objects.position
1 0.00028 0.00028 0.00028
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.00030 0.00030 0.00030
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.00056 0.00056 0.00056
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 4 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00030 0.00030 0.00030
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ee'  AND cscart_seo_names.company_id IN (0, 1)
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (11) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00047 0.00047 0.00047
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 11 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00042 0.00042 0.00042
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (4, 3, 9) AND lang_code = 'ee'
1 0.00032 0.00032 0.00032
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
1 0.00027 0.00027 0.00027
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 = 11 GROUP BY c.company_id
1 0.00024 0.00024 0.00024
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 = 'ee' 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 = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 11  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(4, f.categories_path) OR FIND_IN_SET(3, f.categories_path) OR FIND_IN_SET(9, 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 = 'ee' ORDER BY fd.description, fv.position
1 0.00051 0.00051 0.00051
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 = 'ee' 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 = 1 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(4, pf.categories_path) OR FIND_IN_SET(3, pf.categories_path) OR FIND_IN_SET(9, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description
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, 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 = 'ee' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 11 AND cscart_product_features_values.lang_code = 'ee' 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 = 1 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(4, pf.categories_path) OR FIND_IN_SET(3, pf.categories_path) OR FIND_IN_SET(9, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description 
1 0.00049 0.00049 0.00049
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 = 11  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
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.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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 11 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00039 0.00039 0.00039
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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 11 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 = 'ee' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 11 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00042 0.00042 0.00042
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 = 'ee' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
1 0.00042 0.00042 0.00042
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_seo_names.name as seo_name, cscart_seo_names.path as seo_path 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 = 'ee'  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id AND shared_prices.company_id = 1 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 = 1 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_seo_names ON cscart_seo_names.object_id = 11 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ee' AND cscart_seo_names.company_id = 1 WHERE cscart_products.product_id = 11  AND (companies.status = 'A' OR cscart_products.company_id = 0)  GROUP BY cscart_products.product_id
1 0.00132 0.00132 0.00132
SElECT usergroup_ids FROM cscart_products WHERE product_id = 11
1 0.00021 0.00021 0.00021
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 = 'ee' WHERE l.layout_id = 1  AND l.dispatch = 'products.view'  ORDER BY l.object_ids desc  LIMIT 1
1 0.00036 0.00036 0.00036
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
1 0.00026 0.00026 0.00026
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 = 'ee' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (7, 8, 9, 10) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00059 0.00059 0.00059
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 1, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'RusCaviar', 1, 0))  AND company_id = 1
1 0.00033 0.00033 0.00033
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
1 0.00024 0.00024 0.00024
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
1 0.00027 0.00027 0.00027
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 1 
1 0.00032 0.00032 0.00032
SELECT c.product_details_view FROM cscart_products_categories as pc LEFT JOIN cscart_categories as c ON pc.category_id = c.category_id WHERE pc.product_id = 11 AND pc.link_type = 'M'
1 0.00027 0.00027 0.00027