Queries
max count: 35
Query |
Count |
Min time |
Max time |
Average time |
SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 10
|
35 |
0.00012 |
0.00026 |
0.00018 |
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
|
35 |
0.00210 |
0.00222 |
0.00214 |
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
|
35 |
0.00014 |
0.00040 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 260 AND cscart_categories.company_id = 2
|
29 |
0.00013 |
0.00061 |
0.00024 |
SELECT inventory FROM cscart_product_options WHERE option_id = 1218
|
25 |
0.00012 |
0.00023 |
0.00016 |
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 (22769)
|
20 |
0.00018 |
0.00025 |
0.00020 |
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority
|
12 |
0.00015 |
0.00028 |
0.00020 |
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'
|
12 |
0.00022 |
0.00031 |
0.00025 |
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='se' AND s.status='A'
|
12 |
0.00016 |
0.00024 |
0.00019 |
SELECT variant FROM cscart_product_feature_variant_descriptions WHERE variant_id = 5933 AND lang_code = 'se'
|
12 |
0.00014 |
0.00023 |
0.00018 |
SELECT FOUND_ROWS()
|
11 |
0.00008 |
0.00013 |
0.00010 |
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 = 'se' WHERE 1 AND cscart_sd_labels_custom.used = 'Y' ORDER BY cscart_sd_labels_custom_descriptions.name asc
|
8 |
0.00032 |
0.00041 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 260 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
8 |
0.00027 |
0.00036 |
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.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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 260 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
8 |
0.00028 |
0.00041 |
0.00031 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 374 AND lang_code = 'se'
|
7 |
0.00013 |
0.00024 |
0.00016 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 374 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 374 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
|
7 |
0.00032 |
0.00037 |
0.00034 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 260 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 260 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
|
7 |
0.00031 |
0.00040 |
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.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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 374 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
7 |
0.00027 |
0.00031 |
0.00029 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 374 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
7 |
0.00028 |
0.00031 |
0.00030 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 624
|
6 |
0.00013 |
0.00020 |
0.00016 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 630
|
6 |
0.00014 |
0.00021 |
0.00016 |
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 = 630 GROUP BY c.company_id
|
6 |
0.00023 |
0.00027 |
0.00024 |
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 = 644 GROUP BY c.company_id
|
6 |
0.00022 |
0.00028 |
0.00024 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 644
|
6 |
0.00014 |
0.00022 |
0.00017 |
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=1 AND d.lang_code='se' AND s.status='A'
|
6 |
0.00017 |
0.00023 |
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 = 624 GROUP BY c.company_id
|
6 |
0.00022 |
0.00031 |
0.00025 |
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 = 632 GROUP BY c.company_id
|
6 |
0.00023 |
0.00028 |
0.00025 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 632
|
6 |
0.00014 |
0.00022 |
0.00017 |
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 = 642 GROUP BY c.company_id
|
6 |
0.00024 |
0.00027 |
0.00026 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 640
|
6 |
0.00014 |
0.00022 |
0.00017 |
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 = 640 GROUP BY c.company_id
|
6 |
0.00022 |
0.00031 |
0.00025 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 642
|
6 |
0.00014 |
0.00022 |
0.00020 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 604
|
5 |
0.00014 |
0.00023 |
0.00017 |
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 = 604 GROUP BY c.company_id
|
5 |
0.00023 |
0.00027 |
0.00024 |
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 = 9476 GROUP BY c.company_id
|
5 |
0.00024 |
0.00027 |
0.00026 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 605
|
5 |
0.00014 |
0.00022 |
0.00018 |
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 = 605 GROUP BY c.company_id
|
5 |
0.00024 |
0.00029 |
0.00026 |
SELECT a.category_id FROM cscart_categories as a LEFT JOIN cscart_categories as b ON b.category_id IN (260) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
|
5 |
0.00035 |
0.00047 |
0.00040 |
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 = 9480 GROUP BY c.company_id
|
5 |
0.00026 |
0.00027 |
0.00027 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 873 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
5 |
0.00030 |
0.00036 |
0.00033 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 602
|
5 |
0.00014 |
0.00021 |
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.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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 258 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
5 |
0.00028 |
0.00032 |
0.00030 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 601
|
5 |
0.00016 |
0.00035 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 873 AND lang_code = 'se'
|
5 |
0.00013 |
0.00027 |
0.00019 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 278 AND lang_code = 'se'
|
5 |
0.00014 |
0.00020 |
0.00015 |
SELECT parent_id FROM cscart_categories WHERE category_id = 873
|
5 |
0.00013 |
0.00023 |
0.00015 |
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=100 AND d.lang_code='se' AND s.status='A'
|
5 |
0.00020 |
0.00024 |
0.00021 |
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 = 601 GROUP BY c.company_id
|
5 |
0.00024 |
0.00034 |
0.00028 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 258 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
5 |
0.00027 |
0.00032 |
0.00029 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 258 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 258 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
|
5 |
0.00031 |
0.00033 |
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 = 602 GROUP BY c.company_id
|
5 |
0.00022 |
0.00026 |
0.00025 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 278 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
5 |
0.00027 |
0.00030 |
0.00028 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 278 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
5 |
0.00028 |
0.00041 |
0.00031 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 278 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 278 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
|
5 |
0.00031 |
0.00046 |
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.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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 873 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
5 |
0.00027 |
0.00032 |
0.00030 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 873 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 873 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
|
5 |
0.00032 |
0.00042 |
0.00037 |
SELECT id_path FROM cscart_categories WHERE category_id IN (873, 375)
|
5 |
0.00025 |
0.00036 |
0.00030 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 9480
|
5 |
0.00015 |
0.00024 |
0.00020 |
SELECT COUNT(*) FROM cscart_products WHERE product_id = 9476
|
5 |
0.00014 |
0.00021 |
0.00018 |
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 243257228
|
4 |
0.00012 |
0.00015 |
0.00014 |
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 (15537, 15539)
|
4 |
0.00030 |
0.00059 |
0.00040 |
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 1840249526
|
4 |
0.00013 |
0.00021 |
0.00016 |
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 79349397
|
4 |
0.00016 |
0.00034 |
0.00025 |
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 2581651109
|
4 |
0.00012 |
0.00013 |
0.00012 |
SELECT price FROM cscart_product_options_inventory WHERE combination_hash = 2468730812
|
4 |
0.00012 |
0.00023 |
0.00017 |
SELECT id_path FROM cscart_categories WHERE category_id = 260
|
4 |
0.00016 |
0.00030 |
0.00021 |
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.00030 |
0.00068 |
0.00046 |
SELECT id_path FROM cscart_categories WHERE category_id IN (378)
|
3 |
0.00015 |
0.00022 |
0.00018 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 378 AND lang_code = 'se'
|
3 |
0.00015 |
0.00024 |
0.00021 |
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 632 ORDER BY exception_id
|
3 |
0.00017 |
0.00024 |
0.00021 |
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 630 ORDER BY exception_id
|
3 |
0.00017 |
0.00021 |
0.00019 |
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 624 ORDER BY exception_id
|
3 |
0.00015 |
0.00030 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 378 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
3 |
0.00027 |
0.00030 |
0.00029 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 378 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
3 |
0.00029 |
0.00031 |
0.00030 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 378 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 378 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
|
3 |
0.00030 |
0.00031 |
0.00031 |
SELECT parent_id FROM cscart_categories WHERE category_id = 378
|
3 |
0.00013 |
0.00024 |
0.00020 |
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 = 30
|
2 |
0.00018 |
0.00041 |
0.00030 |
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 = 46
|
2 |
0.00027 |
0.00039 |
0.00033 |
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 = 45
|
2 |
0.00019 |
0.00024 |
0.00021 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 948 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 996 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00016 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 995 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00018 |
0.00017 |
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 640 ORDER BY exception_id
|
2 |
0.00017 |
0.00022 |
0.00020 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 987 AND cscart_categories.company_id = 2
|
2 |
0.00016 |
0.00026 |
0.00021 |
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 642 ORDER BY exception_id
|
2 |
0.00017 |
0.00018 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 950 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00015 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 997 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00015 |
0.00015 |
SELECT parent_id FROM cscart_categories WHERE category_id = 379
|
2 |
0.00013 |
0.00021 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 369 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00019 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 994 AND cscart_categories.company_id = 2
|
2 |
0.00019 |
0.00020 |
0.00019 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 958 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00021 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 480 AND cscart_categories.company_id = 2
|
2 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 991 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00023 |
0.00019 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 986 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 928 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 989 AND cscart_categories.company_id = 2
|
2 |
0.00020 |
0.00020 |
0.00020 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 923 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00018 |
0.00016 |
SELECT * FROM cscart_product_options_exceptions WHERE product_id = 644 ORDER BY exception_id
|
2 |
0.00017 |
0.00023 |
0.00020 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 903 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 988 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00017 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 374 AND cscart_categories.company_id = 2
|
2 |
0.00013 |
0.00023 |
0.00018 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 993 AND cscart_categories.company_id = 2
|
2 |
0.00016 |
0.00031 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 926 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00016 |
0.00015 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 379 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 379 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
|
2 |
0.00030 |
0.00071 |
0.00051 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 379 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
2 |
0.00029 |
0.00057 |
0.00043 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 379 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
2 |
0.00028 |
0.00043 |
0.00036 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 992 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00026 |
0.00021 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 949 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 990 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00022 |
0.00018 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 263 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00036 |
0.00025 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 379 AND lang_code = 'se'
|
2 |
0.00013 |
0.00024 |
0.00018 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 951 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
|
2 |
0.00013 |
0.00034 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 955 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00020 |
0.00017 |
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.00027 |
0.00029 |
0.00028 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 933 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00017 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 957 AND cscart_categories.company_id = 2
|
2 |
0.00016 |
0.00017 |
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 = 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.00023 |
0.00025 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 953 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00015 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 359 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00016 |
0.00015 |
SELECT id_path FROM cscart_categories WHERE category_id IN (379)
|
2 |
0.00014 |
0.00015 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 960 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_countries WHERE code = 'SE' AND status = 'A'
|
2 |
0.00015 |
0.00056 |
0.00036 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 959 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 954 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00016 |
0.00015 |
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718252
|
2 |
0.00020 |
0.00024 |
0.00022 |
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.01597 |
0.01605 |
0.01601 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 365 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00015 |
0.00014 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND cscart_bm_layouts.company_id = 2 AND layout_id = 10
|
2 |
0.00024 |
0.00028 |
0.00026 |
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
|
2 |
0.00017 |
0.00025 |
0.00021 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 934 AND cscart_categories.company_id = 2
|
2 |
0.00013 |
0.00015 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 956 AND cscart_categories.company_id = 2
|
2 |
0.00015 |
0.00023 |
0.00019 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 952 AND cscart_categories.company_id = 2
|
2 |
0.00014 |
0.00015 |
0.00015 |
DELETE FROM cscart_access_restriction_block WHERE expires < 1751286937
|
2 |
0.00011 |
0.00017 |
0.00014 |
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751286937
|
2 |
0.00018 |
0.00036 |
0.00027 |
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 = 'se' WHERE ip_from <= 3628718252 AND ip_to >= 3628718252 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
|
2 |
0.00019 |
0.00041 |
0.00030 |
SELECT category_id FROM cscart_categories WHERE id_path LIKE '260/%'
|
2 |
0.00029 |
0.00029 |
0.00029 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 994 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 994 AND lang_code = 'se'
|
1 |
0.00019 |
0.00019 |
0.00019 |
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 = 'se' 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 = 'se' 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 '261/901/994/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
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 = 'se' 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 = 'se' 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 '261/901/993/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT id_path FROM cscart_categories WHERE category_id = 994
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT id_path FROM cscart_categories WHERE category_id = 993
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 993 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 992 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 934 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 993 AND company_id = 2
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 993 AND lang_code = 'se'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 994 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 986 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 995 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
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 = 'se' 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 = 'se' 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 '261/901/996/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 960 AND company_id = 2
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 997 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
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 = 'se' 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 = 'se' 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 '261/901/997/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT id_path FROM cscart_categories WHERE category_id = 997
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT id_path FROM cscart_categories WHERE category_id = 960
|
1 |
0.00012 |
0.00012 |
0.00012 |
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 = 'se' 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 = 'se' 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 '261/960/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 997 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 996 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 960 AND lang_code = 'se'
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 996 AND lang_code = 'se'
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT id_path FROM cscart_categories WHERE category_id = 996
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 368 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 996 AND company_id = 2
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 995 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 960 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 933 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 995 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT id_path FROM cscart_categories WHERE category_id = 933
|
1 |
0.00013 |
0.00013 |
0.00013 |
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 = 'se' 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 = 'se' 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 '368/933/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 933 AND lang_code = 'se'
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 992 AND lang_code = 'se'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT id_path FROM cscart_categories WHERE category_id = 995
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 933 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00028 |
0.00028 |
0.00028 |
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 = 'se' 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 = 'se' 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 '261/901/995/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
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 = 'se' 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 = 'se' 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 '368/934/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00048 |
0.00048 |
0.00048 |
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 = 'se' 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 = 'se' 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 '261/901/992/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 986 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 359 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT id_path FROM cscart_categories WHERE category_id = 359
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' 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 = 'se' 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 '261/901/359/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 359 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 988 AND lang_code = 'se'
|
1 |
0.00020 |
0.00020 |
0.00020 |
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 = 'se' 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 = 'se' 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 '261/901/988/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 988
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 988 AND company_id = 2
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 987 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 359 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT id_path FROM cscart_categories WHERE category_id = 986
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 988 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 987 AND lang_code = 'se'
|
1 |
0.00025 |
0.00025 |
0.00025 |
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 = 'se' 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 = 'se' 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 '261/901/987/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00044 |
0.00044 |
0.00044 |
SELECT id_path FROM cscart_categories WHERE category_id = 987
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 987 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 369 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' 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 = 'se' 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 '261/901/986/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 369 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
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 = 'se' 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 = 'se' 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 '261/901/369/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 369
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 997 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 369 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 901 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 989 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT id_path FROM cscart_categories WHERE category_id = 992
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 991 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 992 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT id_path FROM cscart_categories WHERE category_id = 934
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 986 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 934 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 991 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 934 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 991 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
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 = 'se' 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 = 'se' 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 '261/901/991/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT id_path FROM cscart_categories WHERE category_id = 991
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 365 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 990 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT id_path FROM cscart_categories WHERE category_id = 989
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT id_path FROM cscart_categories WHERE category_id = 365
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 990 AND lang_code = 'se'
|
1 |
0.00017 |
0.00017 |
0.00017 |
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 = 'se' 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 = 'se' 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 '261/901/365/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
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 = 'se' 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 = 'se' 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 '261/901/990/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00049 |
0.00049 |
0.00049 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 365 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT id_path FROM cscart_categories WHERE category_id = 990
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 990 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 989 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00033 |
0.00033 |
0.00033 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 989 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 365 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' 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 = 'se' 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 '261/901/989/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00048 |
0.00048 |
0.00048 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 510 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 281 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 499 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9480 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT filter_id, feature_id FROM cscart_product_filters INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_filters.filter_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_filters') WHERE status = 'A'
|
1 |
0.00037 |
0.00037 |
0.00037 |
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 = 'se' 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 = 'se' 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 = 601 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(375, f.categories_path) OR FIND_IN_SET(258, f.categories_path) OR FIND_IN_SET(278, f.categories_path) OR FIND_IN_SET(873, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00093 |
0.00093 |
0.00093 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 601 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT cscart_product_filters.filter_id, MIN(cscart_product_features_values.value_int) as min, MAX(cscart_product_features_values.value_int) as max FROM cscart_product_features_values LEFT JOIN cscart_products as products ON products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_features_values.feature_id 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 products.product_id = shared_descr.product_id 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 = 'se' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE cscart_product_filters.filter_id IN (13) AND cscart_product_features_values.feature_id IN (30) AND cscart_product_features_values.lang_code = 'se' AND cscart_categories.category_id IN (260, 265, 375, 385, 399, 382, 266, 400, 376, 401, 398, 377, 378, 374, 379, 380, 381) 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 cscart_product_features.feature_type IN ('N', 'O', 'D') GROUP BY cscart_product_features_values.feature_id
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT cscart_product_filters.filter_id FROM cscart_product_features_values LEFT JOIN cscart_products as products ON products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_features_values.feature_id 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 products.product_id = shared_descr.product_id 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 = 'se' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE cscart_product_filters.filter_id IN (13) AND cscart_product_features_values.feature_id IN (30) AND cscart_product_features_values.value = 'Y' AND cscart_product_features_values.lang_code = 'se' AND cscart_categories.category_id IN (260, 265, 375, 385, 399, 382, 266, 400, 376, 401, 398, 377, 378, 374, 379, 380, 381) 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 cscart_product_features.feature_type = 'C' GROUP BY cscart_product_features_values.feature_id
|
1 |
0.00044 |
0.00044 |
0.00044 |
SELECT cscart_product_feature_variants.variant_id, cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant FROM cscart_product_feature_variants LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variants.variant_id = cscart_product_feature_variant_descriptions.variant_id AND cscart_product_feature_variant_descriptions.lang_code = 'se' WHERE cscart_product_feature_variants.variant_id IN (5933) ORDER BY cscart_product_feature_variants.position ASC, cscart_product_feature_variant_descriptions.variant ASC
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT cscart_product_filters.filter_id, cscart_product_features_values.variant_id FROM cscart_product_features_values LEFT JOIN cscart_products as products ON products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_features_values.feature_id 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 products.product_id = shared_descr.product_id 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 = 'se' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE cscart_product_filters.filter_id IN (13) AND cscart_product_features_values.feature_id IN (30) AND cscart_product_features_values.lang_code = 'se' AND cscart_categories.category_id IN (260, 265, 375, 385, 399, 382, 266, 400, 376, 401, 398, 377, 378, 374, 379, 380, 381) 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 cscart_product_features.feature_type IN ('S', 'M', 'E') GROUP BY cscart_product_features_values.variant_id
|
1 |
0.07888 |
0.07888 |
0.07888 |
SELECT cscart_product_filters.feature_id, cscart_product_filters.filter_id,cscart_product_filters.field_type,cscart_product_filters.round_to,cscart_product_filters.display,cscart_product_filters.display_count,cscart_product_filter_descriptions.filter,cscart_product_features.feature_type,cscart_product_features_descriptions.prefix,cscart_product_features_descriptions.suffix FROM cscart_product_filters LEFT JOIN cscart_product_filter_descriptions ON cscart_product_filter_descriptions.filter_id = cscart_product_filters.filter_id AND cscart_product_filter_descriptions.lang_code = 'se' LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_filters.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = cscart_product_filters.feature_id AND cscart_product_features_descriptions.lang_code = 'se' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_product_filters.filter_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'product_filters') WHERE cscart_product_filters.status = 'A' AND (cscart_product_filters.categories_path = '' OR FIND_IN_SET(260, cscart_product_filters.categories_path)) ORDER BY cscart_product_filters.position, cscart_product_filter_descriptions.filter
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 917 AND cscart_categories.company_id = 2
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 497 AND cscart_categories.company_id = 2
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 867 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 865 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 496 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
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 = 'se' 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 = 'se' 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 = 9480 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(382, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00095 |
0.00095 |
0.00095 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 495 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 494 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 493 AND cscart_categories.company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 500 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 492 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 879 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 878 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 839 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 833 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 397 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 396 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 373 AND cscart_categories.company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 872 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 404 AND cscart_categories.company_id = 2
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT id_path FROM cscart_categories WHERE category_id IN (382)
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 624 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 389 AND cscart_categories.company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 632 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
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 = 68
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 67 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
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 = 67
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 69 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
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 = 69
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00026 |
0.00026 |
0.00026 |
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.00021 |
0.00021 |
0.00021 |
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 137 AND cscart_discussion.company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT thread_id, type, object_type FROM cscart_discussion WHERE 1 AND object_id = 260 AND object_type = 'C' AND cscart_discussion.company_id = 2
|
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 = 'se' 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 = 'se' 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 = 640 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(378, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00062 |
0.00062 |
0.00062 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 640 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
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 = 'se' 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 = 'se' 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 = 632 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(379, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00063 |
0.00063 |
0.00063 |
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 = 'se' 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 = 'se' 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 = 630 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(379, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00063 |
0.00063 |
0.00063 |
SELECT id_path FROM cscart_categories WHERE category_id IN (376)
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 630 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00025 |
0.00025 |
0.00025 |
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 = 'se' 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 = 'se' 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 = 602 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(375, f.categories_path) OR FIND_IN_SET(258, f.categories_path) OR FIND_IN_SET(278, f.categories_path) OR FIND_IN_SET(873, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00088 |
0.00088 |
0.00088 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 602 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
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 = 'se' 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 = 'se' 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 = 644 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(378, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00062 |
0.00062 |
0.00062 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 644 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
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 = 'se' 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 = 'se' 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 = 604 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(375, f.categories_path) OR FIND_IN_SET(258, f.categories_path) OR FIND_IN_SET(278, f.categories_path) OR FIND_IN_SET(873, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00089 |
0.00089 |
0.00089 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 604 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
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 = 'se' 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 = 'se' 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 = 642 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(378, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00071 |
0.00071 |
0.00071 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 642 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
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 = 'se' 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 = 'se' 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 = 9476 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(375, f.categories_path) OR FIND_IN_SET(258, f.categories_path) OR FIND_IN_SET(278, f.categories_path) OR FIND_IN_SET(873, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00100 |
0.00100 |
0.00100 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9476 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00126 |
0.00126 |
0.00126 |
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 = 'se' 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 = 'se' 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 = 605 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(375, f.categories_path) OR FIND_IN_SET(258, f.categories_path) OR FIND_IN_SET(278, f.categories_path) OR FIND_IN_SET(873, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00100 |
0.00100 |
0.00100 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 605 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00027 |
0.00027 |
0.00027 |
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 = 'se' 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 = 'se' 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 = 624 AND f.display_on_catalog = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(260, f.categories_path) OR FIND_IN_SET(374, f.categories_path) OR FIND_IN_SET(376, 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 = 'se' ORDER BY fd.description, fv.position
|
1 |
0.00076 |
0.00076 |
0.00076 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 388 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 387 AND cscart_categories.company_id = 2
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT id_path FROM cscart_categories WHERE category_id = 281
|
1 |
0.00013 |
0.00013 |
0.00013 |
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 = 'se' 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 = 'se' 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 '386/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00080 |
0.00080 |
0.00080 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 384 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 920 AND cscart_categories.company_id = 2
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 838 AND cscart_categories.company_id = 2
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 281 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00036 |
0.00036 |
0.00036 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 835 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 901 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 368 AND cscart_categories.company_id = 2
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 261 AND cscart_categories.company_id = 2
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(867, 492, 493, 497, 494, 865, 495, 917, 496, 499)
|
1 |
0.00025 |
0.00025 |
0.00025 |
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 = 'se' 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 = 'se' 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 '500/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00076 |
0.00076 |
0.00076 |
SELECT id_path FROM cscart_categories WHERE category_id = 500
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 500 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(397, 879, 839, 259, 387, 389, 388, 404, 396, 872, 373, 856, 833, 878)
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT id_path FROM cscart_categories WHERE category_id = 386
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 279 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 386 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(383, 913, 273, 274, 370, 912, 296, 914, 905, 275, 278, 277, 276, 906, 352)
|
1 |
0.00026 |
0.00026 |
0.00026 |
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 = 'se' 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 = 'se' 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 '258/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00079 |
0.00079 |
0.00079 |
SELECT id_path FROM cscart_categories WHERE category_id = 258
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 258 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(385, 399, 375, 382, 400, 376, 401, 378, 379, 374)
|
1 |
0.00025 |
0.00025 |
0.00025 |
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 = 'se' 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 = 'se' 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 '260/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00070 |
0.00070 |
0.00070 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 260 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(510, 518, 395, 384, 371, 279, 405, 280, 372, 410, 394, 884, 406, 894)
|
1 |
0.00025 |
0.00025 |
0.00025 |
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 = 'se' 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 = 'se' 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 '257/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00077 |
0.00077 |
0.00077 |
SELECT id_path FROM cscart_categories WHERE category_id = 257
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 257 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(835, 838, 920)
|
1 |
0.00018 |
0.00018 |
0.00018 |
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 = 'se' 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 = 'se' 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 '281/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00055 |
0.00055 |
0.00055 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 257 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 405 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 386 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 274 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 259 AND cscart_categories.company_id = 2
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 914 AND cscart_categories.company_id = 2
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 383 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 276 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 906 AND cscart_categories.company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 905 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 370 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 278 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 913 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 912 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 352 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 277 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 275 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 296 AND cscart_categories.company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 273 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 410 AND cscart_categories.company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 379 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 378 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 376 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 382 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 375 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 395 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 394 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 894 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 406 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 372 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 371 AND cscart_categories.company_id = 2
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 518 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 280 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 884 AND cscart_categories.company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 958 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' 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 = 'se' 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 '261/952/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00044 |
0.00044 |
0.00044 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 958 AND lang_code = 'se'
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 9476
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 604
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT list_price FROM cscart_products WHERE product_id = 642
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT * FROM cscart_product_options_inventory WHERE product_id = 642 AND combination_hash = '243257228'
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 642
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='243257228'
|
1 |
0.00025 |
0.00025 |
0.00025 |
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 (1218)
|
1 |
0.00020 |
0.00020 |
0.00020 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 243257228 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00028 |
0.00028 |
0.00028 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 243257228 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 243257228
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 243257228
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 642
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT product_code, amount FROM cscart_product_options_inventory WHERE combination_hash = 243257228
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT combination FROM cscart_product_options_inventory WHERE product_id = 642 AND amount > 0 AND combination != ''
|
1 |
0.00039 |
0.00039 |
0.00039 |
SELECT MIN(price) as min_price, MAX(price) as max_price FROM cscart_product_options_inventory WHERE product_id = 642 AND price > 0 GROUP BY product_id
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 605
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT combination FROM cscart_product_options_inventory WHERE product_id = 644 AND amount > 0 AND combination != ''
|
1 |
0.00039 |
0.00039 |
0.00039 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 624
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='2963655330'
|
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 376 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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 376 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00059 |
0.00059 |
0.00059 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 376 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 376 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.00058 |
0.00058 |
0.00058 |
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 (664, 665)
|
1 |
0.00027 |
0.00027 |
0.00027 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2963655330 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2963655330 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 2963655330
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 2963655330
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 624
|
1 |
0.00034 |
0.00034 |
0.00034 |
SELECT inventory FROM cscart_product_options WHERE option_id = 665
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT inventory FROM cscart_product_options WHERE option_id = 664
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 9480
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT MIN(price) as min_price, MAX(price) as max_price FROM cscart_product_options_inventory WHERE product_id = 644 AND price > 0 GROUP BY product_id
|
1 |
0.00031 |
0.00031 |
0.00031 |
SELECT product_code, amount FROM cscart_product_options_inventory WHERE combination_hash = 1840249526
|
1 |
0.00013 |
0.00013 |
0.00013 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 382 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00032 |
0.00032 |
0.00032 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2468730812 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT * FROM cscart_product_options_inventory WHERE product_id = 632 AND combination_hash = '79349397'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 632
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='79349397'
|
1 |
0.00028 |
0.00028 |
0.00028 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 79349397 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 79349397 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 79349397
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 79349397
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 632
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT product_code, amount FROM cscart_product_options_inventory WHERE combination_hash = 79349397
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT MIN(price) as min_price, MAX(price) as max_price FROM cscart_product_options_inventory WHERE product_id = 632 AND price > 0 GROUP BY product_id
|
1 |
0.00035 |
0.00035 |
0.00035 |
SELECT list_price FROM cscart_products WHERE product_id = 630
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT * FROM cscart_product_options_inventory WHERE product_id = 630 AND combination_hash = '2468730812'
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 630
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='2468730812'
|
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2468730812 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 644
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 2468730812
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 2468730812
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 630
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT product_code, amount FROM cscart_product_options_inventory WHERE combination_hash = 2468730812
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT MIN(price) as min_price, MAX(price) as max_price FROM cscart_product_options_inventory WHERE product_id = 630 AND price > 0 GROUP BY product_id
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 602
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT list_price FROM cscart_products WHERE product_id = 644
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT * FROM cscart_product_options_inventory WHERE product_id = 644 AND combination_hash = '1840249526'
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 644
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='1840249526'
|
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1840249526 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00027 |
0.00027 |
0.00027 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1840249526 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00031 |
0.00031 |
0.00031 |
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 1840249526
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 1840249526
|
1 |
0.00024 |
0.00024 |
0.00024 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 382 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00030 |
0.00030 |
0.00030 |
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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 382 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 382 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.00034 |
0.00034 |
0.00034 |
SELECT MIN(price) as min_price, MAX(price) as max_price FROM cscart_product_options_inventory WHERE product_id = 640 AND price > 0 GROUP BY product_id
|
1 |
0.00031 |
0.00031 |
0.00031 |
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.00048 |
0.00048 |
0.00048 |
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 = 'se' AND lang.name = 'filter_description_label7'
|
1 |
0.00017 |
0.00017 |
0.00017 |
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 = 'se' AND lang.name = 'filter_description_label3'
|
1 |
0.00017 |
0.00017 |
0.00017 |
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 = 'se' AND lang.name = 'filter_description_label2'
|
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 = 'se' WHERE l.layout_id = 10 AND l.dispatch = 'categories.view' AND (FIND_IN_SET(260, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00033 |
0.00033 |
0.00033 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
|
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 = 'se' 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.00048 |
0.00048 |
0.00048 |
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.00028 |
0.00028 |
0.00028 |
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND cscart_bm_layouts.company_id = 2 AND is_default = 1 AND theme_name = 'responsive'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT companies.* FROM cscart_companies AS companies WHERE companies.company_id = 2
|
1 |
0.00030 |
0.00030 |
0.00030 |
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 = 'se' WHERE 1 AND a.is_primary = 'Y' ORDER BY a.position
|
1 |
0.00022 |
0.00022 |
0.00022 |
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 = 'se' 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.00032 |
0.00032 |
0.00032 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 260 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00031 |
0.00031 |
0.00031 |
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.00035 |
0.00035 |
0.00035 |
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 = 'se' AND lang.name = 'filter_description_label1'
|
1 |
0.00017 |
0.00017 |
0.00017 |
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.00024 |
0.00024 |
0.00024 |
SELECT * FROM cscart_seo_names WHERE name = 'tak' AND cscart_seo_names.company_id IN (0, 2) AND lang_code = 'se'
|
1 |
0.00035 |
0.00035 |
0.00035 |
SELECT type FROM cscart_seo_names WHERE name = 'tak' AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0)
|
1 |
0.00081 |
0.00081 |
0.00081 |
SET time_zone = '+02:00'
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT entry_page FROM cscart_companies WHERE company_id = 2 AND redirect_customer != 'Y'
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT company_id FROM cscart_companies WHERE 1 AND status IN ('A', 'P', 'N')
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT company_id FROM cscart_companies WHERE 1 AND company_id IN (2) AND status IN ('A', 'P', 'N')
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 2
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?byggbay.se'
|
1 |
0.00023 |
0.00023 |
0.00023 |
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.00022 |
0.00022 |
0.00022 |
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.00027 |
0.00027 |
0.00027 |
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.00022 |
0.00022 |
0.00022 |
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.00027 |
0.00027 |
0.00027 |
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.00060 |
0.00060 |
0.00060 |
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 = 'se' AND lang.name = 'filter_description_label5'
|
1 |
0.00016 |
0.00016 |
0.00016 |
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 = 'se' AND lang.name = 'filter_description_label4'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 601
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names WHERE cscart_seo_names.object_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'se' AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0)
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT tax FROM cscart_tax_descriptions WHERE tax_id = 6 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
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 = 'se' 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 <= 1751286937, 1) AND IF(to_date, to_date >= 1751286937, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc
|
1 |
0.00081 |
0.00081 |
0.00081 |
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 = 'se' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (15537, 15538, 22769, 22770, 22771, 22772, 22773, 22774, 22775, 22776, 15539, 15540, 15541, 15542, 15543, 15544) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00058 |
0.00058 |
0.00058 |
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 = 'se' WHERE cscart_images_links.object_type = 'variant_image' AND cscart_images_links.type = 'V' AND cscart_images_links.object_id IN (15537, 15538, 22769, 22770, 22771, 22772, 22773, 22774, 22775, 22776, 15539, 15540, 15541, 15542, 15543, 15544) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00059 |
0.00059 |
0.00059 |
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 = 'se' 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 (664, 665, 1218) AND a.status='A' ORDER BY a.position, a.variant_id
|
1 |
0.00059 |
0.00059 |
0.00059 |
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 = 'se' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
|
1 |
0.00091 |
0.00091 |
0.00091 |
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 = 'se' WHERE a.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND status = 'A' ORDER BY a.position
|
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 = 'se' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00056 |
0.00056 |
0.00056 |
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 = 'se' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00066 |
0.00066 |
0.00066 |
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 = 'se' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00081 |
0.00081 |
0.00081 |
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 = 'se' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00067 |
0.00067 |
0.00067 |
SELECT cscart_ult_product_prices.product_id, MIN(IF(cscart_ult_product_prices.percentage_discount = 0,cscart_ult_product_prices.price,cscart_ult_product_prices.price - (cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount)/100)) AS price FROM cscart_ult_product_prices WHERE cscart_ult_product_prices.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND cscart_ult_product_prices.lower_limit = 1 AND cscart_ult_product_prices.company_id = 2 AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1) GROUP BY cscart_ult_product_prices.product_id
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT cscart_ult_product_descriptions.product_id, cscart_ult_product_descriptions.short_description, IF(cscart_ult_product_descriptions.short_description = "", cscart_ult_product_descriptions.full_description, "") AS full_description, cscart_ult_product_descriptions.meta_keywords, cscart_ult_product_descriptions.meta_description, cscart_ult_product_descriptions.search_words, cscart_ult_product_descriptions.promo_text FROM cscart_ult_product_descriptions WHERE cscart_ult_product_descriptions.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND cscart_ult_product_descriptions.company_id = 2 AND cscart_ult_product_descriptions.lang_code = 'se'
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND cscart_discussion.object_type = "P" AND cscart_discussion.company_id = 2 GROUP BY cscart_discussion.object_id
|
1 |
0.00044 |
0.00044 |
0.00044 |
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids, product_position_source.position AS position FROM cscart_products_categories 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_categories.status IN ('A', 'H') LEFT JOIN cscart_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 260 WHERE cscart_products_categories.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) GROUP BY cscart_products_categories.product_id
|
1 |
0.00084 |
0.00084 |
0.00084 |
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 = 'se' AND lang.name = 'filter_description_label8'
|
1 |
0.00021 |
0.00021 |
0.00021 |
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 = 'se' 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 = 'se' 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.parent_id IN (260) AND cscart_categories.id_path LIKE '260/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00084 |
0.00084 |
0.00084 |
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 = 'se' AND lang.name = 'filter_description_label9'
|
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 = 'se' AND lang.name = 'filter_description_label10'
|
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 = 'se' AND lang.name = 'filter_description_label6'
|
1 |
0.00021 |
0.00021 |
0.00021 |
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 = 'se' 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.00041 |
0.00041 |
0.00041 |
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 = 'se' 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.00041 |
0.00041 |
0.00041 |
SELECT category_id FROM cscart_categories WHERE category_id = 260 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.company_id = 2
|
1 |
0.00043 |
0.00043 |
0.00043 |
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(374)
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.short_description, IF(cscart_product_descriptions.short_description = '', cscart_product_descriptions.full_description, '') AS full_description, cscart_product_descriptions.meta_keywords, cscart_product_descriptions.meta_description, cscart_product_descriptions.search_words, cscart_product_descriptions.promo_text FROM cscart_product_descriptions WHERE cscart_product_descriptions.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND cscart_product_descriptions.lang_code = 'se'
|
1 |
0.00046 |
0.00046 |
0.00046 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (374) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00032 |
0.00032 |
0.00032 |
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 = 'se' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (374) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT *, 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 = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 260 AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' AND cscart_seo_names.company_id = cscart_categories.company_id WHERE cscart_categories.category_id = 260 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.00036 |
0.00036 |
0.00036 |
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(shared_descr.product_id IS NOT NULL, shared_descr.youtube_link, products.youtube_link) AS youtube_link, cscart_aval_statuses_descr.descr as aval_descr FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'se' 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 = 'se' 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 = 'se' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1 AND cscart_categories.category_id IN (260, 265, 375, 385, 399, 382, 266, 400, 376, 401, 398, 377, 378, 374, 379, 380, 381) 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 popularity.total desc, product_id ASC LIMIT 12, 12
|
1 |
0.03485 |
0.03485 |
0.03485 |
SELECT cscart_products.* FROM cscart_products WHERE cscart_products.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640)
|
1 |
0.00051 |
0.00051 |
0.00051 |
SELECT cscart_product_prices.product_id, 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 FROM cscart_product_prices WHERE cscart_product_prices.product_id IN (601, 9480, 624, 605, 9476, 642, 604, 644, 602, 630, 632, 640) AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1) GROUP BY cscart_product_prices.product_id
|
1 |
0.00043 |
0.00043 |
0.00043 |
SELECT list_price FROM cscart_products WHERE product_id = 632
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT combination FROM cscart_product_options_inventory WHERE product_id = 640 AND amount > 0 AND combination != ''
|
1 |
0.00045 |
0.00045 |
0.00045 |
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 = 'se' 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 = 'se' 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 '261/958/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
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 = 'se' 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 = 'se' 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 '261/948/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 952
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 952 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 951 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 951 AND lang_code = 'se'
|
1 |
0.00015 |
0.00015 |
0.00015 |
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 = 'se' 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 = 'se' 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 '261/951/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT id_path FROM cscart_categories WHERE category_id = 951
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 951 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 950 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 950 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
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 = 'se' 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 = 'se' 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 '261/950/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT id_path FROM cscart_categories WHERE category_id = 950
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 950 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 948 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 948 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT id_path FROM cscart_categories WHERE category_id = 948
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 952 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 948 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 949 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 949 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
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 = 'se' 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 = 'se' 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 '261/949/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT id_path FROM cscart_categories WHERE category_id = 949
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 949 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 903 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 903 AND lang_code = 'se'
|
1 |
0.00017 |
0.00017 |
0.00017 |
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 = 'se' 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 = 'se' 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 '261/903/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 903
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 903 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 928 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 928 AND lang_code = 'se'
|
1 |
0.00015 |
0.00015 |
0.00015 |
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 = 'se' 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 = 'se' 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 '261/928/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 952 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 928 AND company_id = 2
|
1 |
0.00019 |
0.00019 |
0.00019 |
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 = 'se' 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 = 'se' 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 '261/956/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 958
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 958 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 959 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00034 |
0.00034 |
0.00034 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 959 AND lang_code = 'se'
|
1 |
0.00015 |
0.00015 |
0.00015 |
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 = 'se' 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 = 'se' 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 '261/959/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 959
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 959 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 957 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 957 AND lang_code = 'se'
|
1 |
0.00016 |
0.00016 |
0.00016 |
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 = 'se' 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 = 'se' 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 '261/957/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00046 |
0.00046 |
0.00046 |
SELECT id_path FROM cscart_categories WHERE category_id = 957
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 957 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 956 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 956 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT id_path FROM cscart_categories WHERE category_id = 956
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 953 AND company_id = 2
|
1 |
0.00014 |
0.00014 |
0.00014 |
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 = 'se' 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 = 'se' 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 '261/954/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 953
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' 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 = 'se' 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 '261/953/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 953 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 953 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 954 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT id_path FROM cscart_categories WHERE category_id = 954
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 954 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 956 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 954 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 955 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT id_path FROM cscart_categories WHERE category_id = 955
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' 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 = 'se' 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 '261/955/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 955 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 955 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT id_path FROM cscart_categories WHERE category_id = 928
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 923 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT product_code, amount FROM cscart_product_options_inventory WHERE combination_hash = 2581651109
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 376 AND lang_code = 'se'
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 427
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
|
1 |
0.00049 |
0.00049 |
0.00049 |
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 260
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 640 AND lang_code = 'se'
|
1 |
0.00054 |
0.00054 |
0.00054 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 632 AND lang_code = 'se'
|
1 |
0.00050 |
0.00050 |
0.00050 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 630 AND lang_code = 'se'
|
1 |
0.00050 |
0.00050 |
0.00050 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 602 AND lang_code = 'se'
|
1 |
0.00052 |
0.00052 |
0.00052 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 644 AND lang_code = 'se'
|
1 |
0.00057 |
0.00057 |
0.00057 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 604 AND lang_code = 'se'
|
1 |
0.00053 |
0.00053 |
0.00053 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 642 AND lang_code = 'se'
|
1 |
0.00054 |
0.00054 |
0.00054 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 9476 AND lang_code = 'se'
|
1 |
0.00051 |
0.00051 |
0.00051 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 605 AND lang_code = 'se'
|
1 |
0.00052 |
0.00052 |
0.00052 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 624 AND lang_code = 'se'
|
1 |
0.00058 |
0.00058 |
0.00058 |
SELECT parent_id FROM cscart_categories WHERE category_id = 376
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT c.*, IF (c.location_id != 427, 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.00177 |
0.00177 |
0.00177 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 9480 AND lang_code = 'se'
|
1 |
0.00059 |
0.00059 |
0.00059 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 382 AND lang_code = 'se'
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT parent_id FROM cscart_categories WHERE category_id = 382
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT variant_id FROM cscart_product_features_values WHERE feature_id = 30 AND product_id = 601 AND lang_code = 'se'
|
1 |
0.00053 |
0.00053 |
0.00053 |
SELECT company FROM cscart_companies WHERE company_id = 1
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT list_price FROM cscart_products WHERE product_id = 640
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT * FROM cscart_product_options_inventory WHERE product_id = 640 AND combination_hash = '2581651109'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT * FROM cscart_product_sd_labels WHERE product_id = 640
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT min_qty, max_qty, qty_step, list_qty_count FROM cscart_product_options_inventory WHERE combination_hash='2581651109'
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2581651109 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00027 |
0.00027 |
0.00027 |
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 = 'se' WHERE cscart_images_links.object_type = 'product_option' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2581651109 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00028 |
0.00028 |
0.00028 |
SELECT min_qty, max_qty, qty_step FROM cscart_product_options_inventory WHERE combination_hash = 2581651109
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT aval_status FROM cscart_product_options_inventory WHERE combination_hash = 2581651109
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT COUNT(*) FROM cscart_product_options_inventory WHERE product_id = 640
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 427
|
1 |
0.00023 |
0.00023 |
0.00023 |
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, 1556, 1533) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00053 |
0.00053 |
0.00053 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 923 AND lang_code = 'se'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 480 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00026 |
0.00026 |
0.00026 |
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 = 'se' 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 = 'se' 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 '261/923/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT id_path FROM cscart_categories WHERE category_id = 923
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 923 AND company_id = 2
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 926 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 926 AND lang_code = 'se'
|
1 |
0.00017 |
0.00017 |
0.00017 |
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 = 'se' 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 = 'se' 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 '261/926/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00072 |
0.00072 |
0.00072 |
SELECT id_path FROM cscart_categories WHERE category_id = 926
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 926 AND company_id = 2
|
1 |
0.00043 |
0.00043 |
0.00043 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 263 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 263 AND lang_code = 'se'
|
1 |
0.00021 |
0.00021 |
0.00021 |
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 = 'se' 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 = 'se' 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 '261/263/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT id_path FROM cscart_categories WHERE category_id = 263
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 263 AND company_id = 2
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 261 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'se' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT category FROM cscart_category_descriptions WHERE category_id = 480 AND lang_code = 'se'
|
1 |
0.00017 |
0.00017 |
0.00017 |
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 'categories' 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 = 260 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (1958, 1959, 1960, 1961, 1962, 1985, 1986, 1987, 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='se' AND cscart_bm_blocks.company_id = 2 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00242 |
0.00242 |
0.00242 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 46 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00033 |
0.00033 |
0.00033 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 260 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' AND cscart_seo_names.company_id IN (0, 2)
|
1 |
0.00034 |
0.00034 |
0.00034 |
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 = 'se' 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.00040 |
0.00040 |
0.00040 |
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 2 AND status = 'A' ORDER BY `position`;
|
1 |
0.00028 |
0.00028 |
0.00028 |
SELECT status FROM cscart_menus WHERE menu_id = 1
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT * FROM cscart_menus LEFT JOIN cscart_menus_descriptions ON cscart_menus.menu_id = cscart_menus_descriptions.menu_id WHERE cscart_menus_descriptions.lang_code = 'se' AND cscart_menus.company_id = 2 AND cscart_menus.menu_id = 1 AND cscart_menus.company_id = 2
|
1 |
0.00024 |
0.00024 |
0.00024 |
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 = 'se' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '1' ORDER BY sd.position
|
1 |
0.00070 |
0.00070 |
0.00070 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 45 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00033 |
0.00033 |
0.00033 |
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 = 'se' 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 = 'se' 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 '261/480/%' AND cscart_categories.company_id = 2 ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc
|
1 |
0.00048 |
0.00048 |
0.00048 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT status FROM cscart_menus WHERE menu_id = 9
|
1 |
0.00038 |
0.00038 |
0.00038 |
SELECT * FROM cscart_menus LEFT JOIN cscart_menus_descriptions ON cscart_menus.menu_id = cscart_menus_descriptions.menu_id WHERE cscart_menus_descriptions.lang_code = 'se' AND cscart_menus.company_id = 2 AND cscart_menus.menu_id = 9 AND cscart_menus.company_id = 2
|
1 |
0.00024 |
0.00024 |
0.00024 |
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 = 'se' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '9' ORDER BY sd.position
|
1 |
0.00085 |
0.00085 |
0.00085 |
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 480 AND company_id = 2
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT id_path FROM cscart_categories WHERE category_id = 480
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 70 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00022 |
0.00022 |
0.00022 |