Queries total time: 0.08094 s.
Query Time
1
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
0.00067
2
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
0.00067
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.00105
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.00066
5
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 291 ORDER BY cscart_settings_objects.position
0.00063
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.00075
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.00063
8
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?shop.daewoo.ir'
0.00058
9
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 6
0.00050
10
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (6) AND status IN ('A', 'P', 'N')
0.00054
11
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
0.00049
12
SELECT entry_page FROM cscart_companies WHERE company_id = 6 AND redirect_customer != 'Y'
0.00049
13
SET time_zone = '+04:30'
0.00046
14
SELECT * FROM cscart_mobile_admin_app_settings
0.00061
15
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'A'
0.00064
16
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'C'
0.00055
17
SELECT type FROM cscart_seo_names WHERE name = 'supporter'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0)
0.00094
18
SELECT * FROM cscart_seo_names WHERE name = 'supporter'  AND lang_code = 'fa'
0.00088
19
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00067
20
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.00066
21
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 = 6  WHERE 1  AND section_id = '47' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
0.00094
22
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 75 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'fa' 
0.00078
23
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00067
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 = 'fa' 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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
0.00087
25
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 6 
0.00060
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.00064
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 = 6  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.00066
28
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00061
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.00061
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 = 6  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.00066
31
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
0.00049
32
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 40, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Marina', 1, 0))  AND company_id = 6
0.00089
33
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 = 'fa' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (108, 148, 149, 150) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00120
34
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
0.00053
35

                SELECT c.company_id, c.storefront, c.email, l.name, l.lang_code
                FROM cscart_languages as l
                INNER JOIN cscart_ult_objects_sharing as s ON (s.share_object_id = l.lang_id AND s.share_object_type = 'languages')
                LEFT JOIN cscart_companies as c ON c.company_id = s.share_company_id WHERE c.status = 'A' AND l.status = 'A' ORDER BY l.lang_code = 'fa' DESC
