Queries total time: 0.23151 s.
Query Time
1
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
0.00075
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.00128
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.00069
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.00068
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.00062
9
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 6
0.00052
10
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (6) AND status IN ('A', 'P', 'N')
0.00070
11
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
0.00058
12
SELECT entry_page FROM cscart_companies WHERE company_id = 6 AND redirect_customer != 'Y'
0.00056
13
SET time_zone = '+04:30'
0.00039
14
SELECT * FROM cscart_mobile_admin_app_settings
0.00056
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.00057
17
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.00142
18
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.00084
19
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 6 
0.00065
20
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.00062
21
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.00069
22
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
0.00062
23
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
24
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
25
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
0.00053
26
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.00082
27
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.00117
28
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
0.00049
29
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
30
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.00093
31

                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.00102
32
SELECT * FROM cscart_se_settings
0.00061
33
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 1
0.00062
34
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 7
0.00055
35
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 13
0.00057
36
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 5
0.00068
37
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 8
0.00057
38
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 6
0.00055
39
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 12
0.00055
40
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
0.00055
41
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 = 'index.index'  ORDER BY l.object_ids desc  LIMIT 1
0.00149
42
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
0.00056
43
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
44
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
0.00063
45
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
0.00061
46
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 711
0.00246
47
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 711
0.00055
48
SELECT c.*, IF (c.location_id != 711, 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.01280
49
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, 2843, 2844) ORDER BY g.order, g.parent_id, g.grid_id ASC
0.00177
50
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 '' 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 = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (3624, 3625, 3626, 3627, 3630, 3629, 3628, 3645, 3646, 3650, 3654, 3656, 3658, 3660, 3762, 3763, 3647, 3652, 3764, 3765, 3648, 3761, 6971, 7025, 3766, 6972, 6973, 3651, 6974, 3649, 3653, 3655, 3657, 3659, 3661, 3662, 3663, 3664, 7003, 7002, 7004, 7005, 7008, 7007, 7006, 7001, 6998, 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.00718
51
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, SUM(cscart_product_sales.amount) as sales_amount, 1 as instock_marker, IF(IF(products.tracking = 'O', (SELECT MAX(amount) FROM cscart_product_options_inventory s_inventory WHERE s_inventory.product_id = products.product_id) > 0, products.amount > 0), 1, IF(products.tracking = 'D', 1, 0)) as instock_sorting FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'fa'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 6 AND shared_descr.lang_code = 'fa' INNER JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id  WHERE 1  AND cscart_categories.company_id = 6 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND cscart_product_sales.amount >= 1 GROUP BY cscart_product_sales.product_id   ORDER BY instock_sorting DESC, sales_amount desc, product_id ASC  LIMIT 0, 20
0.00950
52
SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  
0.00112
53
SELECT cscart_product_prices.product_id, MIN(IF(cscart_product_prices.percentage_discount = 0,cscart_product_prices.price,cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) AS price FROM cscart_product_prices  WHERE cscart_product_prices.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id
0.00095
54
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.meta_keywords, cscart_product_descriptions.meta_description, cscart_product_descriptions.search_words, cscart_product_descriptions.promo_text FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_product_descriptions.lang_code = 'fa' 
0.00130
55
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.company_id = 6 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')  WHERE cscart_products_categories.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)   GROUP BY cscart_products_categories.product_id
0.00130
56
SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'fa'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0) 
0.00114
57
SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion  LEFT JOIN cscart_discussion_posts   ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating   ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id   AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id   AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_discussion.object_type = "P" AND cscart_discussion.company_id = 6 GROUP BY cscart_discussion.object_id
0.00102
58
SELECT cscart_ult_product_descriptions.product_id, cscart_ult_product_descriptions.short_description, IF(cscart_ult_product_descriptions.short_description = "", cscart_ult_product_descriptions.full_description, "") AS full_description, cscart_ult_product_descriptions.meta_keywords, cscart_ult_product_descriptions.meta_description, cscart_ult_product_descriptions.search_words, cscart_ult_product_descriptions.promo_text FROM cscart_ult_product_descriptions  WHERE cscart_ult_product_descriptions.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) AND cscart_ult_product_descriptions.company_id = 6 AND cscart_ult_product_descriptions.lang_code = 'fa' 
0.00163
59
SELECT cscart_ult_product_prices.product_id, MIN(IF(cscart_ult_product_prices.percentage_discount = 0,cscart_ult_product_prices.price,cscart_ult_product_prices.price - (cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount)/100)) AS price FROM cscart_ult_product_prices  WHERE cscart_ult_product_prices.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_ult_product_prices.lower_limit = 1 AND cscart_ult_product_prices.company_id = 6 AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1)  GROUP BY cscart_ult_product_prices.product_id
0.00100
60
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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00166
61
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00185
62
SELECT a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa'  WHERE a.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) AND status = 'A' ORDER BY a.position
0.00090
63
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
0.00119
64
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'fa' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_promotions.promotion_id AND cscart_ult_objects_sharing.share_company_id = 6 AND cscart_ult_objects_sharing.share_object_type = 'promotions') WHERE 1  AND IF(from_date, from_date <= 1566288310, 1) AND IF(to_date, to_date >= 1566288310, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc 
0.07834
65
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2919 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00111
66
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2919 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00110
67
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 211 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'fa'  AND cscart_seo_names.company_id IN (0, 6)
0.00072
68
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2880 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00094
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.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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2880 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00093
70
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 200 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'fa'  AND cscart_seo_names.company_id IN (0, 6)
0.00073
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2878 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00094
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2878 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00097
73
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2851 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00089
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.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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2851 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00081
75
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2881 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00089
76
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2881 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00087
77
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2883 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00095
78
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2883 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00103
79
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2936 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00115
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2936 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00115
81
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2920 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00101
82
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2920 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00102
83
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 203 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'fa'  AND cscart_seo_names.company_id IN (0, 6)
0.00072
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2884 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00096
85
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2884 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00103
86
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2931 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00101
87
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2931 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00107
88
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2955 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00095
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2955 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00102
90
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, 1 as instock_marker, IF(IF(products.tracking = 'O', (SELECT MAX(amount) FROM cscart_product_options_inventory s_inventory WHERE s_inventory.product_id = products.product_id) > 0, products.amount > 0), 1, IF(products.tracking = 'D', 1, 0)) as instock_sorting FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'fa'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 6 AND shared_descr.lang_code = 'fa' WHERE 1  AND cscart_categories.company_id = 6 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id   ORDER BY instock_sorting DESC, products.timestamp desc, product_id ASC  LIMIT 0, 20
0.00877
91
SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  
0.00108
92
SELECT cscart_product_prices.product_id, MIN(IF(cscart_product_prices.percentage_discount = 0,cscart_product_prices.price,cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) AS price FROM cscart_product_prices  WHERE cscart_product_prices.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id
0.00096
93
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.meta_keywords, cscart_product_descriptions.meta_description, cscart_product_descriptions.search_words, cscart_product_descriptions.promo_text FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_product_descriptions.lang_code = 'fa' 
0.00127
94
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.company_id = 6 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')  WHERE cscart_products_categories.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)   GROUP BY cscart_products_categories.product_id
0.00138
95
SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'fa'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0) 
0.00119
96
SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion  LEFT JOIN cscart_discussion_posts   ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating   ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id   AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id   AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_discussion.object_type = "P" AND cscart_discussion.company_id = 6 GROUP BY cscart_discussion.object_id
0.00106
97
SELECT cscart_ult_product_descriptions.product_id, cscart_ult_product_descriptions.short_description, IF(cscart_ult_product_descriptions.short_description = "", cscart_ult_product_descriptions.full_description, "") AS full_description, cscart_ult_product_descriptions.meta_keywords, cscart_ult_product_descriptions.meta_description, cscart_ult_product_descriptions.search_words, cscart_ult_product_descriptions.promo_text FROM cscart_ult_product_descriptions  WHERE cscart_ult_product_descriptions.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) AND cscart_ult_product_descriptions.company_id = 6 AND cscart_ult_product_descriptions.lang_code = 'fa' 
0.00179
98
SELECT cscart_ult_product_prices.product_id, MIN(IF(cscart_ult_product_prices.percentage_discount = 0,cscart_ult_product_prices.price,cscart_ult_product_prices.price - (cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount)/100)) AS price FROM cscart_ult_product_prices  WHERE cscart_ult_product_prices.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_ult_product_prices.lower_limit = 1 AND cscart_ult_product_prices.company_id = 6 AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1)  GROUP BY cscart_ult_product_prices.product_id
0.00103
99
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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00171
100
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00188
101
SELECT a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa'  WHERE a.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) AND status = 'A' ORDER BY a.position
0.00088
102
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
0.00071
103
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2955 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00089
104
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2955 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00100
105
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2936 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00110
106
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2936 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00115
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2931 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00096
108
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2931 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00101
109
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2920 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00091
110
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2920 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00102
111
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2919 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00102
112
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2919 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00107
113
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2906 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00093
114
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2906 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00100
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2902 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00095
116
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2902 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00094
117
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2884 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00091
118
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2884 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00101
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2883 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00090
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2883 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00099
121
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2881 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00089
122
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2881 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00091
123
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2880 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00090
124
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2880 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00086
125
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2878 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00085
126
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2878 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00088
127
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2851 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00084
128
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2851 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
0.00079

