Queries total time: 0.07885 s.
Query Time
1
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
0.00080
2
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
0.00066
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.00067
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.00059
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.00068
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.00061
8
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?shop.daewoo.ir'
0.00064
9
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 6
0.00054
10
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (6) AND status IN ('A', 'P', 'N')
0.00061
11
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
0.00051
12
SELECT entry_page FROM cscart_companies WHERE company_id = 6 AND redirect_customer != 'Y'
0.00048
13
SET time_zone = '+04:30'
0.00042
14
SELECT * FROM cscart_mobile_admin_app_settings
0.00059
15
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'A'
0.00060
16
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'C'
0.00062
17
SELECT type FROM cscart_seo_names WHERE name = 'freeshipping'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0)
0.00078
18
SELECT * FROM cscart_seo_names WHERE name = 'freeshipping'  AND lang_code = 'fa'
0.00080
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.00063
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.00068
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.00096
22
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 74 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'fa' 
0.00071
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.00065
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.00081
25
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 6 
0.00065
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.00075
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.00070
28
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00065
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.00063
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.00072
31
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
0.00052
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.00073
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.00116
34
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
0.00049
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.00094
36
SELECT * FROM cscart_se_settings
0.00060
37
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 5
0.00058
38
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 8
0.00061
39
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 6
0.00055
40
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 12
0.00055
41
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 1
0.00053
42
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 7
0.00058
43
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 13
0.00055
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 = 74 
0.00060
45
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
0.00055
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(74, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
0.00136
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 = 74 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.00115
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.00066
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.00065
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.00150
52
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
0.00051
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.00064
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.00067
55
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00062
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.00070
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.00109
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.00066
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.00062
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.00072
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.00108
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.00064
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.00150
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.00071
67
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00061
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.00071
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.00109
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 = 74 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 
0.00060
71
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 74
0.00052
72
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
0.00052
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.00063
74
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
0.00055
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 = 74 
0.00056
76
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
0.00054
77
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 720
0.00242
78
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 720
0.00061
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.01301
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.00156
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 = 74 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.00553
82
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 74 AND object_type = 'A'  AND cscart_discussion.company_id = 6  
0.00074
83
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 1252  AND cscart_discussion.company_id = 6
0.00056

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.00063 0.00075 0.00067
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.00067 0.00072 0.00070
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.00070 0.00073 0.00071
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.00065 0.00063
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.00108 0.00116 0.00111
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.00150 0.00151 0.00150
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.00064 0.00066 0.00065
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 = 74 
2 0.00056 0.00060 0.00058
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.00063 0.00065 0.00064
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
2 0.00054 0.00055 0.00054
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 7
1 0.00058 0.00058 0.00058
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 5
1 0.00058 0.00058 0.00058
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 8
1 0.00061 0.00061 0.00061
SELECT thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 74 AND object_type = 'A'  AND cscart_discussion.company_id = 6  
1 0.00074 0.00074 0.00074
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 = 74 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.00553 0.00553 0.00553
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.00156 0.00156 0.00156
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 6
1 0.00055 0.00055 0.00055
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 12
1 0.00055 0.00055 0.00055
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 1
1 0.00053 0.00053 0.00053
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.01301 0.01301 0.01301
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 13
1 0.00055 0.00055 0.00055
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 720
1 0.00061 0.00061 0.00061
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(74, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00136 0.00136 0.00136
SELECT * FROM cscart_se_settings
1 0.00060 0.00060 0.00060
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
1 0.00051 0.00051 0.00051
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 = 74 GROUP BY cscart_tags.tag_id  ORDER BY cscart_tags.tag asc 
1 0.00060 0.00060 0.00060
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 74
1 0.00052 0.00052 0.00052
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
1 0.00052 0.00052 0.00052
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
1 0.00055 0.00055 0.00055
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 720
1 0.00242 0.00242 0.00242
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 = 74 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.00115 0.00115 0.00115
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
1 0.00080 0.00080 0.00080

                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.00094 0.00094 0.00094
SELECT * FROM cscart_mobile_admin_app_settings
1 0.00059 0.00059 0.00059
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.00067 0.00067 0.00067
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.00059 0.00059 0.00059
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.00068 0.00068 0.00068
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.00061 0.00061 0.00061
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?shop.daewoo.ir'
1 0.00064 0.00064 0.00064
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 6
1 0.00054 0.00054 0.00054
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (6) AND status IN ('A', 'P', 'N')
1 0.00061 0.00061 0.00061
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
1 0.00051 0.00051 0.00051
SELECT entry_page FROM cscart_companies WHERE company_id = 6 AND redirect_customer != 'Y'
1 0.00048 0.00048 0.00048
SET time_zone = '+04:30'
1 0.00042 0.00042 0.00042
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'A'
1 0.00060 0.00060 0.00060
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
1 0.00049 0.00049 0.00049
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'C'
1 0.00062 0.00062 0.00062
SELECT type FROM cscart_seo_names WHERE name = 'freeshipping'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0)
1 0.00078 0.00078 0.00078
SELECT * FROM cscart_seo_names WHERE name = 'freeshipping'  AND lang_code = 'fa'
1 0.00080 0.00080 0.00080
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.00063 0.00063 0.00063
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.00068 0.00068 0.00068
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.00096 0.00096 0.00096
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 74 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'fa' 
1 0.00071 0.00071 0.00071
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.00081 0.00081 0.00081
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 6 
1 0.00065 0.00065 0.00065
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
1 0.00052 0.00052 0.00052
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
1 0.00066 0.00066 0.00066
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 1252  AND cscart_discussion.company_id = 6
1 0.00056 0.00056 0.00056