0.00099
36
SELECT * FROM cscart_se_settings
0.00062
37
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 1
0.00065
38
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 7
0.00095
39
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 13
0.00071
40
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 5
0.00063
41
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 8
0.00067
42
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 6
0.00059
43
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 12
0.00059
44
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 75 
0.00070
45
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
0.00062
46
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'fa' WHERE l.layout_id = 40  AND l.dispatch = 'pages.view' AND (FIND_IN_SET(75, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
0.00146
47
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 = 'fa' 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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 75 AND cscart_page_descriptions.lang_code = 'fa'  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.00121
48
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.00065
49
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 = 6  WHERE 1  AND section_id = '18' 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.00151
50
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.00067
51
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 = 6  WHERE 1  AND section_id = '18' 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.00144
52
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
0.00052
53
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.00063
54
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 = 6  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.00070
55
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00064
56
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 40, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Marina', 1, 0))  AND company_id = 6
0.00075
57
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 = 'fa' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (108, 148, 149, 150) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00122
58
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.00064
59
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 = 6  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.00071
60
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00064
61
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 40, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Marina', 1, 0))  AND company_id = 6
0.00081
62
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.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 = 'fa' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (108, 148, 149, 150) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00113
63
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.00068
64
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 = 6  WHERE 1  AND section_id = '18' 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.00147
65
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.00064
66
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 = 6  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.00070
67
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00067
68
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 40, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Marina', 1, 0))  AND company_id = 6
0.00074
69
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'fa' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (108, 148, 149, 150) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00110
70
SELECT cscart_tags.tag_id, cscart_tag_links.object_id, cscart_tag_links.object_type, cscart_tags.tag, cscart_tags.status, COUNT(cscart_tag_links.tag_id) as popularity FROM cscart_tags LEFT JOIN cscart_tag_links ON cscart_tag_links.tag_id = cscart_tags.tag_id WHERE 1  AND cscart_tags.company_id = 6 AND cscart_tag_links.object_type = 'A' AND cscart_tags.status IN ('A') AND cscart_tag_links.object_id = 75 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 
0.00066
71
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 75
0.00057
72
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
0.00059
73
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
0.00068
74
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
0.00064
75
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 75 
0.00067
76
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
0.00057
77
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 720
0.00248
78
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 720
0.00056
79
SELECT c.*, IF (c.location_id != 720, 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 = 40 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
0.01313
80
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 (2837, 2838, 2879, 2840) ORDER BY g.order, g.parent_id, g.grid_id ASC
0.00148
81
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 = 75 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (3624, 3625, 3626, 3627, 3630, 3629, 3628, 3636, 3637, 3639, 3640, 3642, 3643, 3644, 7014, 7015, 7019, 7013, 7016, 7018, 3641, 7017, 3638, 3724, 3725, 3727, 3729, 3730, 3726, 3728, 6583, 3621, 6987, 3622, 7027, 6986, 3623, 6988, 3619, 3620)  AND cscart_bm_blocks_descriptions.lang_code='fa'  AND cscart_bm_blocks.company_id = 6 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
0.00544
82
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 75 AND object_type = 'A'  AND cscart_discussion.company_id = 6  
0.00067
83
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 1247  AND cscart_discussion.company_id = 6
0.00055

Warning Some queries are being executed multiple times

Queries max count: 5
Query Count Min time Max time Average time
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.00061 0.00064 0.00063
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 = 6  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.00066 0.00071 0.00069
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 40, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Marina', 1, 0))  AND company_id = 6
4 0.00074 0.00089 0.00080
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
4 0.00061 0.00067 0.00064
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 = 'fa' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (108, 148, 149, 150) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
4 0.00110 0.00122 0.00116
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 = 6  WHERE 1  AND section_id = '18' 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.00144 0.00151 0.00147
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.00065 0.00068 0.00067
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 75 
2 0.00067 0.00070 0.00068
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
2 0.00067 0.00068 0.00067
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
2 0.00057 0.00062 0.00059
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 6
1 0.00059 0.00059 0.00059
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 1
1 0.00065 0.00065 0.00065
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 7
1 0.00095 0.00095 0.00095
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 75 AND object_type = 'A'  AND cscart_discussion.company_id = 6  
1 0.00067 0.00067 0.00067
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 = 75 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (3624, 3625, 3626, 3627, 3630, 3629, 3628, 3636, 3637, 3639, 3640, 3642, 3643, 3644, 7014, 7015, 7019, 7013, 7016, 7018, 3641, 7017, 3638, 3724, 3725, 3727, 3729, 3730, 3726, 3728, 6583, 3621, 6987, 3622, 7027, 6986, 3623, 6988, 3619, 3620)  AND cscart_bm_blocks_descriptions.lang_code='fa'  AND cscart_bm_blocks.company_id = 6 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00544 0.00544 0.00544
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 (2837, 2838, 2879, 2840) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00148 0.00148 0.00148
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 13
1 0.00071 0.00071 0.00071
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 5
1 0.00063 0.00063 0.00063
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 8
1 0.00067 0.00067 0.00067
SELECT c.*, IF (c.location_id != 720, 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 = 40 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
1 0.01313 0.01313 0.01313
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 12
1 0.00059 0.00059 0.00059
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 720
1 0.00056 0.00056 0.00056
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 = 'fa' WHERE l.layout_id = 40  AND l.dispatch = 'pages.view' AND (FIND_IN_SET(75, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00146 0.00146 0.00146
SELECT * FROM cscart_se_settings
1 0.00062 0.00062 0.00062
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
1 0.00052 0.00052 0.00052
SELECT cscart_tags.tag_id, cscart_tag_links.object_id, cscart_tag_links.object_type, cscart_tags.tag, cscart_tags.status, COUNT(cscart_tag_links.tag_id) as popularity FROM cscart_tags LEFT JOIN cscart_tag_links ON cscart_tag_links.tag_id = cscart_tags.tag_id WHERE 1  AND cscart_tags.company_id = 6 AND cscart_tag_links.object_type = 'A' AND cscart_tags.status IN ('A') AND cscart_tag_links.object_id = 75 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 
1 0.00066 0.00066 0.00066
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 75
1 0.00057 0.00057 0.00057
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
1 0.00059 0.00059 0.00059
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
1 0.00064 0.00064 0.00064
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 720
1 0.00248 0.00248 0.00248
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 = 'fa' 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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 75 AND cscart_page_descriptions.lang_code = 'fa'  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.00121 0.00121 0.00121
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
1 0.00067 0.00067 0.00067

                SELECT c.company_id, c.storefront, c.email, l.name, l.lang_code
                FROM cscart_languages as l
                INNER JOIN cscart_ult_objects_sharing as s ON (s.share_object_id = l.lang_id AND s.share_object_type = 'languages')
                LEFT JOIN cscart_companies as c ON c.company_id = s.share_company_id WHERE c.status = 'A' AND l.status = 'A' ORDER BY l.lang_code = 'fa' DESC
1 0.00099 0.00099 0.00099
SELECT * FROM cscart_mobile_admin_app_settings
1 0.00061 0.00061 0.00061
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.00105 0.00105 0.00105
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.00066 0.00066 0.00066
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects  WHERE 1  AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 291 ORDER BY cscart_settings_objects.position
1 0.00063 0.00063 0.00063
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.00075 0.00075 0.00075
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.00063 0.00063 0.00063
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?shop.daewoo.ir'
1 0.00058 0.00058 0.00058
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 6
1 0.00050 0.00050 0.00050
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (6) AND status IN ('A', 'P', 'N')
1 0.00054 0.00054 0.00054
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
1 0.00049 0.00049 0.00049
SELECT entry_page FROM cscart_companies WHERE company_id = 6 AND redirect_customer != 'Y'
1 0.00049 0.00049 0.00049
SET time_zone = '+04:30'
1 0.00046 0.00046 0.00046
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'A'
1 0.00064 0.00064 0.00064
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
1 0.00053 0.00053 0.00053
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'C'
1 0.00055 0.00055 0.00055
SELECT type FROM cscart_seo_names WHERE name = 'supporter'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0)
1 0.00094 0.00094 0.00094
SELECT * FROM cscart_seo_names WHERE name = 'supporter'  AND lang_code = 'fa'
1 0.00088 0.00088 0.00088
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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A' 
1 0.00067 0.00067 0.00067
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.00066 0.00066 0.00066
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 = 6  WHERE 1  AND section_id = '47' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
1 0.00094 0.00094 0.00094
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 75 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'fa' 
1 0.00078 0.00078 0.00078
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 = 'fa' 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 = 6 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1  AND status IN ('A', 'H') ORDER BY a.position
1 0.00087 0.00087 0.00087
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 6 
1 0.00060 0.00060 0.00060
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
1 0.00049 0.00049 0.00049
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
1 0.00067 0.00067 0.00067
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 1247  AND cscart_discussion.company_id = 6
1 0.00055 0.00055 0.00055