Queries total time: 0.19657 s.
Query Time
1
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
0.00029
2
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
0.00028
3
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
0.00062
4
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'storage' 
0.00021
5
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 2725 ORDER BY cscart_settings_objects.position
0.00026
6
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'cdn' 
0.00029
7
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 294 ORDER BY cscart_settings_objects.position
0.00028
8
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?baubay.de'
0.00023
9
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1
0.00017
10
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (1) AND status IN ('A', 'P', 'N')
0.00019
11
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
0.00017
12
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
0.00014
13
SET time_zone = '+02:00'
0.00016
14
SELECT type FROM cscart_seo_names WHERE name = 'paneele-verlegen-wie-man-3d-holzpaneele-richtig-montiert-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
0.00044
15
SELECT * FROM cscart_seo_names WHERE name = 'paneele-verlegen-wie-man-3d-holzpaneele-richtig-montiert-en'  AND lang_code = 'de'
0.00037
16
SELECT * FROM cscart_seo_names WHERE name = 'paneele-verlegen-wie-man-3d-holzpaneele-richtig-montiert-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
0.00037
17
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00026
18
SELECT * FROM cscart_settings_sections WHERE name = 'seo' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
0.00026
19
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND section_id = '287' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
0.00041
20
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00020
21
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 80 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00033
22
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00032
23
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
0.00036
24
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en'  WHERE 1  AND a.is_primary = 'Y' ORDER BY a.position
0.00027
25
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 1 
0.00026
26
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 
0.00026
27
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
0.00026
28
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00023
29
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 
0.00026
30
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
0.00034
31
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
0.00045
32
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718145
0.00044
33
DELETE FROM cscart_access_restriction_block WHERE expires < 1751307431
0.00055
34
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751307431
0.00059
35
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE ip_from <= 3628718145 AND ip_to >= 3628718145 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
0.00079
36
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
0.00075
37
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718145
0.00063
38
DELETE FROM cscart_access_restriction_block WHERE expires < 1751307431
0.00069
39
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751307431
0.00047
40
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE ip_from <= 3628718145 AND ip_to >= 3628718145 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
0.00028
41
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
0.00013
42
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
0.00018
43
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 2, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Baubay', 1, 0))  AND company_id = 1
0.00025
44
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (75, 72, 73, 74) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00049
45
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
0.00021
46
SELECT page_type FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00029
47
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 2
0.00022
48
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 2  AND l.dispatch = 'pages.view?page_type=B' AND (FIND_IN_SET(80, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
0.00033
49
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc 
0.00041
50
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label7'
0.00025
51
SELECT FOUND_ROWS()
0.00010
52
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label4'
0.00018
53
SELECT FOUND_ROWS()
0.00011
54
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label10'
0.00023
55
SELECT FOUND_ROWS()
0.00008
56
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label5'
0.00023
57
SELECT FOUND_ROWS()
0.00008
58
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label3'
0.00016
59
SELECT FOUND_ROWS()
0.00011
60
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label1'
0.00017
61
SELECT FOUND_ROWS()
0.00011
62
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label8'
0.00017
63
SELECT FOUND_ROWS()
0.00008
64
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label9'
0.00027
65
SELECT FOUND_ROWS()
0.00024
66
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label2'
0.00017
67
SELECT FOUND_ROWS()
0.00010
68
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label6'
0.00018
69
SELECT FOUND_ROWS()
0.00011
70
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc 
0.00037
71
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00039
72
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00036
73
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 80 AND cscart_page_descriptions.lang_code = 'en'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F') 
0.00054
74
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'blog' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 80 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00035
75
SELECT CONCAT(u.firstname, ' ', u.lastname) FROM cscart_blog_authors as b LEFT JOIN cscart_users  as u ON b.user_id = u.user_id WHERE b.page_id = 80
0.00028
76
SELECT * FROM cscart_image_gallery_settings WHERE id=80 AND type='C'
0.00023
77
SELECT description FROM cscart_image_gallery_settings_description WHERE id = 80 AND lang_code = 'en' AND type = 'C'
0.00017
78
SELECT * FROM cscart_image_gallery_settings WHERE id=80 AND type='C'
0.00020
79
SELECT SQL_CALC_FOUND_ROWS cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 80 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id DESC  LIMIT 0, 12
0.00032
80
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 80 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id 
0.00033
81
SELECT FOUND_ROWS()
0.01257
82
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00024
83
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00222
84
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 55 AND cscart_page_descriptions.lang_code = 'en'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F') 
0.00050
85
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'blog' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 55 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00032
86
SELECT CONCAT(u.firstname, ' ', u.lastname) FROM cscart_blog_authors as b LEFT JOIN cscart_users  as u ON b.user_id = u.user_id WHERE b.page_id = 55
0.00024
87
SELECT * FROM cscart_image_gallery_settings WHERE id=55 AND type='C'
0.00034
88
SELECT * FROM cscart_image_gallery_settings WHERE id=55 AND type='C'
0.00021
89
SELECT SQL_CALC_FOUND_ROWS cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 55 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id DESC  LIMIT 0, 12
0.00031
90
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 55 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id 
0.00185
91
SELECT FOUND_ROWS()
0.00014
92
SELECT * FROM cscart_settings_sections WHERE name = 'social_buttons' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
0.00029
93
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND section_id = '317' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
0.00092
94
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00021
95
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00024
96
SELECT * FROM cscart_settings_sections WHERE name = 'social_buttons' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
0.00120
97
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND section_id = '317' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
0.00094
98
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
0.00015
99
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 
0.00020
100
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
0.00032
101
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00025
102
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 2, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Baubay', 1, 0))  AND company_id = 1
0.00020
103
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (75, 72, 73, 74) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00050
104
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 
0.00028
105
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
0.00032
106
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00026
107
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 2, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Baubay', 1, 0))  AND company_id = 1
0.00020
108
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (75, 72, 73, 74) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00048
109
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00028
110
SELECT * FROM cscart_settings_sections WHERE name = 'social_buttons' AND type = 'ADDON'  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
0.00030
111
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND section_id = '317' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
0.00087
112
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 
0.00043
113
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
0.00047
114
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00025
115
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 2, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Baubay', 1, 0))  AND company_id = 1
0.00026
116
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (75, 72, 73, 74) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00055
117
SELECT COUNT(DISTINCT(cscart_pages.page_id)) FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.parent_id IN (80) AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('B') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1751307431 AND avail_till_timestamp >= 1751307431)) ORDER BY cscart_pages.timestamp desc
0.00042
118
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.parent_id IN (80) AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('B') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1751307431 AND avail_till_timestamp >= 1751307431)) ORDER BY cscart_pages.timestamp desc  LIMIT 0, 10
0.00049
119
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 55 
0.00027
120
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00040
121
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00034
122
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 80
0.00027
123
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
0.00110
124
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00034
125
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00034
126
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00027
127
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00030
128
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
0.00026
129
SELECT page_type FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00030
130
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 2
0.00023
131
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 325
0.00042
132
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 325
0.00017
133
SELECT c.*, IF (c.location_id != 325, 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 = 2 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
0.00191
134
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 (906, 907, 1148, 909) ORDER BY g.order, g.parent_id, g.grid_id ASC
0.00054
135
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 'pages' 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 = 80 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (1118, 1119, 1120, 1121, 1122, 1411, 1412, 1413, 2042, 2054, 2055, 1143, 2056, 1144, 2182, 1136, 1141, 2217, 1137, 1130, 1132, 1138, 1142, 1131, 1139, 1135, 1140)  AND cscart_bm_blocks_descriptions.lang_code='en'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
0.00257
136
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00026
137
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00220
138
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00033
139
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00026
140
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00020
141
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 80 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'de' 
0.00025
142
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY `position`;
0.00031
143
SELECT status FROM cscart_menus WHERE menu_id = 3
0.02046
144
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 = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 3 AND cscart_menus.company_id = 1
0.00157
145
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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position
0.00094
146
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 77 
0.00058
147
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 77 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00037
148
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 47 
0.00032
149
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 47 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00030
150
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 48 
0.00023
151
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 48 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00025
152
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 51 
0.00023
153
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 51 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00024
154
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 55 
0.00040
155
SELECT status FROM cscart_menus WHERE menu_id = 7
0.00025
156
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 = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 7 AND cscart_menus.company_id = 1
0.00020
157
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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '7' ORDER BY sd.position
0.00099
158
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND company_id = 1
0.00025
159
SELECT id_path FROM cscart_categories WHERE category_id = 482
0.00042
160
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 = 'en'  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 = 'en'  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 '412/482/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00062
161
SELECT category FROM cscart_category_descriptions WHERE category_id = 482 AND lang_code = 'en'
0.00023
162
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND cscart_categories.company_id = 1
0.00015
163
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 482 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00022
164
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 412 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
165
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND company_id = 1
0.00021
166
SELECT id_path FROM cscart_categories WHERE category_id = 432
0.00015
167
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 = 'en'  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 = 'en'  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 '412/432/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00051
168
SELECT category FROM cscart_category_descriptions WHERE category_id = 432 AND lang_code = 'en'
0.00024
169
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND cscart_categories.company_id = 1
0.00020
170
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 432 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00026
171
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND company_id = 1
0.00019
172
SELECT id_path FROM cscart_categories WHERE category_id = 925
0.00012
173
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 = 'en'  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 = 'en'  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 '412/925/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00052
174
SELECT category FROM cscart_category_descriptions WHERE category_id = 925 AND lang_code = 'en'
0.00020
175
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND cscart_categories.company_id = 1
0.00014
176
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 925 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
177
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND company_id = 1
0.00020
178
SELECT id_path FROM cscart_categories WHERE category_id = 922
0.00013
179
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 = 'en'  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 = 'en'  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 '412/922/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00049
180
SELECT category FROM cscart_category_descriptions WHERE category_id = 922 AND lang_code = 'en'
0.00022
181
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND cscart_categories.company_id = 1
0.00014
182
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 922 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
183
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND company_id = 1
0.00014
184
SELECT id_path FROM cscart_categories WHERE category_id = 929
0.00012
185
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 = 'en'  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 = 'en'  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 '412/929/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00048
186
SELECT category FROM cscart_category_descriptions WHERE category_id = 929 AND lang_code = 'en'
0.00020
187
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND cscart_categories.company_id = 1
0.00020
188
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 929 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00028
189
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND company_id = 1
0.00018
190
SELECT id_path FROM cscart_categories WHERE category_id = 890
0.00021
191
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 = 'en'  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 = 'en'  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 '412/890/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00050
192
SELECT category FROM cscart_category_descriptions WHERE category_id = 890 AND lang_code = 'en'
0.00019
193
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND cscart_categories.company_id = 1
0.00014
194
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 890 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
195
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND company_id = 1
0.00021
196
SELECT id_path FROM cscart_categories WHERE category_id = 937
0.00023
197
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 = 'en'  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 = 'en'  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 '412/937/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00055
198
SELECT category FROM cscart_category_descriptions WHERE category_id = 937 AND lang_code = 'en'
0.00020
199
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND cscart_categories.company_id = 1
0.00015
200
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 937 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
201
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND company_id = 1
0.00019
202
SELECT id_path FROM cscart_categories WHERE category_id = 938
0.00023
203
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 = 'en'  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 = 'en'  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 '412/938/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00054
204
SELECT category FROM cscart_category_descriptions WHERE category_id = 938 AND lang_code = 'en'
0.00021
205
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND cscart_categories.company_id = 1
0.00014
206
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 938 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00026
207
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND company_id = 1
0.00023
208
SELECT id_path FROM cscart_categories WHERE category_id = 939
0.00023
209
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 = 'en'  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 = 'en'  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 '412/939/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00052
210
SELECT category FROM cscart_category_descriptions WHERE category_id = 939 AND lang_code = 'en'
0.00021
211
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND cscart_categories.company_id = 1
0.00015
212
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 939 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
213
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND company_id = 1
0.00019
214
SELECT id_path FROM cscart_categories WHERE category_id = 940
0.00023
215
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 = 'en'  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 = 'en'  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 '412/940/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00058
216
SELECT category FROM cscart_category_descriptions WHERE category_id = 940 AND lang_code = 'en'
0.00021
217
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND cscart_categories.company_id = 1
0.00019
218
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 940 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00029
219
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND company_id = 1
0.00022
220
SELECT id_path FROM cscart_categories WHERE category_id = 941
0.00023
221
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 = 'en'  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 = 'en'  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 '412/941/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00054
222
SELECT category FROM cscart_category_descriptions WHERE category_id = 941 AND lang_code = 'en'
0.00021
223
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND cscart_categories.company_id = 1
0.00016
224
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 941 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
225
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND company_id = 1
0.00019
226
SELECT id_path FROM cscart_categories WHERE category_id = 943
0.00023
227
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 = 'en'  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 = 'en'  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 '412/943/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00057
228
SELECT category FROM cscart_category_descriptions WHERE category_id = 943 AND lang_code = 'en'
0.00021
229
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND cscart_categories.company_id = 1
0.00022
230
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 943 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
231
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND company_id = 1
0.00018
232
SELECT id_path FROM cscart_categories WHERE category_id = 942
0.00014
233
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 = 'en'  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 = 'en'  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 '412/942/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00050
234
SELECT category FROM cscart_category_descriptions WHERE category_id = 942 AND lang_code = 'en'
0.00016
235
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND cscart_categories.company_id = 1
0.00014
236
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 942 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
237
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND company_id = 1
0.00019
238
SELECT id_path FROM cscart_categories WHERE category_id = 944
0.00012
239
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 = 'en'  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 = 'en'  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 '412/944/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00052
240
SELECT category FROM cscart_category_descriptions WHERE category_id = 944 AND lang_code = 'en'
0.00023
241
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND cscart_categories.company_id = 1
0.00014
242
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 944 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
243
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND company_id = 1
0.00020
244
SELECT id_path FROM cscart_categories WHERE category_id = 945
0.00013
245
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 = 'en'  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 = 'en'  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 '412/945/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00049
246
SELECT category FROM cscart_category_descriptions WHERE category_id = 945 AND lang_code = 'en'
0.00020
247
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND cscart_categories.company_id = 1
0.00015
248
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 945 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00022
249
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND company_id = 1
0.00014
250
SELECT id_path FROM cscart_categories WHERE category_id = 946
0.00014
251
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 = 'en'  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 = 'en'  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 '412/946/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00049
252
SELECT category FROM cscart_category_descriptions WHERE category_id = 946 AND lang_code = 'en'
0.00019
253
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND cscart_categories.company_id = 1
0.00016
254
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 946 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00026
255
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND company_id = 1
0.00014
256
SELECT id_path FROM cscart_categories WHERE category_id = 461
0.00012
257
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 = 'en'  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 = 'en'  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 '412/461/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00050
258
SELECT category FROM cscart_category_descriptions WHERE category_id = 461 AND lang_code = 'en'
0.00016
259
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND cscart_categories.company_id = 1
0.00017
260
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 461 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
261
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND company_id = 1
0.00015
262
SELECT id_path FROM cscart_categories WHERE category_id = 947
0.00012
263
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 = 'en'  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 = 'en'  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 '412/947/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00049
264
SELECT category FROM cscart_category_descriptions WHERE category_id = 947 AND lang_code = 'en'
0.00021
265
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND cscart_categories.company_id = 1
0.00019
266
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 947 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
267
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND company_id = 1
0.00019
268
SELECT id_path FROM cscart_categories WHERE category_id = 468
0.00012
269
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 = 'en'  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 = 'en'  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 '412/468/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00049
270
SELECT category FROM cscart_category_descriptions WHERE category_id = 468 AND lang_code = 'en'
0.00019
271
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND cscart_categories.company_id = 1
0.00014
272
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 468 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
273
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND company_id = 1
0.00015
274
SELECT id_path FROM cscart_categories WHERE category_id = 932
0.00012
275
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 = 'en'  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 = 'en'  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 '452/932/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00052
276
SELECT category FROM cscart_category_descriptions WHERE category_id = 932 AND lang_code = 'en'
0.00020
277
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND cscart_categories.company_id = 1
0.00019
278
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 932 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00026
279
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 452 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00028
280
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND company_id = 1
0.00015
281
SELECT id_path FROM cscart_categories WHERE category_id = 931
0.00013
282
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 = 'en'  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 = 'en'  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 '452/931/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00051
283
SELECT category FROM cscart_category_descriptions WHERE category_id = 931 AND lang_code = 'en'
0.00021
284
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND cscart_categories.company_id = 1
0.00014
285
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 931 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
286
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND company_id = 1
0.00018
287
SELECT id_path FROM cscart_categories WHERE category_id = 898
0.00013
288
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 = 'en'  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 = 'en'  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 '412/897/898/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00049
289
SELECT category FROM cscart_category_descriptions WHERE category_id = 898 AND lang_code = 'en'
0.00017
290
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND cscart_categories.company_id = 1
0.00014
291
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 898 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
292
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 897 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
293
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND company_id = 1
0.00016
294
SELECT id_path FROM cscart_categories WHERE category_id = 899
0.00012
295
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 = 'en'  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 = 'en'  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 '412/897/899/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00045
296
SELECT category FROM cscart_category_descriptions WHERE category_id = 899 AND lang_code = 'en'
0.00020
297
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND cscart_categories.company_id = 1
0.00016
298
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 899 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
299
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND company_id = 1
0.00018
300
SELECT id_path FROM cscart_categories WHERE category_id = 974
0.00014
301
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 = 'en'  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 = 'en'  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 '412/897/974/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00052
302
SELECT category FROM cscart_category_descriptions WHERE category_id = 974 AND lang_code = 'en'
0.00016
303
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND cscart_categories.company_id = 1
0.00016
304
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 974 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
305
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND company_id = 1
0.00021
306
SELECT id_path FROM cscart_categories WHERE category_id = 900
0.00015
307
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 = 'en'  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 = 'en'  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 '412/897/900/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00053
308
SELECT category FROM cscart_category_descriptions WHERE category_id = 900 AND lang_code = 'en'
0.00026
309
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND cscart_categories.company_id = 1
0.00020
310
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 900 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
311
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND company_id = 1
0.00019
312
SELECT id_path FROM cscart_categories WHERE category_id = 975
0.00014
313
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 = 'en'  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 = 'en'  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 '412/897/975/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00052
314
SELECT category FROM cscart_category_descriptions WHERE category_id = 975 AND lang_code = 'en'
0.00022
315
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND cscart_categories.company_id = 1
0.00015
316
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 975 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00025
317
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND company_id = 1
0.00019
318
SELECT id_path FROM cscart_categories WHERE category_id = 976
0.00018
319
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 = 'en'  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 = 'en'  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 '412/897/976/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00054
320
SELECT category FROM cscart_category_descriptions WHERE category_id = 976 AND lang_code = 'en'
0.00020
321
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND cscart_categories.company_id = 1
0.00016
322
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 976 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00027
323
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND company_id = 1
0.00019
324
SELECT id_path FROM cscart_categories WHERE category_id = 977
0.00013
325
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 = 'en'  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 = 'en'  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 '412/897/977/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00051
326
SELECT category FROM cscart_category_descriptions WHERE category_id = 977 AND lang_code = 'en'
0.00022
327
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND cscart_categories.company_id = 1
0.00020
328
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 977 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00026
329
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND company_id = 1
0.00018
330
SELECT id_path FROM cscart_categories WHERE category_id = 978
0.00015
331
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 = 'en'  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 = 'en'  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 '412/897/978/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00050
332
SELECT category FROM cscart_category_descriptions WHERE category_id = 978 AND lang_code = 'en'
0.00021
333
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND cscart_categories.company_id = 1
0.00016
334
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 978 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
335
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND company_id = 1
0.00022
336
SELECT id_path FROM cscart_categories WHERE category_id = 979
0.00015
337
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 = 'en'  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 = 'en'  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 '412/897/979/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00052
338
SELECT category FROM cscart_category_descriptions WHERE category_id = 979 AND lang_code = 'en'
0.00018
339
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND cscart_categories.company_id = 1
0.00016
340
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 979 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
341
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND company_id = 1
0.00021
342
SELECT id_path FROM cscart_categories WHERE category_id = 980
0.00015
343
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 = 'en'  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 = 'en'  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 '412/897/980/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00054
344
SELECT category FROM cscart_category_descriptions WHERE category_id = 980 AND lang_code = 'en'
0.00020
345
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND cscart_categories.company_id = 1
0.00016
346
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 980 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00028
347
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND company_id = 1
0.00020
348
SELECT id_path FROM cscart_categories WHERE category_id = 981
0.00015
349
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 = 'en'  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 = 'en'  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 '412/897/981/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00054
350
SELECT category FROM cscart_category_descriptions WHERE category_id = 981 AND lang_code = 'en'
0.00021
351
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND cscart_categories.company_id = 1
0.00017
352
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 981 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00025
353
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND company_id = 1
0.00017
354
SELECT id_path FROM cscart_categories WHERE category_id = 982
0.00013
355
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 = 'en'  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 = 'en'  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 '412/897/982/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00054
356
SELECT category FROM cscart_category_descriptions WHERE category_id = 982 AND lang_code = 'en'
0.00020
357
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND cscart_categories.company_id = 1
0.00015
358
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 982 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00025
359
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND company_id = 1
0.00019
360
SELECT id_path FROM cscart_categories WHERE category_id = 983
0.00014
361
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 = 'en'  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 = 'en'  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 '412/897/983/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00054
362
SELECT category FROM cscart_category_descriptions WHERE category_id = 983 AND lang_code = 'en'
0.00021
363
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND cscart_categories.company_id = 1
0.00020
364
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 983 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00026
365
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND company_id = 1
0.00021
366
SELECT id_path FROM cscart_categories WHERE category_id = 984
0.00013
367
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 = 'en'  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 = 'en'  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 '412/897/984/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00053
368
SELECT category FROM cscart_category_descriptions WHERE category_id = 984 AND lang_code = 'en'
0.00021
369
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND cscart_categories.company_id = 1
0.00015
370
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 984 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
371
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND company_id = 1
0.00015
372
SELECT id_path FROM cscart_categories WHERE category_id = 985
0.00014
373
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 = 'en'  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 = 'en'  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 '412/897/985/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00051
374
SELECT category FROM cscart_category_descriptions WHERE category_id = 985 AND lang_code = 'en'
0.00018
375
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND cscart_categories.company_id = 1
0.00016
376
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 985 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00025
377
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND company_id = 1
0.00020
378
SELECT id_path FROM cscart_categories WHERE category_id = 513
0.00013
379
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 = 'en'  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 = 'en'  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 '513/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00065
380
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(417, 516, 919) 
0.00019
381
SELECT category FROM cscart_category_descriptions WHERE category_id = 513 AND lang_code = 'en'
0.00021
382
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND cscart_categories.company_id = 1
0.00021
383
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 513 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00024
384
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND company_id = 1
0.00021
385
SELECT id_path FROM cscart_categories WHERE category_id = 422
0.00015
386
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 = 'en'  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 = 'en'  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 '413/422/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00064
387
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(436, 458, 883) 
0.00023
388
SELECT category FROM cscart_category_descriptions WHERE category_id = 422 AND lang_code = 'en'
0.00016
389
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND cscart_categories.company_id = 1
0.00017
390
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 422 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00025
391
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 413 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00023
392
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND company_id = 1
0.00015
393
SELECT id_path FROM cscart_categories WHERE category_id = 424
0.00014
394
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 = 'en'  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 = 'en'  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 '424/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00068
395
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(512, 517, 441, 453, 854) 
0.00022
396
SELECT category FROM cscart_category_descriptions WHERE category_id = 424 AND lang_code = 'en'
0.00018
397
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND cscart_categories.company_id = 1
0.00022
398
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 424 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00025
399
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND company_id = 1
0.00021
400
SELECT id_path FROM cscart_categories WHERE category_id = 414
0.00014
401
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 = 'en'  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 = 'en'  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 '414/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00070
402
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(442, 454, 463, 474, 434, 477) 
0.00025
403
SELECT category FROM cscart_category_descriptions WHERE category_id = 414 AND lang_code = 'en'
0.00022
404
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND cscart_categories.company_id = 1
0.00017
405
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 414 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00026
406
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND company_id = 1
0.00018
407
SELECT id_path FROM cscart_categories WHERE category_id = 415
0.00014
408
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 = 'en'  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 = 'en'  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 '415/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00088
409
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(915, 443, 886, 421, 435, 881, 440, 425, 888, 450, 428, 889, 887, 460, 467, 471) 
0.00035
410
SELECT category FROM cscart_category_descriptions WHERE category_id = 415 AND lang_code = 'en'
0.00018
411
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND cscart_categories.company_id = 1
0.00015
412
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 415 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00028
413
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND company_id = 1
0.00018
414
SELECT id_path FROM cscart_categories WHERE category_id = 416
0.00013
415
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 = 'en'  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 = 'en'  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 '416/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00083
416
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(447, 423, 840, 445, 426, 455, 466, 430, 465, 855, 832, 874) 
0.00027
417
SELECT category FROM cscart_category_descriptions WHERE category_id = 416 AND lang_code = 'en'
0.00023
418
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND cscart_categories.company_id = 1
0.00031
419
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 416 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00040
420
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND company_id = 1
0.00038
421
SELECT id_path FROM cscart_categories WHERE category_id = 501
0.00047
422
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 = 'en'  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 = 'en'  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 '501/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
0.00115
423
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(502, 864, 503, 863, 504, 505, 506, 507, 509, 853, 916) 
0.00064
424
SELECT category FROM cscart_category_descriptions WHERE category_id = 501 AND lang_code = 'en'
0.00060
425
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND cscart_categories.company_id = 1
0.00053
426
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 501 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
0.00069
427
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 412  AND cscart_categories.company_id = 1
0.00031
428
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND cscart_categories.company_id = 1
0.00029
429
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND cscart_categories.company_id = 1
0.00021
430
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND cscart_categories.company_id = 1
0.00038
431
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND cscart_categories.company_id = 1
0.00028
432
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND cscart_categories.company_id = 1
0.00015
433
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND cscart_categories.company_id = 1
0.00020
434
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND cscart_categories.company_id = 1
0.00020
435
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND cscart_categories.company_id = 1
0.00015
436
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND cscart_categories.company_id = 1
0.00015
437
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND cscart_categories.company_id = 1
0.00018
438
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND cscart_categories.company_id = 1
0.00014
439
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND cscart_categories.company_id = 1
0.00017
440
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND cscart_categories.company_id = 1
0.00023
441
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND cscart_categories.company_id = 1
0.00021
442
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND cscart_categories.company_id = 1
0.00013
443
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND cscart_categories.company_id = 1
0.00013
444
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND cscart_categories.company_id = 1
0.00013
445
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND cscart_categories.company_id = 1
0.00013
446
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND cscart_categories.company_id = 1
0.00013
447
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 452  AND cscart_categories.company_id = 1
0.00012
448
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND cscart_categories.company_id = 1
0.00013
449
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND cscart_categories.company_id = 1
0.00013
450
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 897  AND cscart_categories.company_id = 1
0.00013
451
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND cscart_categories.company_id = 1
0.00014
452
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND cscart_categories.company_id = 1
0.00013
453
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND cscart_categories.company_id = 1
0.00023
454
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND cscart_categories.company_id = 1
0.00082
455
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND cscart_categories.company_id = 1
0.00072
456
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND cscart_categories.company_id = 1
0.00095
457
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND cscart_categories.company_id = 1
0.00034
458
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND cscart_categories.company_id = 1
0.00022
459
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND cscart_categories.company_id = 1
0.00021
460
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND cscart_categories.company_id = 1
0.00019
461
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND cscart_categories.company_id = 1
0.00027
462
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND cscart_categories.company_id = 1
0.00044
463
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND cscart_categories.company_id = 1
0.00022
464
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND cscart_categories.company_id = 1
0.00015
465
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND cscart_categories.company_id = 1
0.00016
466
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND cscart_categories.company_id = 1
0.00016
467
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 417  AND cscart_categories.company_id = 1
0.00014
468
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 516  AND cscart_categories.company_id = 1
0.00014
469
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 919  AND cscart_categories.company_id = 1
0.00013
470
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 413  AND cscart_categories.company_id = 1
0.00014
471
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND cscart_categories.company_id = 1
0.00013
472
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 436  AND cscart_categories.company_id = 1
0.00013
473
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 458  AND cscart_categories.company_id = 1
0.00013
474
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 883  AND cscart_categories.company_id = 1
0.00013
475
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND cscart_categories.company_id = 1
0.00013
476
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 512  AND cscart_categories.company_id = 1
0.00015
477
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 517  AND cscart_categories.company_id = 1
0.00013
478
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 441  AND cscart_categories.company_id = 1
0.00013
479
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 453  AND cscart_categories.company_id = 1
0.00013
480
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 854  AND cscart_categories.company_id = 1
0.00014
481
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND cscart_categories.company_id = 1
0.00014
482
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 434  AND cscart_categories.company_id = 1
0.00013
483
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 442  AND cscart_categories.company_id = 1
0.00013
484
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 454  AND cscart_categories.company_id = 1
0.00014
485
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 463  AND cscart_categories.company_id = 1
0.00014
486
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 474  AND cscart_categories.company_id = 1
0.00015
487
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 477  AND cscart_categories.company_id = 1
0.00016
488
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND cscart_categories.company_id = 1
0.00018
489
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 421  AND cscart_categories.company_id = 1
0.00012
490
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 915  AND cscart_categories.company_id = 1
0.00013
491
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 435  AND cscart_categories.company_id = 1
0.00013
492
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 881  AND cscart_categories.company_id = 1
0.00013
493
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 888  AND cscart_categories.company_id = 1
0.00013
494
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 450  AND cscart_categories.company_id = 1
0.00014
495
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 460  AND cscart_categories.company_id = 1
0.00012
496
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 467  AND cscart_categories.company_id = 1
0.00015
497
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 471  AND cscart_categories.company_id = 1
0.00013
498
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 425  AND cscart_categories.company_id = 1
0.00013
499
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 886  AND cscart_categories.company_id = 1
0.00014
500
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 440  AND cscart_categories.company_id = 1
0.00014
501
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 889  AND cscart_categories.company_id = 1
0.00014
502
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 428  AND cscart_categories.company_id = 1
0.00014
503
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 443  AND cscart_categories.company_id = 1
0.00013
504
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 887  AND cscart_categories.company_id = 1
0.00014
505
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND cscart_categories.company_id = 1
0.00013
506
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 423  AND cscart_categories.company_id = 1
0.00016
507
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 445  AND cscart_categories.company_id = 1
0.00019
508
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 426  AND cscart_categories.company_id = 1
0.00013
509
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 455  AND cscart_categories.company_id = 1
0.00012
510
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 466  AND cscart_categories.company_id = 1
0.00013
511
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 465  AND cscart_categories.company_id = 1
0.00013
512
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 855  AND cscart_categories.company_id = 1
0.00013
513
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 430  AND cscart_categories.company_id = 1
0.00015
514
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 447  AND cscart_categories.company_id = 1
0.00015
515
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 832  AND cscart_categories.company_id = 1
0.00013
516
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 840  AND cscart_categories.company_id = 1
0.00020
517
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 874  AND cscart_categories.company_id = 1
0.00014
518
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND cscart_categories.company_id = 1
0.00013
519
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 502  AND cscart_categories.company_id = 1
0.00014
520
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 503  AND cscart_categories.company_id = 1
0.00012
521
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 504  AND cscart_categories.company_id = 1
0.00012
522
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 505  AND cscart_categories.company_id = 1
0.00013
523
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 506  AND cscart_categories.company_id = 1
0.00014
524
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 509  AND cscart_categories.company_id = 1
0.00014
525
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 853  AND cscart_categories.company_id = 1
0.00014
526
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 863  AND cscart_categories.company_id = 1
0.00012
527
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 864  AND cscart_categories.company_id = 1
0.00014
528
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 507  AND cscart_categories.company_id = 1
0.00013
529
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 916  AND cscart_categories.company_id = 1
0.00014
530
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00029
531
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 80 AND object_type = 'A'  AND cscart_discussion.company_id = 1  
0.00022
532
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 4602  AND cscart_discussion.company_id = 1
0.00015
533
SELECT COUNT(*) FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 4602 AND cscart_discussion_messages.message <> '' AND cscart_discussion_posts.status = 'A'
0.00021
534
SELECT cscart_discussion_posts.* , cscart_discussion_messages.message FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 4602 AND cscart_discussion_messages.message <> '' AND cscart_discussion_posts.status = 'A' ORDER BY cscart_discussion_posts.timestamp DESC  LIMIT 0, 10
0.00024
535
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00020
536
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00229
537
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 47 
0.00045
538
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 48 
0.00036
539
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 51 
0.00037
540
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00044
541
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00265
542
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 2 
0.00031
543
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00032
544
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 43 
0.00025
545
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 43 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00029
546
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 59 
0.00033
547
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 59 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00027
548
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00023
549
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00222
550
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 64 
0.00021
551
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 64 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00023
552
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
0.00023

Warning Some queries are being executed multiple times

Queries max count: 12
Query Count Min time Max time Average time
SELECT FOUND_ROWS()
12 0.00008 0.01257 0.00115
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
11 0.00020 0.00034 0.00026
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
5 0.00020 0.00044 0.00027
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
5 0.00026 0.00047 0.00034
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' 
5 0.00020 0.00043 0.00029
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
5 0.00220 0.00265 0.00232
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 2, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Baubay', 1, 0))  AND company_id = 1
4 0.00020 0.00026 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.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (75, 72, 73, 74) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
4 0.00048 0.00055 0.00050
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
4 0.00023 0.00026 0.00025
SELECT * FROM cscart_settings_sections WHERE name = 'social_buttons' 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))
3 0.00029 0.00120 0.00060
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND section_id = '317' 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
3 0.00087 0.00094 0.00091
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
3 0.00032 0.00034 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 47 
2 0.00032 0.00045 0.00038
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND cscart_categories.company_id = 1
2 0.00013 0.00022 0.00017
SELECT * FROM cscart_image_gallery_settings WHERE id=55 AND type='C'
2 0.00021 0.00034 0.00027
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND cscart_categories.company_id = 1
2 0.00014 0.00015 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND cscart_categories.company_id = 1
2 0.00013 0.00017 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND cscart_categories.company_id = 1
2 0.00015 0.00020 0.00017
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 55 
2 0.00027 0.00040 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 48 
2 0.00023 0.00036 0.00029
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND cscart_categories.company_id = 1
2 0.00014 0.00020 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND cscart_categories.company_id = 1
2 0.00015 0.00020 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND cscart_categories.company_id = 1
2 0.00016 0.00021 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND cscart_categories.company_id = 1
2 0.00014 0.00017 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND cscart_categories.company_id = 1
2 0.00015 0.00018 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND cscart_categories.company_id = 1
2 0.00014 0.00038 0.00026
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND cscart_categories.company_id = 1
2 0.00020 0.00021 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND cscart_categories.company_id = 1
2 0.00013 0.00031 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND cscart_categories.company_id = 1
2 0.00015 0.00029 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND cscart_categories.company_id = 1
2 0.00013 0.00053 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 51 
2 0.00023 0.00037 0.00030
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND cscart_categories.company_id = 1
2 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND cscart_categories.company_id = 1
2 0.00016 0.00023 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND cscart_categories.company_id = 1
2 0.00018 0.00019 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND cscart_categories.company_id = 1
2 0.00013 0.00019 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND cscart_categories.company_id = 1
2 0.00020 0.00082 0.00051
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND cscart_categories.company_id = 1
2 0.00013 0.00016 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND cscart_categories.company_id = 1
2 0.00015 0.00072 0.00044
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND cscart_categories.company_id = 1
2 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND cscart_categories.company_id = 1
2 0.00016 0.00095 0.00055
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND cscart_categories.company_id = 1
2 0.00013 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND cscart_categories.company_id = 1
2 0.00020 0.00034 0.00027
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND cscart_categories.company_id = 1
2 0.00013 0.00019 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND cscart_categories.company_id = 1
2 0.00013 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND cscart_categories.company_id = 1
2 0.00016 0.00022 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND cscart_categories.company_id = 1
2 0.00016 0.00021 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND cscart_categories.company_id = 1
2 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND cscart_categories.company_id = 1
2 0.00013 0.00017 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND cscart_categories.company_id = 1
2 0.00016 0.00019 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND cscart_categories.company_id = 1
2 0.00013 0.00016 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND cscart_categories.company_id = 1
2 0.00017 0.00027 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND cscart_categories.company_id = 1
2 0.00013 0.00015 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND cscart_categories.company_id = 1
2 0.00015 0.00044 0.00029
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND cscart_categories.company_id = 1
2 0.00014 0.00021 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND cscart_categories.company_id = 1
2 0.00014 0.00023 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND cscart_categories.company_id = 1
2 0.00020 0.00022 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND cscart_categories.company_id = 1
2 0.00017 0.00022 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND cscart_categories.company_id = 1
2 0.00014 0.00016 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND cscart_categories.company_id = 1
2 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND cscart_categories.company_id = 1
2 0.00014 0.00028 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 = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00039 0.00040 0.00039
DELETE FROM cscart_access_restriction_block WHERE expires < 1751307431
2 0.00055 0.00069 0.00062
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718145
2 0.00044 0.00063 0.00053
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00034 0.00036 0.00035
SELECT page_type FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 80 
2 0.00029 0.00030 0.00029
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'en' WHERE 1  AND cscart_sd_labels_custom.used = 'Y'  ORDER BY cscart_sd_labels_custom_descriptions.name asc 
2 0.00037 0.00041 0.00039
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 2
2 0.00022 0.00023 0.00022
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751307431
2 0.00047 0.00059 0.00053
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE ip_from <= 3628718145 AND ip_to >= 3628718145 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
2 0.00028 0.00079 0.00053
SELECT * FROM cscart_image_gallery_settings WHERE id=80 AND type='C'
2 0.00020 0.00023 0.00021
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
2 0.00013 0.00075 0.00044
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 506  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND company_id = 1
1 0.00017 0.00017 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 505  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 982 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
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 = 'en'  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 = 'en'  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 '412/897/982/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
SELECT id_path FROM cscart_categories WHERE category_id = 982
1 0.00013 0.00013 0.00013
SELECT category FROM cscart_category_descriptions WHERE category_id = 982 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 886  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 509  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 981 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00025 0.00025 0.00025
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT category FROM cscart_category_descriptions WHERE category_id = 981 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/897/981/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
SELECT id_path FROM cscart_categories WHERE category_id = 981
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 863  AND cscart_categories.company_id = 1
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 980 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00028 0.00028 0.00028
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 853  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 983 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00026 0.00026 0.00026
SELECT id_path FROM cscart_categories WHERE category_id = 983
1 0.00014 0.00014 0.00014
SELECT category FROM cscart_category_descriptions WHERE category_id = 984 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 985 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 985 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/897/985/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00051 0.00051 0.00051
SELECT id_path FROM cscart_categories WHERE category_id = 985
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND company_id = 1
1 0.00015 0.00015 0.00015
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 984 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 502  AND cscart_categories.company_id = 1
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 = 'en'  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 = 'en'  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 '412/897/983/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
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 = 'en'  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 = 'en'  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 '412/897/984/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00053 0.00053 0.00053
SELECT id_path FROM cscart_categories WHERE category_id = 984
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT category FROM cscart_category_descriptions WHERE category_id = 980 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 503  AND cscart_categories.company_id = 1
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 504  AND cscart_categories.company_id = 1
1 0.00012 0.00012 0.00012
SELECT category FROM cscart_category_descriptions WHERE category_id = 983 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 864  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 507  AND cscart_categories.company_id = 1
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 = 'en'  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 = 'en'  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 '412/897/980/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 59 
1 0.00033 0.00033 0.00033
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00032 0.00032 0.00032
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 43 
1 0.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 976 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/897/976/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
SELECT id_path FROM cscart_categories WHERE category_id = 976
1 0.00018 0.00018 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 43 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00029 0.00029 0.00029
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 975 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 975 AND lang_code = 'en'
1 0.00022 0.00022 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND company_id = 1
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 = 'en'  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 = 'en'  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 '412/897/975/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 975
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 59 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00027 0.00027 0.00027
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 900 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 64 
1 0.00021 0.00021 0.00021
SELECT category FROM cscart_category_descriptions WHERE category_id = 900 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/897/900/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00053 0.00053 0.00053
SELECT id_path FROM cscart_categories WHERE category_id = 900
1 0.00015 0.00015 0.00015
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 976 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00027 0.00027 0.00027
SELECT id_path FROM cscart_categories WHERE category_id = 977
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 = 'en'  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 = 'en'  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 '513/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00065 0.00065 0.00065
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 978 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT id_path FROM cscart_categories WHERE category_id = 980
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 979 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 916  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT category FROM cscart_category_descriptions WHERE category_id = 979 AND lang_code = 'en'
1 0.00018 0.00018 0.00018
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 80 AND object_type = 'A'  AND cscart_discussion.company_id = 1  
1 0.00022 0.00022 0.00022
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 = 'en'  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 = 'en'  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 '412/897/979/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 979
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND company_id = 1
1 0.00022 0.00022 0.00022
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 4602  AND cscart_discussion.company_id = 1
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 = 'en'  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 = 'en'  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 '412/897/977/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00051 0.00051 0.00051
SELECT COUNT(*) FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 4602 AND cscart_discussion_messages.message <> '' AND cscart_discussion_posts.status = 'A'
1 0.00021 0.00021 0.00021
SELECT category FROM cscart_category_descriptions WHERE category_id = 978 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/897/978/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00050 0.00050 0.00050
SELECT id_path FROM cscart_categories WHERE category_id = 978
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 977 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00026 0.00026 0.00026
SELECT cscart_discussion_posts.* , cscart_discussion_messages.message FROM cscart_discussion_posts  LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id  WHERE cscart_discussion_posts.thread_id = 4602 AND cscart_discussion_messages.message <> '' AND cscart_discussion_posts.status = 'A' ORDER BY cscart_discussion_posts.timestamp DESC  LIMIT 0, 10
1 0.00024 0.00024 0.00024
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 2 
1 0.00031 0.00031 0.00031
SELECT category FROM cscart_category_descriptions WHERE category_id = 977 AND lang_code = 'en'
1 0.00022 0.00022 0.00022
SELECT id_path FROM cscart_categories WHERE category_id = 513
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 874  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(417, 516, 919) 
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 516  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 512  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 883  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 458  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 436  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 413  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 887  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 919  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 423  AND cscart_categories.company_id = 1
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 417  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 441  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 897  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 452  AND cscart_categories.company_id = 1
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 412  AND cscart_categories.company_id = 1
1 0.00031 0.00031 0.00031
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 501 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00069 0.00069 0.00069
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 445  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT category FROM cscart_category_descriptions WHERE category_id = 501 AND lang_code = 'en'
1 0.00060 0.00060 0.00060
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 426  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(502, 864, 503, 863, 504, 505, 506, 507, 509, 853, 916) 
1 0.00064 0.00064 0.00064
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 517  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 453  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT id_path FROM cscart_categories WHERE category_id = 501
1 0.00047 0.00047 0.00047
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 443  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 440  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 471  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 467  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 460  AND cscart_categories.company_id = 1
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 889  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 450  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 888  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 428  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 881  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 854  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 435  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 915  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 421  AND cscart_categories.company_id = 1
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 477  AND cscart_categories.company_id = 1
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 474  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 463  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 454  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 442  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 434  AND cscart_categories.company_id = 1
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 = 'en'  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 = 'en'  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 '501/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00115 0.00115 0.00115
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND company_id = 1
1 0.00038 0.00038 0.00038
SELECT category FROM cscart_category_descriptions WHERE category_id = 513 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 413 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 424 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00025 0.00025 0.00025
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 832  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT category FROM cscart_category_descriptions WHERE category_id = 424 AND lang_code = 'en'
1 0.00018 0.00018 0.00018
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(512, 517, 441, 453, 854) 
1 0.00022 0.00022 0.00022
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 = 'en'  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 = 'en'  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 '424/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00068 0.00068 0.00068
SELECT id_path FROM cscart_categories WHERE category_id = 424
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND company_id = 1
1 0.00015 0.00015 0.00015
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 422 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
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 = 'en'  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 = 'en'  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 '414/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00070 0.00070 0.00070
SELECT category FROM cscart_category_descriptions WHERE category_id = 422 AND lang_code = 'en'
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 840  AND cscart_categories.company_id = 1
1 0.00020 0.00020 0.00020
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(436, 458, 883) 
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 = 'en'  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 = 'en'  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 '413/422/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00064 0.00064 0.00064
SELECT id_path FROM cscart_categories WHERE category_id = 422
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 513 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 425  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT id_path FROM cscart_categories WHERE category_id = 414
1 0.00014 0.00014 0.00014
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(442, 454, 463, 474, 434, 477) 
1 0.00025 0.00025 0.00025
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 416 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00040 0.00040 0.00040
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 415 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00028 0.00028 0.00028
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 455  AND cscart_categories.company_id = 1
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 466  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT category FROM cscart_category_descriptions WHERE category_id = 416 AND lang_code = 'en'
1 0.00023 0.00023 0.00023
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(447, 423, 840, 445, 426, 455, 466, 430, 465, 855, 832, 874) 
1 0.00027 0.00027 0.00027
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'en'  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 = 'en'  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 '416/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00083 0.00083 0.00083
SELECT id_path FROM cscart_categories WHERE category_id = 416
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 465  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 855  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 447  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT category FROM cscart_category_descriptions WHERE category_id = 415 AND lang_code = 'en'
1 0.00018 0.00018 0.00018
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(915, 443, 886, 421, 435, 881, 440, 425, 888, 450, 428, 889, 887, 460, 467, 471) 
1 0.00035 0.00035 0.00035
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 = 'en'  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 = 'en'  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 '415/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00088 0.00088 0.00088
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT id_path FROM cscart_categories WHERE category_id = 415
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 414 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00026 0.00026 0.00026
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 430  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT category FROM cscart_category_descriptions WHERE category_id = 414 AND lang_code = 'en'
1 0.00022 0.00022 0.00022
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
1 0.00029 0.00029 0.00029
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 932 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00026 0.00026 0.00026
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 974 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT status FROM cscart_menus WHERE menu_id = 3
1 0.02046 0.02046 0.02046
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 = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 7 AND cscart_menus.company_id = 1
1 0.00020 0.00020 0.00020
SELECT status FROM cscart_menus WHERE menu_id = 7
1 0.00025 0.00025 0.00025
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 51 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00024 0.00024 0.00024
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 48 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00025 0.00025 0.00025
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 47 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00030 0.00030 0.00030
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 77 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00037 0.00037 0.00037
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 77 
1 0.00058 0.00058 0.00058
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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position
1 0.00094 0.00094 0.00094
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 = 'en'  AND cscart_menus.company_id = 1  AND cscart_menus.menu_id = 3 AND cscart_menus.company_id = 1
1 0.00157 0.00157 0.00157
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY `position`;
1 0.00031 0.00031 0.00031
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND company_id = 1
1 0.00025 0.00025 0.00025
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 80 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'de' 
1 0.00025 0.00025 0.00025
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 'pages' 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 = 80 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (1118, 1119, 1120, 1121, 1122, 1411, 1412, 1413, 2042, 2054, 2055, 1143, 2056, 1144, 2182, 1136, 1141, 2217, 1137, 1130, 1132, 1138, 1142, 1131, 1139, 1135, 1140)  AND cscart_bm_blocks_descriptions.lang_code='en'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00257 0.00257 0.00257
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 (906, 907, 1148, 909) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00054 0.00054 0.00054
SELECT c.*, IF (c.location_id != 325, 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 = 2 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
1 0.00191 0.00191 0.00191
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 325
1 0.00017 0.00017 0.00017
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 325
1 0.00042 0.00042 0.00042
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
1 0.00026 0.00026 0.00026
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
1 0.00110 0.00110 0.00110
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 80
1 0.00027 0.00027 0.00027
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 = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '7' ORDER BY sd.position
1 0.00099 0.00099 0.00099
SELECT id_path FROM cscart_categories WHERE category_id = 482
1 0.00042 0.00042 0.00042
SELECT COUNT(DISTINCT(cscart_pages.page_id)) FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.parent_id IN (80) AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('B') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1751307431 AND avail_till_timestamp >= 1751307431)) ORDER BY cscart_pages.timestamp desc
1 0.00042 0.00042 0.00042
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 = 'en'  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 = 'en'  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 '412/925/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 929
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND company_id = 1
1 0.00014 0.00014 0.00014
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 922 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 922 AND lang_code = 'en'
1 0.00022 0.00022 0.00022
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 = 'en'  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 = 'en'  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 '412/922/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00049 0.00049 0.00049
SELECT id_path FROM cscart_categories WHERE category_id = 922
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 925 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 925 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT id_path FROM cscart_categories WHERE category_id = 925
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 = 'en'  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 = 'en'  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 '412/482/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00062 0.00062 0.00062
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 432 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00026 0.00026 0.00026
SELECT category FROM cscart_category_descriptions WHERE category_id = 432 AND lang_code = 'en'
1 0.00024 0.00024 0.00024
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 = 'en'  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 = 'en'  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 '412/432/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00051 0.00051 0.00051
SELECT id_path FROM cscart_categories WHERE category_id = 432
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 412 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 482 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00022 0.00022 0.00022
SELECT category FROM cscart_category_descriptions WHERE category_id = 482 AND lang_code = 'en'
1 0.00023 0.00023 0.00023
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.parent_id IN (80) AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('B') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1751307431 AND avail_till_timestamp >= 1751307431)) ORDER BY cscart_pages.timestamp desc  LIMIT 0, 10
1 0.00049 0.00049 0.00049
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
1 0.00015 0.00015 0.00015
SELECT category FROM cscart_category_descriptions WHERE category_id = 929 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SET time_zone = '+02:00'
1 0.00016 0.00016 0.00016
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en'  WHERE 1  AND a.is_primary = 'Y' ORDER BY a.position
1 0.00027 0.00027 0.00027
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
1 0.00036 0.00036 0.00036
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 80 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00033 0.00033 0.00033
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 1  WHERE 1  AND section_id = '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.00041 0.00041 0.00041
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.00026 0.00026 0.00026
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
1 0.00026 0.00026 0.00026
SELECT * FROM cscart_seo_names WHERE name = 'paneele-verlegen-wie-man-3d-holzpaneele-richtig-montiert-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
1 0.00037 0.00037 0.00037
SELECT * FROM cscart_seo_names WHERE name = 'paneele-verlegen-wie-man-3d-holzpaneele-richtig-montiert-en'  AND lang_code = 'de'
1 0.00037 0.00037 0.00037
SELECT type FROM cscart_seo_names WHERE name = 'paneele-verlegen-wie-man-3d-holzpaneele-richtig-montiert-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
1 0.00044 0.00044 0.00044
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
1 0.00014 0.00014 0.00014
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
1 0.00045 0.00045 0.00045
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
1 0.00017 0.00017 0.00017
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (1) AND status IN ('A', 'P', 'N')
1 0.00019 0.00019 0.00019
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1
1 0.00017 0.00017 0.00017
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?baubay.de'
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.00028 0.00028 0.00028
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'cdn' 
1 0.00029 0.00029 0.00029
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 2725 ORDER BY cscart_settings_objects.position
1 0.00026 0.00026 0.00026
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'storage' 
1 0.00021 0.00021 0.00021
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.00062 0.00062 0.00062
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 1 
1 0.00026 0.00026 0.00026
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
1 0.00018 0.00018 0.00018
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 55 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id 
1 0.00185 0.00185 0.00185
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 80 AND cscart_page_descriptions.lang_code = 'en'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F') 
1 0.00054 0.00054 0.00054
SELECT SQL_CALC_FOUND_ROWS cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 55 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id DESC  LIMIT 0, 12
1 0.00031 0.00031 0.00031
SELECT CONCAT(u.firstname, ' ', u.lastname) FROM cscart_blog_authors as b LEFT JOIN cscart_users  as u ON b.user_id = u.user_id WHERE b.page_id = 55
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.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'blog' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 55 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00032 0.00032 0.00032
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 55 AND cscart_page_descriptions.lang_code = 'en'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F') 
1 0.00050 0.00050 0.00050
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 80 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id 
1 0.00033 0.00033 0.00033
SELECT SQL_CALC_FOUND_ROWS cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 80 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id DESC  LIMIT 0, 12
1 0.00032 0.00032 0.00032
SELECT description FROM cscart_image_gallery_settings_description WHERE id = 80 AND lang_code = 'en' AND type = 'C'
1 0.00017 0.00017 0.00017
SELECT CONCAT(u.firstname, ' ', u.lastname) FROM cscart_blog_authors as b LEFT JOIN cscart_users  as u ON b.user_id = u.user_id WHERE b.page_id = 80
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 = 'en' WHERE cscart_images_links.object_type = 'blog' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 80 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label6'
1 0.00018 0.00018 0.00018
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
1 0.00021 0.00021 0.00021
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label2'
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label9'
1 0.00027 0.00027 0.00027
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label8'
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label1'
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label3'
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label5'
1 0.00023 0.00023 0.00023
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label10'
1 0.00023 0.00023 0.00023
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label4'
1 0.00018 0.00018 0.00018
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label7'
1 0.00025 0.00025 0.00025
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 2  AND l.dispatch = 'pages.view?page_type=B' AND (FIND_IN_SET(80, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
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 = 'en'  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 = 'en'  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 '412/929/%' AND cscart_categories.company_id = 1   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` = 929 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00028 0.00028 0.00028
SELECT category FROM cscart_category_descriptions WHERE category_id = 974 AND lang_code = 'en'
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND company_id = 1
1 0.00015 0.00015 0.00015
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 468 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 468 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/468/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00049 0.00049 0.00049
SELECT id_path FROM cscart_categories WHERE category_id = 468
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 947 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 947 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/947/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00049 0.00049 0.00049
SELECT id_path FROM cscart_categories WHERE category_id = 947
1 0.00012 0.00012 0.00012
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 461 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT id_path FROM cscart_categories WHERE category_id = 932
1 0.00012 0.00012 0.00012
SELECT category FROM cscart_category_descriptions WHERE category_id = 461 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/461/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00050 0.00050 0.00050
SELECT id_path FROM cscart_categories WHERE category_id = 461
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND company_id = 1
1 0.00014 0.00014 0.00014
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 946 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00026 0.00026 0.00026
SELECT category FROM cscart_category_descriptions WHERE category_id = 946 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/946/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00049 0.00049 0.00049
SELECT id_path FROM cscart_categories WHERE category_id = 946
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND company_id = 1
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 = 'en'  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 = 'en'  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 '452/932/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00052 0.00052 0.00052
SELECT category FROM cscart_category_descriptions WHERE category_id = 945 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 898 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
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 = 'en'  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 = 'en'  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 '412/897/974/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 974
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 899 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 899 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/897/899/%' AND cscart_categories.company_id = 1   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 = 899
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND company_id = 1
1 0.00016 0.00016 0.00016
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 897 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 898 AND lang_code = 'en'
1 0.00017 0.00017 0.00017
SELECT category FROM cscart_category_descriptions WHERE category_id = 932 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/897/898/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00049 0.00049 0.00049
SELECT id_path FROM cscart_categories WHERE category_id = 898
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 931 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 931 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '452/931/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00051 0.00051 0.00051
SELECT id_path FROM cscart_categories WHERE category_id = 931
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND company_id = 1
1 0.00015 0.00015 0.00015
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 452 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00028 0.00028 0.00028
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
1 0.00028 0.00028 0.00028
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 945 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00022 0.00022 0.00022
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 = 'en'  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 = 'en'  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 '412/945/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00049 0.00049 0.00049
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT id_path FROM cscart_categories WHERE category_id = 938
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 939 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 939 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/939/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 939
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND company_id = 1
1 0.00023 0.00023 0.00023
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 938 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00026 0.00026 0.00026
SELECT category FROM cscart_category_descriptions WHERE category_id = 938 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/938/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND company_id = 1
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 = 'en'  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 = 'en'  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 '412/940/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00058 0.00058 0.00058
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 937 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 937 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/937/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00055 0.00055 0.00055
SELECT id_path FROM cscart_categories WHERE category_id = 937
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 890 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 890 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/890/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00050 0.00050 0.00050
SELECT id_path FROM cscart_categories WHERE category_id = 890
1 0.00021 0.00021 0.00021
SELECT id_path FROM cscart_categories WHERE category_id = 940
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 940 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT id_path FROM cscart_categories WHERE category_id = 945
1 0.00013 0.00013 0.00013
SELECT id_path FROM cscart_categories WHERE category_id = 942
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 944 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 944 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/944/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 944
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 942 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 942 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/942/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00050 0.00050 0.00050
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 940 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00029 0.00029 0.00029
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 943 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 943 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/943/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00057 0.00057 0.00057
SELECT id_path FROM cscart_categories WHERE category_id = 943
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 941 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 941 AND lang_code = 'en'
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 = 'en'  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 = 'en'  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 '412/941/%' AND cscart_categories.company_id = 1   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
SELECT id_path FROM cscart_categories WHERE category_id = 941
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND company_id = 1
1 0.00022 0.00022 0.00022
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 64 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00023 0.00023 0.00023