Warning Some queries are being executed multiple times

Queries max count: 2
Query Count Min time Max time Average time
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2884 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00091 0.00096 0.00094
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2851 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00079 0.00081 0.00080
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2936 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00115 0.00115 0.00115
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2920 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00091 0.00101 0.00096
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2920 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00102 0.00102 0.00102
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2883 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00090 0.00095 0.00093
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2881 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00087 0.00091 0.00089
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2884 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00101 0.00103 0.00102
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2931 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00096 0.00101 0.00099
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2931 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00101 0.00107 0.00104
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2955 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00089 0.00095 0.00092
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2955 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00100 0.00102 0.00101
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
2 0.00067 0.00069 0.00068
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'theme_name' 
2 0.00062 0.00063 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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2881 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00089 0.00089 0.00089
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.00142 0.00105
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2883 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00099 0.00103 0.00101
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND layout_id = 40
2 0.00055 0.00061 0.00058
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2851 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00084 0.00089 0.00087
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2878 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00088 0.00097 0.00093
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2878 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00085 0.00094 0.00090
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2880 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00086 0.00093 0.00090
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2880 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00090 0.00094 0.00092
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2919 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00107 0.00110 0.00108
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2919 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00102 0.00111 0.00106
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2936 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
2 0.00110 0.00115 0.00112
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 200 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'fa'  AND cscart_seo_names.company_id IN (0, 6)
1 0.00073 0.00073 0.00073
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 211 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'fa'  AND cscart_seo_names.company_id IN (0, 6)
1 0.00072 0.00072 0.00072
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'fa' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_promotions.promotion_id AND cscart_ult_objects_sharing.share_company_id = 6 AND cscart_ult_objects_sharing.share_object_type = 'promotions') WHERE 1  AND IF(from_date, from_date <= 1566288310, 1) AND IF(to_date, to_date >= 1566288310, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' ORDER BY cscart_promotions.priority asc 
1 0.07834 0.07834 0.07834
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
1 0.00119 0.00119 0.00119
SELECT a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa'  WHERE a.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) AND status = 'A' ORDER BY a.position
1 0.00090 0.00090 0.00090
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00185 0.00185 0.00185
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
1 0.00075 0.00075 0.00075
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 203 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'fa'  AND cscart_seo_names.company_id IN (0, 6)
1 0.00072 0.00072 0.00072
SELECT cscart_ult_product_prices.product_id, MIN(IF(cscart_ult_product_prices.percentage_discount = 0,cscart_ult_product_prices.price,cscart_ult_product_prices.price - (cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount)/100)) AS price FROM cscart_ult_product_prices  WHERE cscart_ult_product_prices.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_ult_product_prices.lower_limit = 1 AND cscart_ult_product_prices.company_id = 6 AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1)  GROUP BY cscart_ult_product_prices.product_id
1 0.00103 0.00103 0.00103
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2902 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00095 0.00095 0.00095
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2906 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00100 0.00100 0.00100
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2906 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00093 0.00093 0.00093
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) AND a.product_id = 0 AND status = 'A' ORDER BY a.position
1 0.00071 0.00071 0.00071
SELECT a.*, b.option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'fa'  WHERE a.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) AND status = 'A' ORDER BY a.position
1 0.00088 0.00088 0.00088
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00188 0.00188 0.00188
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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00171 0.00171 0.00171
SELECT cscart_ult_product_descriptions.product_id, cscart_ult_product_descriptions.short_description, IF(cscart_ult_product_descriptions.short_description = "", cscart_ult_product_descriptions.full_description, "") AS full_description, cscart_ult_product_descriptions.meta_keywords, cscart_ult_product_descriptions.meta_description, cscart_ult_product_descriptions.search_words, cscart_ult_product_descriptions.promo_text FROM cscart_ult_product_descriptions  WHERE cscart_ult_product_descriptions.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851) AND cscart_ult_product_descriptions.company_id = 6 AND cscart_ult_product_descriptions.lang_code = 'fa' 
1 0.00179 0.00179 0.00179
SELECT cscart_ult_product_prices.product_id, MIN(IF(cscart_ult_product_prices.percentage_discount = 0,cscart_ult_product_prices.price,cscart_ult_product_prices.price - (cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount)/100)) AS price FROM cscart_ult_product_prices  WHERE cscart_ult_product_prices.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_ult_product_prices.lower_limit = 1 AND cscart_ult_product_prices.company_id = 6 AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1)  GROUP BY cscart_ult_product_prices.product_id
1 0.00100 0.00100 0.00100
SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion  LEFT JOIN cscart_discussion_posts   ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating   ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id   AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id   AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_discussion.object_type = "P" AND cscart_discussion.company_id = 6 GROUP BY cscart_discussion.object_id
1 0.00106 0.00106 0.00106
SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'fa'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0) 
1 0.00119 0.00119 0.00119
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.company_id = 6 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')  WHERE cscart_products_categories.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)   GROUP BY cscart_products_categories.product_id
1 0.00138 0.00138 0.00138
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.meta_keywords, cscart_product_descriptions.meta_description, cscart_product_descriptions.search_words, cscart_product_descriptions.promo_text FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_product_descriptions.lang_code = 'fa' 
1 0.00127 0.00127 0.00127
SELECT cscart_product_prices.product_id, MIN(IF(cscart_product_prices.percentage_discount = 0,cscart_product_prices.price,cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) AS price FROM cscart_product_prices  WHERE cscart_product_prices.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id
1 0.00096 0.00096 0.00096
SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (2955, 2936, 2931, 2920, 2919, 2906, 2902, 2884, 2883, 2881, 2880, 2878, 2851)  
1 0.00108 0.00108 0.00108
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, 1 as instock_marker, IF(IF(products.tracking = 'O', (SELECT MAX(amount) FROM cscart_product_options_inventory s_inventory WHERE s_inventory.product_id = products.product_id) > 0, products.amount > 0), 1, IF(products.tracking = 'D', 1, 0)) as instock_sorting FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'fa'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 6 AND shared_descr.lang_code = 'fa' WHERE 1  AND cscart_categories.company_id = 6 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id   ORDER BY instock_sorting DESC, products.timestamp desc, product_id ASC  LIMIT 0, 20
1 0.00877 0.00877 0.00877
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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00166 0.00166 0.00166
SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'fa'  AND ( cscart_seo_names.company_id = 6 OR cscart_seo_names.company_id = 0) 
1 0.00114 0.00114 0.00114
SELECT cscart_ult_product_descriptions.product_id, cscart_ult_product_descriptions.short_description, IF(cscart_ult_product_descriptions.short_description = "", cscart_ult_product_descriptions.full_description, "") AS full_description, cscart_ult_product_descriptions.meta_keywords, cscart_ult_product_descriptions.meta_description, cscart_ult_product_descriptions.search_words, cscart_ult_product_descriptions.promo_text FROM cscart_ult_product_descriptions  WHERE cscart_ult_product_descriptions.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955) AND cscart_ult_product_descriptions.company_id = 6 AND cscart_ult_product_descriptions.lang_code = 'fa' 
1 0.00163 0.00163 0.00163
SELECT * FROM cscart_mobile_admin_app_settings
1 0.00056 0.00056 0.00056
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
1 0.00049 0.00049 0.00049
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
1 0.00117 0.00117 0.00117
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
1 0.00082 0.00082 0.00082
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
1 0.00053 0.00053 0.00053
SELECT * FROM cscart_bm_layouts WHERE 1  AND cscart_bm_layouts.company_id = 6 AND is_default = 1 AND theme_name = 'coolbaby'
1 0.00062 0.00062 0.00062
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 6 
1 0.00065 0.00065 0.00065
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.00084 0.00084 0.00084
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'C'
1 0.00057 0.00057 0.00057
SELECT * FROM cscart_mobile_admin_app_stores WHERE type = 'A'
1 0.00060 0.00060 0.00060
SET time_zone = '+04:30'
1 0.00039 0.00039 0.00039
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.00093 0.00093 0.00093
SELECT entry_page FROM cscart_companies WHERE company_id = 6 AND redirect_customer != 'Y'
1 0.00056 0.00056 0.00056
SELECT company_id FROM cscart_companies WHERE 1  AND status IN ('A', 'P', 'N')
1 0.00058 0.00058 0.00058
SELECT company_id FROM cscart_companies WHERE 1  AND company_id IN (6) AND status IN ('A', 'P', 'N')
1 0.00070 0.00070 0.00070
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 6
1 0.00052 0.00052 0.00052
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?shop.daewoo.ir'
1 0.00062 0.00062 0.00062
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 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 = 291 ORDER BY cscart_settings_objects.position
1 0.00068 0.00068 0.00068
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.00069 0.00069 0.00069
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.00128 0.00128 0.00128
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 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.00102 0.00102 0.00102
SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion  LEFT JOIN cscart_discussion_posts   ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating   ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id   AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id   AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_discussion.object_type = "P" AND cscart_discussion.company_id = 6 GROUP BY cscart_discussion.object_id
1 0.00102 0.00102 0.00102
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 711
1 0.00055 0.00055 0.00055
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
1 0.00067 0.00067 0.00067
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.company_id = 6 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')  WHERE cscart_products_categories.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)   GROUP BY cscart_products_categories.product_id
1 0.00130 0.00130 0.00130
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.meta_keywords, cscart_product_descriptions.meta_description, cscart_product_descriptions.search_words, cscart_product_descriptions.promo_text FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_product_descriptions.lang_code = 'fa' 
1 0.00130 0.00130 0.00130
SELECT cscart_product_prices.product_id, MIN(IF(cscart_product_prices.percentage_discount = 0,cscart_product_prices.price,cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) AS price FROM cscart_product_prices  WHERE cscart_product_prices.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id
1 0.00095 0.00095 0.00095
SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (2919, 2880, 2878, 2851, 2881, 2883, 2936, 2920, 2884, 2931, 2955)  
1 0.00112 0.00112 0.00112
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, SUM(cscart_product_sales.amount) as sales_amount, 1 as instock_marker, IF(IF(products.tracking = 'O', (SELECT MAX(amount) FROM cscart_product_options_inventory s_inventory WHERE s_inventory.product_id = products.product_id) > 0, products.amount > 0), 1, IF(products.tracking = 'D', 1, 0)) as instock_sorting FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'fa'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 6 AND shared_descr.lang_code = 'fa' INNER JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id  WHERE 1  AND cscart_categories.company_id = 6 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND cscart_product_sales.amount >= 1 GROUP BY cscart_product_sales.product_id   ORDER BY instock_sorting DESC, sales_amount desc, product_id ASC  LIMIT 0, 20
1 0.00950 0.00950 0.00950
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 '' 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 = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (3624, 3625, 3626, 3627, 3630, 3629, 3628, 3645, 3646, 3650, 3654, 3656, 3658, 3660, 3762, 3763, 3647, 3652, 3764, 3765, 3648, 3761, 6971, 7025, 3766, 6972, 6973, 3651, 6974, 3649, 3653, 3655, 3657, 3659, 3661, 3662, 3663, 3664, 7003, 7002, 7004, 7005, 7008, 7007, 7006, 7001, 6998, 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.00718 0.00718 0.00718
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, 2843, 2844) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00177 0.00177 0.00177
SELECT c.*, IF (c.location_id != 711, 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.01280 0.01280 0.01280
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 711
1 0.00246 0.00246 0.00246
SELECT * FROM cscart_se_settings
1 0.00061 0.00061 0.00061
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
1 0.00063 0.00063 0.00063
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
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 = 'index.index'  ORDER BY l.object_ids desc  LIMIT 1
1 0.00149 0.00149 0.00149
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 = 6
1 0.00055 0.00055 0.00055
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 8
1 0.00057 0.00057 0.00057
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 5
1 0.00068 0.00068 0.00068
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 13
1 0.00057 0.00057 0.00057
SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 7
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.00062 0.00062 0.00062
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 = 'fa' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 2902 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00094 0.00094 0.00094