Queries total time: 0.15638 s.
Query Time
1
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
0.00023
2
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
0.00027
3
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
0.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.00043
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.00032
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.00038
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.00030
9
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1
0.00024
10
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (1) AND status IN ('A', 'P', 'N')
0.00040
11
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
0.00023
12
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
0.00018
13
SET time_zone = '+02:00'
0.00026
14
SELECT type FROM cscart_seo_names WHERE name = 'welches-zubehoer-wird-fur-den-einbau-von-dachfenstern-benoetigt-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
0.00052
15
SELECT * FROM cscart_seo_names WHERE name = 'welches-zubehoer-wird-fur-den-einbau-von-dachfenstern-benoetigt-en'  AND lang_code = 'de'
0.00057
16
SELECT * FROM cscart_seo_names WHERE name = 'welches-zubehoer-wird-fur-den-einbau-von-dachfenstern-benoetigt-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
0.00038
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.00033
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.00031
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.00047
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 = 130 
0.00027
21
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 130 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00040
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.00044
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.00039
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.00047
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.00034
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.00032
28
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00029
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.00040
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.00031
32
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718145
0.00020
33
DELETE FROM cscart_access_restriction_block WHERE expires < 1751287448
0.00024
34
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751287448
0.00015
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.00024
36
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
0.00017
37
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718145
0.00022
38
DELETE FROM cscart_access_restriction_block WHERE expires < 1751287448
0.00013
39
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751287448
0.00025
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.00030
41
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
0.00024
42
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
0.00027
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.00035
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.00057
45
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
0.00030
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 = 130 
0.00039
47
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 2
0.00030
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(130, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
0.00040
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.00048
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.00026
51
SELECT FOUND_ROWS()
0.00022
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.00022
53
SELECT FOUND_ROWS()
0.00020
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.00020
55
SELECT FOUND_ROWS()
0.00011
56
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label5'
0.00019
57
SELECT FOUND_ROWS()
0.00012
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.00023
59
SELECT FOUND_ROWS()
0.00009
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.00023
61
SELECT FOUND_ROWS()
0.00010
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.00022
63
SELECT FOUND_ROWS()
0.00009
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.00023
65
SELECT FOUND_ROWS()
0.00009
66
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label2'
0.00023
67
SELECT FOUND_ROWS()
0.00009
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.00023
69
SELECT FOUND_ROWS()
0.00015
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.00038
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.00060
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.00040
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 = 130 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.00062
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 = 130 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00038
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 = 130
0.00039
76
SELECT * FROM cscart_image_gallery_settings WHERE id=130 AND type='C'
0.00027
77
SELECT description FROM cscart_image_gallery_settings_description WHERE id = 130 AND lang_code = 'en' AND type = 'C'
0.00019
78
SELECT * FROM cscart_image_gallery_settings WHERE id=130 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 = 130 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 = 130 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id 
0.00037
81
SELECT FOUND_ROWS()
0.00023
82
SELECT company FROM cscart_companies WHERE company_id = 1
0.00015
83
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.00051
84
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.00031
85
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.00028
86
SELECT * FROM cscart_image_gallery_settings WHERE id=55 AND type='C'
0.00024
87
SELECT * FROM cscart_image_gallery_settings WHERE id=55 AND type='C'
0.00016
88
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
89
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.00035
90
SELECT FOUND_ROWS()
0.00023
91
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.00044
92
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.00088
93
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 = 130 
0.00021
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 = 130 
0.00031
95
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
96
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.00083
97
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
0.00016
98
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.00021
99
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.00024
100
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00026
101
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.00022
102
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
103
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.00033
104
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.00028
105
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00025
106
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.00021
107
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.00047
108
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 = 130 
0.00043
109
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.00031
110
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.00086
111
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.00022
112
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.00024
113
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'responsive'
0.00029
114
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.00021
115
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.00047
116
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 (130) 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 <= 1751287448 AND avail_till_timestamp >= 1751287448)) ORDER BY cscart_pages.timestamp desc
0.00047
117
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 (130) 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 <= 1751287448 AND avail_till_timestamp >= 1751287448)) ORDER BY cscart_pages.timestamp desc  LIMIT 0, 10
0.00049
118
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
119
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
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.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.00040
121
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 130
0.00030
122
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
0.00030
123
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 = 130 
0.00038
124
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
125
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 = 130 
0.00031
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 = 130 
0.00026
127
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
0.00035
128
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 = 130 
0.00031
129
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 2
0.00029
130
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 325
0.00034
131
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 325
0.00020
132
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.00196
133
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.00063
134
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 = 130 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
135
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00027
136
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00216
137
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.00035
138
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 = 130 
0.00030
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 = 130 
0.00024
140
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 130 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'de' 
0.00025
141
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY `position`;
0.00034
142
SELECT status FROM cscart_menus WHERE menu_id = 3
0.00028
143
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.00026
144
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.00060
145
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.00030
146
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 77 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00029
147
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.00024
148
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 47 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00030
149
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.00024
150
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 48 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00025
151
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.00026
152
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 51 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00040
153
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.00030
154
SELECT status FROM cscart_menus WHERE menu_id = 7
0.00024
155
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.00019
156
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.00091
157
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND company_id = 1
0.00028
158
SELECT id_path FROM cscart_categories WHERE category_id = 482
0.00021
159
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.00056
160
SELECT category FROM cscart_category_descriptions WHERE category_id = 482 AND lang_code = 'en'
0.00022
161
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND cscart_categories.company_id = 1
0.00022
162
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.00025
163
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.00029
164
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND company_id = 1
0.00020
165
SELECT id_path FROM cscart_categories WHERE category_id = 432
0.00016
166
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.00075
167
SELECT category FROM cscart_category_descriptions WHERE category_id = 432 AND lang_code = 'en'
0.00023
168
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND cscart_categories.company_id = 1
0.00015
169
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.00024
170
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND company_id = 1
0.00019
171
SELECT id_path FROM cscart_categories WHERE category_id = 925
0.00014
172
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.00056
173
SELECT category FROM cscart_category_descriptions WHERE category_id = 925 AND lang_code = 'en'
0.00031
174
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND cscart_categories.company_id = 1
0.00020
175
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.00026
176
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND company_id = 1
0.00020
177
SELECT id_path FROM cscart_categories WHERE category_id = 922
0.00019
178
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.00056
179
SELECT category FROM cscart_category_descriptions WHERE category_id = 922 AND lang_code = 'en'
0.00024
180
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND cscart_categories.company_id = 1
0.00020
181
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.00025
182
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND company_id = 1
0.00022
183
SELECT id_path FROM cscart_categories WHERE category_id = 929
0.00019
184
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.00060
185
SELECT category FROM cscart_category_descriptions WHERE category_id = 929 AND lang_code = 'en'
0.00021
186
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND cscart_categories.company_id = 1
0.00022
187
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.00024
188
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND company_id = 1
0.00019
189
SELECT id_path FROM cscart_categories WHERE category_id = 890
0.00013
190
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.00047
191
SELECT category FROM cscart_category_descriptions WHERE category_id = 890 AND lang_code = 'en'
0.00019
192
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND cscart_categories.company_id = 1
0.00015
193
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.00024
194
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND company_id = 1
0.00019
195
SELECT id_path FROM cscart_categories WHERE category_id = 937
0.00013
196
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.00048
197
SELECT category FROM cscart_category_descriptions WHERE category_id = 937 AND lang_code = 'en'
0.00025
198
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND cscart_categories.company_id = 1
0.00014
199
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.00025
200
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND company_id = 1
0.00021
201
SELECT id_path FROM cscart_categories WHERE category_id = 938
0.00013
202
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.00047
203
SELECT category FROM cscart_category_descriptions WHERE category_id = 938 AND lang_code = 'en'
0.00022
204
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND cscart_categories.company_id = 1
0.00014
205
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.00023
206
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND company_id = 1
0.00020
207
SELECT id_path FROM cscart_categories WHERE category_id = 939
0.00013
208
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.00048
209
SELECT category FROM cscart_category_descriptions WHERE category_id = 939 AND lang_code = 'en'
0.00019
210
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND cscart_categories.company_id = 1
0.00015
211
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
212
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND company_id = 1
0.00021
213
SELECT id_path FROM cscart_categories WHERE category_id = 940
0.00017
214
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.00060
215
SELECT category FROM cscart_category_descriptions WHERE category_id = 940 AND lang_code = 'en'
0.00022
216
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND cscart_categories.company_id = 1
0.00023
217
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.00025
218
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND company_id = 1
0.00020
219
SELECT id_path FROM cscart_categories WHERE category_id = 941
0.00014
220
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.00050
221
SELECT category FROM cscart_category_descriptions WHERE category_id = 941 AND lang_code = 'en'
0.00021
222
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND cscart_categories.company_id = 1
0.00021
223
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.00024
224
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND company_id = 1
0.00020
225
SELECT id_path FROM cscart_categories WHERE category_id = 943
0.00015
226
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.00050
227
SELECT category FROM cscart_category_descriptions WHERE category_id = 943 AND lang_code = 'en'
0.00022
228
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND cscart_categories.company_id = 1
0.00023
229
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.00025
230
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND company_id = 1
0.00020
231
SELECT id_path FROM cscart_categories WHERE category_id = 942
0.00015
232
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
233
SELECT category FROM cscart_category_descriptions WHERE category_id = 942 AND lang_code = 'en'
0.00021
234
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND cscart_categories.company_id = 1
0.00020
235
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.00031
236
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND company_id = 1
0.00041
237
SELECT id_path FROM cscart_categories WHERE category_id = 944
0.00033
238
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.00057
239
SELECT category FROM cscart_category_descriptions WHERE category_id = 944 AND lang_code = 'en'
0.00023
240
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND cscart_categories.company_id = 1
0.00020
241
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.00026
242
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND company_id = 1
0.00021
243
SELECT id_path FROM cscart_categories WHERE category_id = 945
0.00015
244
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.00051
245
SELECT category FROM cscart_category_descriptions WHERE category_id = 945 AND lang_code = 'en'
0.00021
246
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND cscart_categories.company_id = 1
0.00016
247
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.00026
248
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND company_id = 1
0.00020
249
SELECT id_path FROM cscart_categories WHERE category_id = 946
0.00013
250
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.00050
251
SELECT category FROM cscart_category_descriptions WHERE category_id = 946 AND lang_code = 'en'
0.00021
252
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND cscart_categories.company_id = 1
0.00020
253
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.00024
254
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND company_id = 1
0.00021
255
SELECT id_path FROM cscart_categories WHERE category_id = 461
0.00014
256
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.00051
257
SELECT category FROM cscart_category_descriptions WHERE category_id = 461 AND lang_code = 'en'
0.00021
258
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND cscart_categories.company_id = 1
0.00021
259
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.00043
260
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND company_id = 1
0.00020
261
SELECT id_path FROM cscart_categories WHERE category_id = 947
0.00014
262
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.00051
263
SELECT category FROM cscart_category_descriptions WHERE category_id = 947 AND lang_code = 'en'
0.00022
264
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND cscart_categories.company_id = 1
0.00020
265
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.00025
266
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND company_id = 1
0.00019
267
SELECT id_path FROM cscart_categories WHERE category_id = 468
0.00014
268
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
269
SELECT category FROM cscart_category_descriptions WHERE category_id = 468 AND lang_code = 'en'
0.00020
270
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND cscart_categories.company_id = 1
0.00022
271
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.00028
272
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND company_id = 1
0.00032
273
SELECT id_path FROM cscart_categories WHERE category_id = 932
0.00019
274
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.00063
275
SELECT category FROM cscart_category_descriptions WHERE category_id = 932 AND lang_code = 'en'
0.00023
276
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND cscart_categories.company_id = 1
0.00022
277
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
278
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.00029
279
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND company_id = 1
0.00020
280
SELECT id_path FROM cscart_categories WHERE category_id = 931
0.00014
281
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.00054
282
SELECT category FROM cscart_category_descriptions WHERE category_id = 931 AND lang_code = 'en'
0.00022
283
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND cscart_categories.company_id = 1
0.00021
284
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.00027
285
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND company_id = 1
0.00022
286
SELECT id_path FROM cscart_categories WHERE category_id = 898
0.00014
287
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.00055
288
SELECT category FROM cscart_category_descriptions WHERE category_id = 898 AND lang_code = 'en'
0.00021
289
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND cscart_categories.company_id = 1
0.00015
290
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.00024
291
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.00027
292
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND company_id = 1
0.00019
293
SELECT id_path FROM cscart_categories WHERE category_id = 899
0.00021
294
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.00052
295
SELECT category FROM cscart_category_descriptions WHERE category_id = 899 AND lang_code = 'en'
0.00020
296
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND cscart_categories.company_id = 1
0.00015
297
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.00023
298
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND company_id = 1
0.00019
299
SELECT id_path FROM cscart_categories WHERE category_id = 974
0.00021
300
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.00062
301
SELECT category FROM cscart_category_descriptions WHERE category_id = 974 AND lang_code = 'en'
0.00021
302
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND cscart_categories.company_id = 1
0.00017
303
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.00025
304
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND company_id = 1
0.00022
305
SELECT id_path FROM cscart_categories WHERE category_id = 900
0.00014
306
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.00049
307
SELECT category FROM cscart_category_descriptions WHERE category_id = 900 AND lang_code = 'en'
0.00021
308
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND cscart_categories.company_id = 1
0.00016
309
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
310
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND company_id = 1
0.00020
311
SELECT id_path FROM cscart_categories WHERE category_id = 975
0.00014
312
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.00049
313
SELECT category FROM cscart_category_descriptions WHERE category_id = 975 AND lang_code = 'en'
0.00021
314
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND cscart_categories.company_id = 1
0.00017
315
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.00024
316
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND company_id = 1
0.00019
317
SELECT id_path FROM cscart_categories WHERE category_id = 976
0.00025
318
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.00053
319
SELECT category FROM cscart_category_descriptions WHERE category_id = 976 AND lang_code = 'en'
0.00020
320
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND cscart_categories.company_id = 1
0.00020
321
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.00024
322
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND company_id = 1
0.00022
323
SELECT id_path FROM cscart_categories WHERE category_id = 977
0.00013
324
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.00052
325
SELECT category FROM cscart_category_descriptions WHERE category_id = 977 AND lang_code = 'en'
0.00020
326
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND cscart_categories.company_id = 1
0.00016
327
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
328
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND company_id = 1
0.00021
329
SELECT id_path FROM cscart_categories WHERE category_id = 978
0.00013
330
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
331
SELECT category FROM cscart_category_descriptions WHERE category_id = 978 AND lang_code = 'en'
0.00021
332
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND cscart_categories.company_id = 1
0.00014
333
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.00023
334
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND company_id = 1
0.00019
335
SELECT id_path FROM cscart_categories WHERE category_id = 979
0.00015
336
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
337
SELECT category FROM cscart_category_descriptions WHERE category_id = 979 AND lang_code = 'en'
0.00020
338
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND cscart_categories.company_id = 1
0.00015
339
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.00026
340
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND company_id = 1
0.00020
341
SELECT id_path FROM cscart_categories WHERE category_id = 980
0.00013
342
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.00050
343
SELECT category FROM cscart_category_descriptions WHERE category_id = 980 AND lang_code = 'en'
0.00019
344
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND cscart_categories.company_id = 1
0.00017
345
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.00023
346
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND company_id = 1
0.00024
347
SELECT id_path FROM cscart_categories WHERE category_id = 981
0.00018
348
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.00056
349
SELECT category FROM cscart_category_descriptions WHERE category_id = 981 AND lang_code = 'en'
0.00021
350
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND cscart_categories.company_id = 1
0.00021
351
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
352
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND company_id = 1
0.00020
353
SELECT id_path FROM cscart_categories WHERE category_id = 982
0.00015
354
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.00050
355
SELECT category FROM cscart_category_descriptions WHERE category_id = 982 AND lang_code = 'en'
0.00027
356
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND cscart_categories.company_id = 1
0.00022
357
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.00027
358
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND company_id = 1
0.00020
359
SELECT id_path FROM cscart_categories WHERE category_id = 983
0.00014
360
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.00051
361
SELECT category FROM cscart_category_descriptions WHERE category_id = 983 AND lang_code = 'en'
0.00023
362
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND cscart_categories.company_id = 1
0.00028
363
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.00039
364
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND company_id = 1
0.00020
365
SELECT id_path FROM cscart_categories WHERE category_id = 984
0.00016
366
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.00057
367
SELECT category FROM cscart_category_descriptions WHERE category_id = 984 AND lang_code = 'en'
0.00023
368
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND cscart_categories.company_id = 1
0.00021
369
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
370
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND company_id = 1
0.00020
371
SELECT id_path FROM cscart_categories WHERE category_id = 985
0.00013
372
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.00049
373
SELECT category FROM cscart_category_descriptions WHERE category_id = 985 AND lang_code = 'en'
0.00020
374
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND cscart_categories.company_id = 1
0.00015
375
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
376
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND company_id = 1
0.00020
377
SELECT id_path FROM cscart_categories WHERE category_id = 513
0.00013
378
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.00061
379
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(417, 516, 919) 
0.00023
380
SELECT category FROM cscart_category_descriptions WHERE category_id = 513 AND lang_code = 'en'
0.00020
381
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND cscart_categories.company_id = 1
0.00018
382
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.00026
383
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND company_id = 1
0.00018
384
SELECT id_path FROM cscart_categories WHERE category_id = 422
0.00012
385
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.00059
386
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(436, 458, 883) 
0.00020
387
SELECT category FROM cscart_category_descriptions WHERE category_id = 422 AND lang_code = 'en'
0.00015
388
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND cscart_categories.company_id = 1
0.00014
389
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.00023
390
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.00029
391
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND company_id = 1
0.00021
392
SELECT id_path FROM cscart_categories WHERE category_id = 424
0.00013
393
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.00064
394
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(512, 517, 441, 453, 854) 
0.00023
395
SELECT category FROM cscart_category_descriptions WHERE category_id = 424 AND lang_code = 'en'
0.00019
396
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND cscart_categories.company_id = 1
0.00017
397
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.00023
398
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND company_id = 1
0.00019
399
SELECT id_path FROM cscart_categories WHERE category_id = 414
0.00013
400
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.00063
401
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(442, 454, 463, 474, 434, 477) 
0.00025
402
SELECT category FROM cscart_category_descriptions WHERE category_id = 414 AND lang_code = 'en'
0.00015
403
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND cscart_categories.company_id = 1
0.00014
404
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.00023
405
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND company_id = 1
0.00020
406
SELECT id_path FROM cscart_categories WHERE category_id = 415
0.00013
407
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.00085
408
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.00026
409
SELECT category FROM cscart_category_descriptions WHERE category_id = 415 AND lang_code = 'en'
0.00019
410
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND cscart_categories.company_id = 1
0.00015
411
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.00023
412
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND company_id = 1
0.00023
413
SELECT id_path FROM cscart_categories WHERE category_id = 416
0.00012
414
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.00078
415
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.00023
416
SELECT category FROM cscart_category_descriptions WHERE category_id = 416 AND lang_code = 'en'
0.00020
417
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND cscart_categories.company_id = 1
0.00016
418
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.00023
419
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND company_id = 1
0.00019
420
SELECT id_path FROM cscart_categories WHERE category_id = 501
0.00023
421
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.00080
422
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(502, 864, 503, 863, 504, 505, 506, 507, 509, 853, 916) 
0.00030
423
SELECT category FROM cscart_category_descriptions WHERE category_id = 501 AND lang_code = 'en'
0.00028
424
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND cscart_categories.company_id = 1
0.00022
425
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.00029
426
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 412  AND cscart_categories.company_id = 1
0.00028
427
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND cscart_categories.company_id = 1
0.00026
428
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND cscart_categories.company_id = 1
0.00022
429
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND cscart_categories.company_id = 1
0.00021
430
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND cscart_categories.company_id = 1
0.00019
431
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND cscart_categories.company_id = 1
0.00021
432
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND cscart_categories.company_id = 1
0.00022
433
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND cscart_categories.company_id = 1
0.00040
434
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND cscart_categories.company_id = 1
0.00052
435
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND cscart_categories.company_id = 1
0.00021
436
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND cscart_categories.company_id = 1
0.00024
437
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND cscart_categories.company_id = 1
0.00019
438
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND cscart_categories.company_id = 1
0.00019
439
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND cscart_categories.company_id = 1
0.00017
440
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND cscart_categories.company_id = 1
0.00018
441
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND cscart_categories.company_id = 1
0.00015
442
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND cscart_categories.company_id = 1
0.00022
443
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND cscart_categories.company_id = 1
0.00019
444
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND cscart_categories.company_id = 1
0.00020
445
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND cscart_categories.company_id = 1
0.00014
446
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 452  AND cscart_categories.company_id = 1
0.00016
447
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND cscart_categories.company_id = 1
0.00021
448
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND cscart_categories.company_id = 1
0.00021
449
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 897  AND cscart_categories.company_id = 1
0.00021
450
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND cscart_categories.company_id = 1
0.00020
451
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND cscart_categories.company_id = 1
0.00018
452
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND cscart_categories.company_id = 1
0.00016
453
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND cscart_categories.company_id = 1
0.00020
454
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND cscart_categories.company_id = 1
0.00023
455
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND cscart_categories.company_id = 1
0.00018
456
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND cscart_categories.company_id = 1
0.00019
457
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND cscart_categories.company_id = 1
0.00015
458
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND cscart_categories.company_id = 1
0.00018
459
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND cscart_categories.company_id = 1
0.00025
460
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND cscart_categories.company_id = 1
0.00014
461
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND cscart_categories.company_id = 1
0.00019
462
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND cscart_categories.company_id = 1
0.00017
463
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND cscart_categories.company_id = 1
0.00018
464
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND cscart_categories.company_id = 1
0.00021
465
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND cscart_categories.company_id = 1
0.00026
466
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 417  AND cscart_categories.company_id = 1
0.00019
467
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 516  AND cscart_categories.company_id = 1
0.00014
468
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 919  AND cscart_categories.company_id = 1
0.00014
469
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 413  AND cscart_categories.company_id = 1
0.00014
470
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND cscart_categories.company_id = 1
0.00015
471
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 436  AND cscart_categories.company_id = 1
0.00022
472
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 458  AND cscart_categories.company_id = 1
0.00021
473
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 883  AND cscart_categories.company_id = 1
0.00016
474
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND cscart_categories.company_id = 1
0.00027
475
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 512  AND cscart_categories.company_id = 1
0.00022
476
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 517  AND cscart_categories.company_id = 1
0.00019
477
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 441  AND cscart_categories.company_id = 1
0.00020
478
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 453  AND cscart_categories.company_id = 1
0.00019
479
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 854  AND cscart_categories.company_id = 1
0.00021
480
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND cscart_categories.company_id = 1
0.00020
481
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 434  AND cscart_categories.company_id = 1
0.00018
482
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 442  AND cscart_categories.company_id = 1
0.00019
483
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 454  AND cscart_categories.company_id = 1
0.00019
484
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 463  AND cscart_categories.company_id = 1
0.00013
485
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 474  AND cscart_categories.company_id = 1
0.00013
486
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 477  AND cscart_categories.company_id = 1
0.00013
487
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND cscart_categories.company_id = 1
0.00019
488
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 421  AND cscart_categories.company_id = 1
0.00017
489
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 915  AND cscart_categories.company_id = 1
0.00021
490
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 435  AND cscart_categories.company_id = 1
0.00017
491
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 881  AND cscart_categories.company_id = 1
0.00015
492
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 888  AND cscart_categories.company_id = 1
0.00015
493
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 450  AND cscart_categories.company_id = 1
0.00014
494
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 460  AND cscart_categories.company_id = 1
0.00016
495
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 467  AND cscart_categories.company_id = 1
0.00015
496
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 471  AND cscart_categories.company_id = 1
0.00014
497
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 425  AND cscart_categories.company_id = 1
0.00013
498
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 886  AND cscart_categories.company_id = 1
0.00015
499
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 440  AND cscart_categories.company_id = 1
0.00014
500
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 889  AND cscart_categories.company_id = 1
0.00013
501
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 428  AND cscart_categories.company_id = 1
0.00014
502
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 443  AND cscart_categories.company_id = 1
0.00014
503
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 887  AND cscart_categories.company_id = 1
0.00016
504
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND cscart_categories.company_id = 1
0.00016
505
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 423  AND cscart_categories.company_id = 1
0.00014
506
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 445  AND cscart_categories.company_id = 1
0.00013
507
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 426  AND cscart_categories.company_id = 1
0.00014
508
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 455  AND cscart_categories.company_id = 1
0.00015
509
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 466  AND cscart_categories.company_id = 1
0.00014
510
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 465  AND cscart_categories.company_id = 1
0.00014
511
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 855  AND cscart_categories.company_id = 1
0.00014
512
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 430  AND cscart_categories.company_id = 1
0.00014
513
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 447  AND cscart_categories.company_id = 1
0.00022
514
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 832  AND cscart_categories.company_id = 1
0.00015
515
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 840  AND cscart_categories.company_id = 1
0.00023
516
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 874  AND cscart_categories.company_id = 1
0.00019
517
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND cscart_categories.company_id = 1
0.00017
518
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 502  AND cscart_categories.company_id = 1
0.00016
519
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 503  AND cscart_categories.company_id = 1
0.00020
520
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 504  AND cscart_categories.company_id = 1
0.00015
521
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 505  AND cscart_categories.company_id = 1
0.00019
522
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 506  AND cscart_categories.company_id = 1
0.00022
523
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 509  AND cscart_categories.company_id = 1
0.00019
524
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 853  AND cscart_categories.company_id = 1
0.00022
525
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 863  AND cscart_categories.company_id = 1
0.00020
526
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 864  AND cscart_categories.company_id = 1
0.00020
527
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 507  AND cscart_categories.company_id = 1
0.00021
528
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 916  AND cscart_categories.company_id = 1
0.00033
529
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 = 130 
0.00030
530
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 130 AND object_type = 'A'  AND cscart_discussion.company_id = 1  
0.00029
531
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 9932  AND cscart_discussion.company_id = 1
0.00022
532
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00026
533
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00219
534
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.00031
535
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.00022
536
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.00020
537
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00014
538
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00213
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 = 2 
0.00027
540
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00025
541
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.00023
542
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 43 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00030
543
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.00021
544
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 59 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00021
545
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
0.00019
546
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
0.00214
547
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.00030
548
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 64 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
0.00028
549
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 = 130 
0.00029

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.00009 0.00023 0.00014
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 = 130 
11 0.00021 0.00043 0.00030
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 
5 0.00021 0.00040 0.00030
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.00024 0.00034 0.00029
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = '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.00047 0.00057 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.00025 0.00029 0.00027
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
4 0.00014 0.00027 0.00021
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.00021 0.00035 0.00025
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
4 0.00213 0.00219 0.00215
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.00030 0.00044 0.00035
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.00083 0.00088 0.00085
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.00034 0.00044 0.00038
SELECT * FROM cscart_image_gallery_settings WHERE id=130 AND type='C'
2 0.00020 0.00027 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 = 51 
2 0.00020 0.00026 0.00023
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 48 
2 0.00022 0.00024 0.00023
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 47 
2 0.00024 0.00031 0.00028
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 942  AND cscart_categories.company_id = 1
2 0.00017 0.00020 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND cscart_categories.company_id = 1
2 0.00019 0.00022 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND cscart_categories.company_id = 1
2 0.00019 0.00021 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND cscart_categories.company_id = 1
2 0.00018 0.00020 0.00019
SELECT * FROM cscart_image_gallery_settings WHERE id=55 AND type='C'
2 0.00016 0.00024 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND cscart_categories.company_id = 1
2 0.00015 0.00016 0.00015
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 55 
2 0.00027 0.00030 0.00028
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND cscart_categories.company_id = 1
2 0.00014 0.00040 0.00027
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  AND cscart_categories.company_id = 1
2 0.00015 0.00018 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND cscart_categories.company_id = 1
2 0.00020 0.00022 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND cscart_categories.company_id = 1
2 0.00014 0.00021 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND cscart_categories.company_id = 1
2 0.00021 0.00022 0.00022
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 1 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00040 0.00060 0.00050
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND cscart_categories.company_id = 1
2 0.00015 0.00021 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND cscart_categories.company_id = 1
2 0.00015 0.00022 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND cscart_categories.company_id = 1
2 0.00014 0.00052 0.00033
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND cscart_categories.company_id = 1
2 0.00017 0.00027 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 513  AND cscart_categories.company_id = 1
2 0.00018 0.00026 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND cscart_categories.company_id = 1
2 0.00021 0.00022 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND cscart_categories.company_id = 1
2 0.00015 0.00021 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND cscart_categories.company_id = 1
2 0.00014 0.00020 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 922  AND cscart_categories.company_id = 1
2 0.00019 0.00020 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND cscart_categories.company_id = 1
2 0.00016 0.00017 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 925  AND cscart_categories.company_id = 1
2 0.00020 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND cscart_categories.company_id = 1
2 0.00017 0.00028 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND cscart_categories.company_id = 1
2 0.00023 0.00024 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND cscart_categories.company_id = 1
2 0.00015 0.00019 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND cscart_categories.company_id = 1
2 0.00015 0.00022 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND cscart_categories.company_id = 1
2 0.00019 0.00021 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND cscart_categories.company_id = 1
2 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND cscart_categories.company_id = 1
2 0.00018 0.00021 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND cscart_categories.company_id = 1
2 0.00022 0.00026 0.00024
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND cscart_categories.company_id = 1
2 0.00019 0.00023 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND cscart_categories.company_id = 1
2 0.00017 0.00022 0.00019
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.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.00040 0.00040 0.00040
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND cscart_categories.company_id = 1
2 0.00017 0.00025 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND cscart_categories.company_id = 1
2 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND cscart_categories.company_id = 1
2 0.00016 0.00019 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND cscart_categories.company_id = 1
2 0.00015 0.00018 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND cscart_categories.company_id = 1
2 0.00016 0.00020 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND cscart_categories.company_id = 1
2 0.00015 0.00020 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 975  AND cscart_categories.company_id = 1
2 0.00017 0.00023 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND cscart_categories.company_id = 1
2 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 976  AND cscart_categories.company_id = 1
2 0.00018 0.00020 0.00019
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718145
2 0.00020 0.00022 0.00021
DELETE FROM cscart_access_restriction_block WHERE expires < 1751287448
2 0.00013 0.00024 0.00018
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751287448
2 0.00015 0.00025 0.00020
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.00024 0.00030 0.00027
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
2 0.00017 0.00024 0.00020
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 = 130 
2 0.00031 0.00039 0.00035
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 1 AND layout_id = 2
2 0.00029 0.00030 0.00030
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.00038 0.00048 0.00043
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND cscart_categories.company_id = 1
2 0.00014 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 468  AND cscart_categories.company_id = 1
2 0.00014 0.00022 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND cscart_categories.company_id = 1
2 0.00014 0.00015 0.00014
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 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 id_path FROM cscart_categories WHERE category_id = 979
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/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.00049 0.00049 0.00049
SELECT category FROM cscart_category_descriptions WHERE category_id = 975 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/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 category FROM cscart_category_descriptions WHERE category_id = 985 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT id_path FROM cscart_categories WHERE category_id = 513
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/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.00049 0.00049 0.00049
SELECT id_path FROM cscart_categories WHERE category_id = 985
1 0.00013 0.00013 0.00013
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.00024 0.00024 0.00024
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 985  AND company_id = 1
1 0.00020 0.00020 0.00020
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 = 976  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT id_path FROM cscart_categories WHERE category_id = 975
1 0.00014 0.00014 0.00014
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_categories WHERE category_id = 975  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 422  AND company_id = 1
1 0.00018 0.00018 0.00018
SELECT category FROM cscart_category_descriptions WHERE category_id = 422 AND lang_code = 'en'
1 0.00015 0.00015 0.00015
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(436, 458, 883) 
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 '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.00059 0.00059 0.00059
SELECT id_path FROM cscart_categories WHERE category_id = 422
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 900  AND company_id = 1
1 0.00022 0.00022 0.00022
SELECT id_path FROM cscart_categories WHERE category_id = 900
1 0.00014 0.00014 0.00014
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.00026 0.00026 0.00026
SELECT id_path FROM cscart_categories WHERE category_id = 976
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/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.00049 0.00049 0.00049
SELECT category FROM cscart_category_descriptions WHERE category_id = 900 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT category FROM cscart_category_descriptions WHERE category_id = 513 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(417, 516, 919) 
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 979  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 '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.00061 0.00061 0.00061
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/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.00053 0.00053 0.00053
SELECT category FROM cscart_category_descriptions WHERE category_id = 984 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/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.00050 0.00050 0.00050
SELECT id_path FROM cscart_categories WHERE category_id = 980
1 0.00013 0.00013 0.00013
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 '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.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 982
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 982  AND company_id = 1
1 0.00020 0.00020 0.00020
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 category FROM cscart_category_descriptions WHERE category_id = 981 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT category FROM cscart_category_descriptions WHERE category_id = 982 AND lang_code = 'en'
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 '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.00056 0.00056 0.00056
SELECT id_path FROM cscart_categories WHERE category_id = 981
1 0.00018 0.00018 0.00018
SELECT category FROM cscart_category_descriptions WHERE category_id = 977 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 981  AND company_id = 1
1 0.00024 0.00024 0.00024
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.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 980 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/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.00050 0.00050 0.00050
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 980  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 978  AND company_id = 1
1 0.00021 0.00021 0.00021
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.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/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.00057 0.00057 0.00057
SELECT id_path FROM cscart_categories WHERE category_id = 984
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 984  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT category FROM cscart_category_descriptions WHERE category_id = 976 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT category FROM cscart_category_descriptions WHERE category_id = 979 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
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.00039 0.00039 0.00039
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.00023 0.00023 0.00023
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.00027 0.00027 0.00027
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 977  AND 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/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.00051 0.00051 0.00051
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 = 983
1 0.00014 0.00014 0.00014
SELECT id_path FROM cscart_categories WHERE category_id = 978
1 0.00013 0.00013 0.00013
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.00026 0.00026 0.00026
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 983  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT category FROM cscart_category_descriptions WHERE category_id = 983 AND lang_code = 'en'
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 415  AND company_id = 1
1 0.00020 0.00020 0.00020
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.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 889  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 465  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 466  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 455  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 426  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 445  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.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 887  AND cscart_categories.company_id = 1
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 443  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
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 = 440  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 430  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 886  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 425  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 471  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
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.00016 0.00016 0.00016
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.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 881  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 435  AND cscart_categories.company_id = 1
1 0.00017 0.00017 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 915  AND cscart_categories.company_id = 1
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 855  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 447  AND cscart_categories.company_id = 1
1 0.00022 0.00022 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 477  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 507  AND cscart_categories.company_id = 1
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 64 
1 0.00030 0.00030 0.00030
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 59 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 59 
1 0.00021 0.00021 0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 43 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00030 0.00030 0.00030
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 43 
1 0.00023 0.00023 0.00023
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00025 0.00025 0.00025
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.00027 0.00027 0.00027
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 9932  AND cscart_discussion.company_id = 1
1 0.00022 0.00022 0.00022
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 130 AND object_type = 'A'  AND cscart_discussion.company_id = 1  
1 0.00029 0.00029 0.00029
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 916  AND cscart_categories.company_id = 1
1 0.00033 0.00033 0.00033
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 864  AND cscart_categories.company_id = 1
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 832  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 863  AND cscart_categories.company_id = 1
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 853  AND cscart_categories.company_id = 1
1 0.00022 0.00022 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 509  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 506  AND cscart_categories.company_id = 1
1 0.00022 0.00022 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 505  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 504  AND cscart_categories.company_id = 1
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 503  AND cscart_categories.company_id = 1
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 502  AND cscart_categories.company_id = 1
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 874  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 840  AND cscart_categories.company_id = 1
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 421  AND cscart_categories.company_id = 1
1 0.00017 0.00017 0.00017
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 474  AND cscart_categories.company_id = 1
1 0.00013 0.00013 0.00013
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.00029 0.00029 0.00029
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.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.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 '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.00078 0.00078 0.00078
SELECT id_path FROM cscart_categories WHERE category_id = 416
1 0.00012 0.00012 0.00012
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 416  AND company_id = 1
1 0.00023 0.00023 0.00023
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.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 415 AND lang_code = 'en'
1 0.00019 0.00019 0.00019
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.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 '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.00085 0.00085 0.00085
SELECT id_path FROM cscart_categories WHERE category_id = 415
1 0.00013 0.00013 0.00013
SELECT category FROM cscart_category_descriptions WHERE category_id = 414 AND lang_code = 'en'
1 0.00015 0.00015 0.00015
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.00023 0.00023 0.00023
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 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.00063 0.00063 0.00063
SELECT id_path FROM cscart_categories WHERE category_id = 414
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 414  AND company_id = 1
1 0.00019 0.00019 0.00019
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.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 424 AND lang_code = 'en'
1 0.00019 0.00019 0.00019
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(512, 517, 441, 453, 854) 
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 '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.00064 0.00064 0.00064
SELECT id_path FROM cscart_categories WHERE category_id = 424
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 424  AND company_id = 1
1 0.00021 0.00021 0.00021
SELECT category FROM cscart_category_descriptions WHERE category_id = 416 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 501  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 463  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.00022 0.00022 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 454  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 442  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 434  AND cscart_categories.company_id = 1
1 0.00018 0.00018 0.00018
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 854  AND cscart_categories.company_id = 1
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 453  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 441  AND cscart_categories.company_id = 1
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 517  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 512  AND cscart_categories.company_id = 1
1 0.00022 0.00022 0.00022
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 883  AND cscart_categories.company_id = 1
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 458  AND cscart_categories.company_id = 1
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 413  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
SELECT id_path FROM cscart_categories WHERE category_id = 501
1 0.00023 0.00023 0.00023
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 919  AND cscart_categories.company_id = 1
1 0.00014 0.00014 0.00014
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 = 417  AND cscart_categories.company_id = 1
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 897  AND cscart_categories.company_id = 1
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 452  AND cscart_categories.company_id = 1
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 412  AND cscart_categories.company_id = 1
1 0.00028 0.00028 0.00028
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.00029 0.00029 0.00029
SELECT category FROM cscart_category_descriptions WHERE category_id = 501 AND lang_code = 'en'
1 0.00028 0.00028 0.00028
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.00030 0.00030 0.00030
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.00080 0.00080 0.00080
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.00025 0.00025 0.00025
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
1 0.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 974 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY `position`;
1 0.00034 0.00034 0.00034
SELECT status FROM cscart_menus WHERE menu_id = 7
1 0.00024 0.00024 0.00024
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 51 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00040 0.00040 0.00040
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.00029 0.00029 0.00029
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 77 
1 0.00030 0.00030 0.00030
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.00060 0.00060 0.00060
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.00026 0.00026 0.00026
SELECT status FROM cscart_menus WHERE menu_id = 3
1 0.00028 0.00028 0.00028
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 130 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'de' 
1 0.00025 0.00025 0.00025
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.00091 0.00091 0.00091
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 = 130 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.00063 0.00063 0.00063
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.00196 0.00196 0.00196
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 325
1 0.00020 0.00020 0.00020
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 325
1 0.00034 0.00034 0.00034
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
1 0.00035 0.00035 0.00035
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
1 0.00030 0.00030 0.00030
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 130
1 0.00030 0.00030 0.00030
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 (130) 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 <= 1751287448 AND avail_till_timestamp >= 1751287448)) ORDER BY cscart_pages.timestamp desc  LIMIT 0, 10
1 0.00049 0.00049 0.00049
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.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 482  AND company_id = 1
1 0.00028 0.00028 0.00028
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
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/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.00056 0.00056 0.00056
SELECT id_path FROM cscart_categories WHERE category_id = 929
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 929  AND company_id = 1
1 0.00022 0.00022 0.00022
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.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 922 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/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.00056 0.00056 0.00056
SELECT id_path FROM cscart_categories WHERE category_id = 922
1 0.00019 0.00019 0.00019
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.00026 0.00026 0.00026
SELECT category FROM cscart_category_descriptions WHERE category_id = 925 AND lang_code = 'en'
1 0.00031 0.00031 0.00031
SELECT id_path FROM cscart_categories WHERE category_id = 925
1 0.00014 0.00014 0.00014
SELECT id_path FROM cscart_categories WHERE category_id = 482
1 0.00021 0.00021 0.00021
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.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 432 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/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.00075 0.00075 0.00075
SELECT id_path FROM cscart_categories WHERE category_id = 432
1 0.00016 0.00016 0.00016
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 432  AND company_id = 1
1 0.00020 0.00020 0.00020
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.00029 0.00029 0.00029
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.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 482 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/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.00056 0.00056 0.00056
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 (130) 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 <= 1751287448 AND avail_till_timestamp >= 1751287448)) ORDER BY cscart_pages.timestamp desc
1 0.00047 0.00047 0.00047
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = '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.00035 0.00035 0.00035
SELECT category FROM cscart_category_descriptions WHERE category_id = 929 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SET time_zone = '+02:00'
1 0.00026 0.00026 0.00026
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'en'  WHERE 1  AND a.is_primary = 'Y' ORDER BY a.position
1 0.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.00039 0.00039 0.00039
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 130 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00040 0.00040 0.00040
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.00047 0.00047 0.00047
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.00031 0.00031 0.00031
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.00033 0.00033 0.00033
SELECT * FROM cscart_seo_names WHERE name = 'welches-zubehoer-wird-fur-den-einbau-von-dachfenstern-benoetigt-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
1 0.00038 0.00038 0.00038
SELECT * FROM cscart_seo_names WHERE name = 'welches-zubehoer-wird-fur-den-einbau-von-dachfenstern-benoetigt-en'  AND lang_code = 'de'
1 0.00057 0.00057 0.00057
SELECT type FROM cscart_seo_names WHERE name = 'welches-zubehoer-wird-fur-den-einbau-von-dachfenstern-benoetigt-en'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
1 0.00052 0.00052 0.00052
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
1 0.00018 0.00018 0.00018
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
1 0.00031 0.00031 0.00031
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
1 0.00023 0.00023 0.00023
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (1) AND status IN ('A', 'P', 'N')
1 0.00040 0.00040 0.00040
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1
1 0.00024 0.00024 0.00024
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?baubay.de'
1 0.00030 0.00030 0.00030
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.00038 0.00038 0.00038
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.00032 0.00032 0.00032
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.00043 0.00043 0.00043
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.00047 0.00047 0.00047
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
1 0.00027 0.00027 0.00027
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 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 = 130 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.00062 0.00062 0.00062
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.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 = 55 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00031 0.00031 0.00031
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.00051 0.00051 0.00051
SELECT company FROM cscart_companies WHERE company_id = 1
1 0.00015 0.00015 0.00015
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 130 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id 
1 0.00037 0.00037 0.00037
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 = 130 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 = 130 AND lang_code = 'en' AND type = 'C'
1 0.00019 0.00019 0.00019
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 = 130
1 0.00039 0.00039 0.00039
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'blog' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 130 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00038 0.00038 0.00038
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label6'
1 0.00023 0.00023 0.00023
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
1 0.00030 0.00030 0.00030
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.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_label9'
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_label8'
1 0.00022 0.00022 0.00022
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label1'
1 0.00023 0.00023 0.00023
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label3'
1 0.00023 0.00023 0.00023
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label5'
1 0.00019 0.00019 0.00019
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.00020 0.00020 0.00020
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.00022 0.00022 0.00022
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'en' AND lang.name = 'filter_description_label7'
1 0.00026 0.00026 0.00026
SELECT * 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(130, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00040 0.00040 0.00040
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.00060 0.00060 0.00060
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.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/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.00062 0.00062 0.00062
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 947  AND company_id = 1
1 0.00020 0.00020 0.00020
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.00028 0.00028 0.00028
SELECT category FROM cscart_category_descriptions WHERE category_id = 468 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/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.00014 0.00014 0.00014
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.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 947 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/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.00051 0.00051 0.00051
SELECT id_path FROM cscart_categories WHERE category_id = 947
1 0.00014 0.00014 0.00014
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.00043 0.00043 0.00043
SELECT id_path FROM cscart_categories WHERE category_id = 932
1 0.00019 0.00019 0.00019
SELECT category FROM cscart_category_descriptions WHERE category_id = 461 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/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.00051 0.00051 0.00051
SELECT id_path FROM cscart_categories WHERE category_id = 461
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 461  AND company_id = 1
1 0.00021 0.00021 0.00021
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.00024 0.00024 0.00024
SELECT category FROM cscart_category_descriptions WHERE category_id = 946 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/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.00050 0.00050 0.00050
SELECT id_path FROM cscart_categories WHERE category_id = 946
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 946  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 932  AND company_id = 1
1 0.00032 0.00032 0.00032
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.00063 0.00063 0.00063
SELECT category FROM cscart_category_descriptions WHERE category_id = 945 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT category FROM cscart_category_descriptions WHERE category_id = 898 AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT id_path FROM cscart_categories WHERE category_id = 974
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 974  AND company_id = 1
1 0.00019 0.00019 0.00019
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.00023 0.00023 0.00023
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.00052 0.00052 0.00052
SELECT id_path FROM cscart_categories WHERE category_id = 899
1 0.00021 0.00021 0.00021
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 899  AND company_id = 1
1 0.00019 0.00019 0.00019
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.00027 0.00027 0.00027
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.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/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.00055 0.00055 0.00055
SELECT category FROM cscart_category_descriptions WHERE category_id = 932 AND lang_code = 'en'
1 0.00023 0.00023 0.00023
SELECT id_path FROM cscart_categories WHERE category_id = 898
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 898  AND company_id = 1
1 0.00022 0.00022 0.00022
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.00027 0.00027 0.00027
SELECT category FROM cscart_category_descriptions WHERE category_id = 931 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 '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.00054 0.00054 0.00054
SELECT id_path FROM cscart_categories WHERE category_id = 931
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 931  AND company_id = 1
1 0.00020 0.00020 0.00020
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.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 addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
1 0.00027 0.00027 0.00027
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.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/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.00051 0.00051 0.00051
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 890  AND company_id = 1
1 0.00019 0.00019 0.00019
SELECT id_path FROM cscart_categories WHERE category_id = 938
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 940  AND company_id = 1
1 0.00021 0.00021 0.00021
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.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/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.00048 0.00048 0.00048
SELECT id_path FROM cscart_categories WHERE category_id = 939
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 939  AND company_id = 1
1 0.00020 0.00020 0.00020
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.00023 0.00023 0.00023
SELECT category FROM cscart_category_descriptions WHERE category_id = 938 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/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.00047 0.00047 0.00047
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 938  AND company_id = 1
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/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.00060 0.00060 0.00060
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.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 937 AND lang_code = 'en'
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/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.00048 0.00048 0.00048
SELECT id_path FROM cscart_categories WHERE category_id = 937
1 0.00013 0.00013 0.00013
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 937  AND company_id = 1
1 0.00019 0.00019 0.00019
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.00024 0.00024 0.00024
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.00047 0.00047 0.00047
SELECT id_path FROM cscart_categories WHERE category_id = 890
1 0.00013 0.00013 0.00013
SELECT id_path FROM cscart_categories WHERE category_id = 940
1 0.00017 0.00017 0.00017
SELECT category FROM cscart_category_descriptions WHERE category_id = 940 AND lang_code = 'en'
1 0.00022 0.00022 0.00022
SELECT id_path FROM cscart_categories WHERE category_id = 945
1 0.00015 0.00015 0.00015
SELECT id_path FROM cscart_categories WHERE category_id = 942
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 945  AND company_id = 1
1 0.00021 0.00021 0.00021
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.00026 0.00026 0.00026
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.00057 0.00057 0.00057
SELECT id_path FROM cscart_categories WHERE category_id = 944
1 0.00033 0.00033 0.00033
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 944  AND company_id = 1
1 0.00041 0.00041 0.00041
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.00031 0.00031 0.00031
SELECT category FROM cscart_category_descriptions WHERE category_id = 942 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/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.00020 0.00020 0.00020
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.00025 0.00025 0.00025
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.00025 0.00025 0.00025
SELECT category FROM cscart_category_descriptions WHERE category_id = 943 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/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.00050 0.00050 0.00050
SELECT id_path FROM cscart_categories WHERE category_id = 943
1 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 943  AND company_id = 1
1 0.00020 0.00020 0.00020
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.00024 0.00024 0.00024
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.00050 0.00050 0.00050
SELECT id_path FROM cscart_categories WHERE category_id = 941
1 0.00014 0.00014 0.00014
SELECT COUNT(*) FROM cscart_categories WHERE category_id = 941  AND company_id = 1
1 0.00020 0.00020 0.00020
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 64 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00028 0.00028 0.00028