Dual USB car charger (Auto & Travel Accessories)

1. SELECT SQL_CALC_FOUND_ROWS * FROM store_master WHERE store_status = '1' AND (store_name = 'shop' OR store_url = 'shop.allbizsupplies.biz' OR store_url = '.allbizsupplies.biz') 0.0004 sec

2. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('ENABLE_SSL') AND store_id = 128 0.0002 sec

3. SELECT countries_name FROM countries WHERE countries_id = 13 0.0002 sec

4. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_FLAT_MARKUP', 'STORE_DEFAULT_ADMIN_TEMPLATES', 'STORE_PAYMENT_METHOD', 'STORE_CURRENCY', 'STORE_LANGUAGE', 'STORE_THEME_SETTINGS', 'STORE_CORPORATE_THEME_SETTINGS', 'STORE_BANNER_IMAGE_SETTINGS', 'STORE_ALLOW_PAYON_ACCOUNT', 'ENABLE_AUTO_MAIL_REMINDER', 'ENABLE_ADMIN_NOTIFICATION', 'STORE_ALLOW_LIVE_CHAT', 'STORE_LIVE_CHAT', 'STORE_ALLOW_PAYON_ACCOUNT_TYPE', 'STORE_PRODUCT_SELL_NOTIFICATION', 'STORE_ENABLE_STAFF_MANAGEMENT_MODULE', 'ADVANCE_CORPORATE_MODULE', 'STORE_ENABLE_M2_CALCULATOR_MODULE', 'STORE_ALLOW_PRINT_PDF_PREVIEW', 'PREDEFINED_PRODUCTS_SETTING', 'STORE_PRODUCTS_SIDEBAR_CONFIGURATION', 'STORE_EXTERNAL_SERVICE_METHOD', 'STORE_LETTERBOX_DISTRIBUTION', 'ENABLE_SSL', 'STORE_PRICE_CALC_WITH_TAX', 'ENABLE_AUTO_CALCULATION', 'ENABLE_AUTO_MAIL_REMINDER', 'STORE_STANDARD_CUSTOM_SIZE_MODULE') AND store_id = 128 0.0004 sec

5. SELECT SQL_CALC_FOUND_ROWS directory_name, main_url, open_b2b, corporate_id, payon FROM corporate_user WHERE status = '1' AND (directory_name = 'shop' OR main_url = 'shop.allbizsupplies.biz') AND corporate_user.store_id = 128 0.0004 sec

6. SELECT section_id, status FROM admin_section WHERE section_id IN (SELECT section_id FROM admin_section_description where site_language_id = '1' AND LOWER(section_heading) = LOWER('Templates')) 0.0003 sec

7. SELECT configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type, configuration_master.*, (IF( (store_configuration_master.configuration_id IS NOT NULL AND store_configuration_master.configuration_id != '') , store_configuration_master.set_value , configuration_master.set_value )) AS set_value FROM configuration_master LEFT JOIN store_configuration_master ON store_configuration_master.constant_name = configuration_master.constant_name AND store_configuration_master.store_id= 128 ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.0046 sec

8. SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'butterfly' 0.0003 sec

9. SELECT payment_method_id FROM payment_method WHERE (directory= 'payon_account' OR directory= 'cheque' ) ORDER BY sort_order ASC 0.0002 sec

10. SELECT external_services.*, (IF( (store_external_services.service_details IS NOT NULL AND store_external_services.service_details != '') , store_external_services.service_details , external_services.service_details)) AS service_details , (IF( (store_external_services.status IS NOT NULL) , store_external_services.status , external_services.status)) AS status FROM external_services LEFT JOIN store_external_services ON store_external_services.service_id = external_services.service_id AND store_external_services.store_id= 128 WHERE external_services.status = '1' AND external_services.service_id IN (1, 2, 4, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19, 20, 23, 24, 25, 26) AND (store_external_services.status = '1' OR store_external_services.status IS NULL) 0.0004 sec

11. SELECT * FROM shipping_address_settings WHERE setting_name = 'addressautosearch' AND store_id = 128 0.0003 sec

12. SELECT * FROM shipping_address_settings WHERE setting_name = 'addressautosearch' 0.0002 sec

13. SELECT * FROM website_logos WHERE corporate_id = 0 AND store_id IN (128, 0) ORDER BY store_id DESC 0.0003 sec

14. SELECT * FROM site_language WHERE default_language = '1' 0.0003 sec

15. SELECT * FROM site_currency WHERE currency_id = '3' 0.0003 sec

16. SELECT products_description.product_url,products_description.products_id FROM products_description LEFT JOIN products ON products.products_id = products_description.products_id LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE product_url = 'dual-usb-car-charger' AND store_products.store_id = 128 0.0254 sec

17. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'COMMON_QUANTITY') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'COMMON_QUANTITY') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.006 sec

18. SELECT count(*) as active_langs FROM site_language where status = '1' 0.0004 sec

19. SELECT shortname, site_language_id FROM site_language 0.0002 sec

20. select TC.category_id, TCD.category_name from site_template_category as TC Left Join site_template_category_description AS TCD ON TCD.category_id = TC.category_id and TCD.site_language_id = '1' 0.0005 sec

21. SELECT product_category.category_id, product_category_description.category_url as caturl, product_category_description.description, product_category_description.site_language_id FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category.status = '1' 0.011 sec

22. select p.products_id,IF( spd.product_url IS NOT NULL AND spd.product_url!='', spd.product_url, pd.product_url ) AS producturl,pd.products_title as productname, pd.site_language_id from products as p Left Join products_description as pd on pd.products_id = p.products_id left join store_products sp ON sp.products_id = pd.products_id left join store_products_description as spd ON spd.store_products_id = sp.store_products_id AND spd.site_language_id = 1 WHERE sp.store_id = 128 AND pd.site_language_id = 1 0.0009 sec

23. SELECT * FROM payment_method WHERE directory = 'payon_account' AND payment_method_id IN (4, 5, 23) 0.0004 sec

24. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_ALLOW_PAYON_ACCOUNT') AND store_id = 128 0.0003 sec

25. SELECT * FROM product_info_layout WHERE product_info_layout.store_id IN (128, 0) ORDER BY layout_id ASC, store_id DESC 0.0004 sec

26. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_SKU_SETTING', 'STORE_PREDEFINEPRODUCT_CHECKOUT_SETTING', 'SITE_VAR_CPB_NOTIFY_ADMIN', 'SITE_VAR_CPB_NOTIFY_PRINTER', 'SITE_VAR_CPB_NOTIFY_BRANCH', 'STORE_DISPLAY_RELATED_PRODUCTS_CART', 'SITE_VAR_PRINTREADY_DOWNLOAD_MYACCOUNT', 'SITE_VAR_SHOW_MODIFY_ORDER_FOR_CORPORATE', 'SITE_VAR_CORPORATE_INVOICE_NUMBER') AND store_id = 128 0.0003 sec

27. SELECT site_seo_description.seo_page_title, site_seo_description.seo_page_keywords,site_seo_description.seo_page_description, site_seo_description.seo_page_title, site_seo_description.seo_page_keywords,site_seo_description.seo_page_description FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE site_seo_description.site_language_id = 1 AND (site_seo.store_id = 128 OR site_seo.store_id = 0) AND (site_seo.page_name = 'product_info.php' OR site_seo.page_name = 'product_info') ORDER BY site_seo.store_id desc 0.0005 sec

28. SELECT site_seo_description.seo_page_title, site_seo_description.seo_page_keywords,site_seo_description.seo_page_description FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE site_seo_description.site_language_id = 1 AND (site_seo.page_name = 'Default') AND (site_seo.store_id = 128 OR site_seo.store_id = 0) ORDER BY site_seo.store_id desc 0.0002 sec

29. SELECT products_description.seo_page_title, products_description.seo_page_keywords,products_description.seo_page_description, products_description.products_title,products_description.canonical_id, IF( store_products_description.seo_page_title IS NOT NULL AND store_products_description.seo_page_title!='' , store_products_description.seo_page_title , products_description.seo_page_title ) AS seo_page_title, IF( store_products_description.seo_page_keywords IS NOT NULL AND store_products_description.seo_page_keywords!='' , store_products_description.seo_page_keywords , products_description.seo_page_keywords ) AS seo_page_keywords ,IF( store_products_description.seo_page_description IS NOT NULL AND store_products_description.seo_page_description!='' , store_products_description.seo_page_description , products_description.seo_page_description ) AS seo_page_description , IF(store_products_description.products_title IS NOT NULL AND store_products_description.products_title!='',store_products_description.products_title,products_description.products_title) AS products_title FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN store_products ON store_products.products_id = products.products_id LEFT JOIN store_products_description ON store_products.store_products_id = store_products_description.store_products_id AND products_description.site_language_id = store_products_description.site_language_id WHERE store_products_description.site_language_id = 1 AND products_description.site_language_id = 1 AND products.products_id = 8624 AND store_products.store_id = 128 0.0014 sec

30. SELECT * FROM (SELECT site_general_metatag.name, site_general_metatag.content,site_general_metatag.store_id, site_general_metatag.page_id FROM site_general_metatag
LEFT JOIN site_front_pages on site_front_pages.front_pages_id = site_general_metatag.page_id AND site_front_pages.seo_status = '1'
WHERE 1 AND ((site_front_pages.front_pages_name = 'product_info.php' OR site_front_pages.front_pages_name = 'product_info') OR (site_general_metatag.page_id = 0)) AND site_general_metatag.store_id IN (0, 128) ) AS temp_table GROUP BY name ORDER BY store_id desc 0.0006 sec

31. SELECT configuration_master.*, (IF( (store_configuration_master.configuration_id IS NOT NULL AND store_configuration_master.configuration_id != '') , store_configuration_master.set_value , configuration_master.set_value )) AS set_value FROM configuration_master LEFT JOIN store_configuration_master ON store_configuration_master.constant_name = configuration_master.constant_name AND store_configuration_master.store_id= 128 WHERE configuration_master.constant_name = 'CUSTOM_METATAG' 0.0004 sec

32. SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'product_info' 0.0003 sec

33. SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants_description.constant_id, Concat(site_constants_description.constant_id, IF(site_constants_description.corporate_id = -1, 11, IF(site_constants_description.store_id = 128, 10, 01))) AS corporateid FROM site_constants LEFT JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 LEFT JOIN site_front_page_group ON site_constants.front_group_id = site_front_page_group.front_group_id WHERE 1 AND site_constants.front_group_id IN ('1', '3') AND site_constants.available_to IN ('0', '-2') AND site_constants_description.corporate_id = 0 GROUP BY corporateid ORDER BY corporateid DESC) AS site_constants_description GROUP BY site_constants_description.constant_id 0.0011 sec

34. SELECT * FROM (SELECT menu_link.*, menu_link_description.menu_title,menu_link_description.menu_image,menu_link_description.site_language_id FROM menu_link LEFT JOIN menu_link_description ON menu_link_description.menu_id = menu_link.menu_id WHERE menu_link_description.site_language_id = 1 AND menu_link.status = '1' AND store_id IN ('128', '0') AND menu_link.menu_id NOT IN (SELECT master_menu_id FROM menu_link WHERE menu_link.master_menu_id != 0 AND menu_link.store_id = 128) AND corporate_id = 0 AND (link_display = '2' OR link_display = '0') ) AS temp_table ORDER BY sort_order ASC 0.0006 sec

35. SELECT SQL_CALC_FOUND_ROWS * FROM store_master ORDER BY store_name ASC 0.0003 sec

36. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_ALLOW_DESIGNER_MODULE') AND store_id = 128 0.0002 sec

37. SELECT * FROM (SELECT * FROM sidebar_management WHERE store_id IN ('128', '0') AND (section_pages LIKE '%|product_info.php|%' OR section_name= 'Default') ORDER BY store_id DESC, corporate_id ASC, sidebar_id DESC ) AS temp_table WHERE 1 ORDER BY store_id DESC, corporate_id ASC, sidebar_id DESC 0.0004 sec

38. SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND ((corporate_id = 0 and store_id = 0 AND menu_title NOT IN ( SELECT menu_title FROM side_menu_link WHERE store_id = 128 and corporate_id = 0 GROUP BY menu_title)) OR (store_id = 128 and corporate_id = 0)) GROUP BY menu_title HAVING status = '1' AND menu_display IN ('0', '1') ORDER BY sortorder ASC, status ASC, menu_title ASC ) AS temp_table ORDER BY sortorder ASC 0.0005 sec

39. SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages_description.page_heading, cms_pages_description.page_content, cms_pages.corporate_id, cms_pages.status FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND cms_pages.page_name IN ('cms_header', 'cms_middle_footer', 'cms_footer', 'contact_us_box', 'sidebar_content_left', 'sidebar_content_right', 'related_product_section_help', 'cms_social_media_links', 'cms_header_content', 'product_info_extra_msg') AND (cms_pages.corporate_id = 0 OR cms_pages.corporate_id = 0) AND cms_pages.store_id IN (128, 0) ORDER BY cms_pages.corporate_id ASC, store_id DESC, cms_pages.store_id DESC, corporate_id DESC 0.0003 sec

40. SELECT * FROM url_redirection_manage WHERE (old_url = 'https://shop.allbizsupplies.biz/dual-usb-car-charger/' OR old_url = 'https://shop.allbizsupplies.biz/dual-usb-car-charger/' OR old_url = 'https://shop.allbizsupplies.biz/dual-usb-car-charger/') AND store_id = 128 ORDER BY url_redirection_id ASC 0.0006 sec

41. SELECT products.*, store_products.product_type, store_products.visible AS store_visible, store_products.display_product, store_products.corporate_id, store_products.user_type_id,store_products.department_id,store_products.csv_allow
, IF(store_products.sort_order IS NOT NULL , store_products.sort_order , products.sort_order ) AS sort_order , IF(products.visible = '1' AND store_products.visible = '1' , products.visible , 0 ) AS visible FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0011 sec

42. SELECT layout_name, is_mobile, sidebar_display, is_default, IF(FIND_IN_SET('8624',products_id)>0,'1','0') AS info_layout_order FROM product_info_layout WHERE (products_id LIKE '%,8624,%' OR is_default = '1') AND products_type = '0' AND product_info_layout.store_id IN (128, 0) ORDER BY info_layout_order ASC, store_id DESC 0.0029 sec

43 41. SELECT products.*, store_products.product_type, store_products.visible AS store_visible, store_products.display_product, store_products.corporate_id, store_products.user_type_id,store_products.department_id,store_products.csv_allow
, IF(store_products.sort_order IS NOT NULL , store_products.sort_order , products.sort_order ) AS sort_order , IF(products.visible = '1' AND store_products.visible = '1' , products.visible , 0 ) AS visible FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0006 sec

44. SELECT products.*, products_description.*, store_products.added_by, store_products_description.imagename as store_imagename, store_products_description.product_desc_image as store_product_desc_image, IF(store_products.category_id != 0,store_products.category_id,products.category_id) as category_id, store_products.product_type, store_products.visible AS store_visible, store_products.display_product, store_products.corporate_id, store_products.user_type_id,store_products.department_id,store_products.csv_allow
, IF(store_products.sort_order IS NOT NULL , store_products.sort_order , products.sort_order ) AS sort_order , IF(products.visible = '1' AND store_products.visible = '1' , products.visible , 0 ) AS visible , IF(store_products_description.products_title IS NOT NULL AND store_products_description.products_title!='',store_products_description.products_title,products_description.products_title) AS products_title
, IF(store_products_description.product_url IS NOT NULL AND store_products_description.product_url!='',store_products_description.product_url,products_description.product_url) AS product_url
, IF( store_products_description.imagename IS NOT NULL AND store_products_description.imagename!='' , store_products_description.imagename , products_description.imagename ) AS imagename
, IF( store_products_description.product_description IS NOT NULL AND store_products_description.product_description!='' , store_products_description.product_description , products_description.product_description ) AS product_description
, IF( store_products_description.long_description IS NOT NULL AND store_products_description.long_description!='' , store_products_description.long_description , products_description.long_description ) AS long_description
, IF( store_products_description.upload_description IS NOT NULL AND store_products_description.upload_description!='' , store_products_description.upload_description , products_description.upload_description ) AS upload_description
, IF( store_products_description.browse_description IS NOT NULL AND store_products_description.browse_description!='' , store_products_description.browse_description , products_description.browse_description ) AS browse_description
, IF( store_products_description.seo_page_title IS NOT NULL AND store_products_description.seo_page_title!='' , store_products_description.seo_page_title , products_description.seo_page_title ) AS seo_page_title
, IF( store_products_description.seo_page_keywords IS NOT NULL AND store_products_description.seo_page_keywords!='' , store_products_description.seo_page_keywords , products_description.seo_page_keywords ) AS seo_page_keywords
, IF( store_products_description.seo_page_description IS NOT NULL AND store_products_description.seo_page_description!='' , store_products_description.seo_page_description , products_description.seo_page_description ) AS seo_page_description
, IF( store_products_description.product_promotional_text IS NOT NULL AND store_products_description.product_promotional_text!='' , store_products_description.product_promotional_text , products_description.product_promotional_text ) AS product_promotional_text FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN store_products ON store_products.products_id = products.products_id LEFT JOIN store_products_description ON store_products.store_products_id = store_products_description.store_products_id AND products_description.site_language_id = store_products_description.site_language_id WHERE products.products_id = 8624 AND store_products_description.site_language_id = 1 AND products_description.site_language_id = 1 AND store_products.visible = 1 AND products.visible = 1 AND (store_products.user_type_id = '1' OR store_products.user_type_id = '0') AND store_products.store_id = 128 0.0021 sec

45. SELECT SQL_CALC_FOUND_ROWS DISTINCT category_name FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category.category_id = 2381 AND product_category_description.site_language_id = 1 AND product_category.parent_id != 0 0.0007 sec

46. SELECT * FROM products_sizes WHERE products_id = 8624 AND visible = '1' AND site_language_id = 1 0.0016 sec

47. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0044 sec

48. SELECT SQL_CALC_FOUND_ROWS products_id, added_by FROM store_products WHERE products_id = 8624 AND store_id = 128 0.0004 sec

49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.0026 sec

50 49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.0003 sec

51. SELECT pap.size_id, count(*),ps.default_size
FROM `products_additional_option` pao
LEFT JOIN `products_additional_option_attributes` paoa ON pao.prod_add_opt_id = paoa.prod_add_opt_id
LEFT JOIN products_attributes_price pap ON paoa.attribute_id = pap.attribute_id
LEFT JOIN products_sizes ps ON ps.size_id = pap.size_id
LEFT JOIN products_attributes_price_markup papm ON pap.attribute_price_id = papm.attribute_price_id
WHERE pao.`products_id` = 8624
AND pap.quantity IN (SELECT qty FROM product_price WHERE product_price.products_id = 8624 AND product_price.visible = 1)
AND `ibs_option_type` = 'C'
AND paoa.label_code IN ('37')
AND pap.size_id > 0
AND store_attributes_price > 0
AND papm.store_id = 128
AND ps.visible = '1'
group by pap.size_id, quantity having count(*) = (SELECT count(*)
FROM `products_additional_option` paoi
LEFT JOIN `products_additional_option_attributes` paoai ON paoi.prod_add_opt_id = paoai.prod_add_opt_id WHERE `products_id` = 8624
AND `ibs_option_type` = 'C'
AND paoai.label_code IN ('37') AND paoai.status = '1') ORDER BY ps.default_size 0.0068 sec

52. SELECT products.products_id, products_sizes.size_id, products_sizes.size_title, product_price.price, product_price.qty, product_price.qty_to, product_price.corporate_id, product_price.user_type_id, products.predefined_product_type, products.price_defining_method, products.enable_sheet_calculation, product_price.color_page_price, products.enable_color_pages, product_price.extra_page_price, products.kit_type_id, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page, product_price.price AS products_wholesale_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.store_price, (product_price.price + ((product_price.price * 0)/100))) as price,product_price.color_page_price AS products_wholesale_color_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.color_store_price, (product_price.color_page_price + ((product_price.color_page_price * 0)/100))) as color_page_price FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = '1' AND (`product_price`.`user_type_id` = '1') LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' LEFT JOIN product_price_markup ON product_price.product_price_id = product_price_markup.product_price_id AND product_price_markup.store_id = 128 RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = 1 AND `products_sizes`.`visible`='1' AND products_sizes.size_id IN (28769,28769,28769,28769,28769,28768,28768,28768,28768,28768) LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE `products`.`products_id` IN (8624) AND IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty_to` != 0, 1) AND products.predefined_product_type IN ('0') AND store_products.store_id = 128 GROUP BY products_sizes.size_id, product_price.qty, product_price.qty_to, product_price.corporate_id, product_price.user_type_id ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 0.0037 sec

53. SELECT enable_sheet_calculation,price_defining_method FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0007 sec

54 53. SELECT enable_sheet_calculation,price_defining_method FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0002 sec

55. SELECT orders.customers_name,orders_feedback.* FROM orders_feedback LEFT JOIN orders ON orders.orders_id = orders_feedback.orders_id WHERE orders_feedback.products_type_id = 8624 AND orders_feedback.status like '1' AND orders.store_id = 128 0.0012 sec

56. SELECT product_template_type.*,product_template.duplicate_product_id,product_template.product_template_id,product_template.products_id, product_template.size_id,product_template.template_filename, product_template.status,product_template.sort_order,products_sizes.size_title,product_template_description.site_language_id,product_template_description.product_template_description, (SELECT GROUP_CONCAT(CONCAT(ptemp.products_id,'<>',ptemp.template_type_id,'<>',ptemp.template_filename,'<>',ptemp.product_template_id)) FROM product_template AS ptemp WHERE FIND_IN_SET ( CONCAT ( product_template.products_id,'-',product_template.size_id ), ptemp.duplicate_product_id ) AND ptemp.template_type_id = product_template.template_type_id) AS duplicate_product_template FROM product_template_type LEFT JOIN product_template ON product_template.template_type_id = product_template_type.template_type_id LEFT JOIN product_template_description ON product_template.product_template_id = product_template_description.product_template_id INNER JOIN products_sizes on products_sizes.size_id = product_template.size_id WHERE (product_template.products_id = 8624 OR product_template.duplicate_product_id LIKE '%,8624-%') AND product_template_description.site_language_id = 1 AND products_sizes.site_language_id = 1 AND product_template. status = '1' GROUP BY product_template.product_template_id ORDER BY product_template.sort_order ASC 0.0392 sec

57. SELECT SQL_CALC_FOUND_ROWS IF(S.store_id IS NULL, M.products_image_gallery_id , S.products_image_gallery_id )as products_image_gallery_id,
IF(S.store_id IS NULL, M.products_id , S.products_id) as products_id,
IF(S.store_id IS NULL, M.attribute_id , S.attribute_id) as attribute_id,
IF(S.store_id IS NULL , M.title , S.title ) as title,
IF(S.store_id IS NULL , M.language , S.language ) as language,
IF(S.store_id IS NULL , M.products_thumb_image_name , S.products_thumb_image_name) as products_thumb_image_name,
IF(S.store_id IS NULL , M.products_large_image_name , S.products_large_image_name) as products_large_image_name,
IF(S.store_id IS NULL , M.sort_order , S.sort_order) as sort_order,
IF(S.store_id IS NULL , M.status , S.status) as status, IF(S.store_id IS NULL, M.type, S.type) as type,
IF(S.store_id IS NULL , M.store_id , S.store_id ) as store_id FROM products_image_gallery M
LEFT JOIN products_image_gallery S ON S.products_id = 8624 AND S.store_id= 128 AND S.type='P'
WHERE 1 AND M.store_id= 128 AND ((M.products_id = 8624 AND M.type='P') OR (M.products_id = 2381 AND M.type='C'))
AND ((M.language IN ('1', '0')) AND ( S.language IN ('1', '0') OR S.language IS NULL)) AND M.status = '1' AND (S.status='1' OR S.status IS NULL)
GROUP BY products_image_gallery_id ORDER BY S.sort_order,M.sort_order ASC 0.0012 sec

58. SELECT SQL_CALC_FOUND_ROWS IF(S.store_id IS NULL, M.products_image_gallery_id , S.products_image_gallery_id )as products_image_gallery_id,
IF(S.store_id IS NULL, M.products_id , S.products_id) as products_id,
IF(S.store_id IS NULL, M.attribute_id , S.attribute_id) as attribute_id,
IF(S.store_id IS NULL , M.title , S.title ) as title,
IF(S.store_id IS NULL , M.language , S.language ) as language,
IF(S.store_id IS NULL , M.products_thumb_image_name , S.products_thumb_image_name) as products_thumb_image_name,
IF(S.store_id IS NULL , M.products_large_image_name , S.products_large_image_name) as products_large_image_name,
IF(S.store_id IS NULL , M.sort_order , S.sort_order) as sort_order,
IF(S.store_id IS NULL , M.status , S.status) as status, IF(S.store_id IS NULL, M.type, S.type) as type,
IF(S.store_id IS NULL , M.store_id , S.store_id ) as store_id FROM products_image_gallery M
LEFT JOIN products_image_gallery S ON S.products_id = 8624 AND S.store_id= 0 AND S.type='P'
WHERE 1 AND M.store_id= 0 AND ((M.products_id = 8624 AND M.type='P') OR (M.products_id = 2381 AND M.type='C'))
AND ((M.language IN ('1', '0')) AND ( S.language IN ('1', '0') OR S.language IS NULL)) AND M.status = '1' AND (S.status='1' OR S.status IS NULL)
GROUP BY products_image_gallery_id ORDER BY S.sort_order,M.sort_order ASC 0.0009 sec

59. SELECT layout_name, is_mobile, sidebar_display, is_default, store_id, IF(FIND_IN_SET('8624',products_id)>0,'1','0') AS info_layout_order FROM product_info_layout WHERE (products_id LIKE '%,8624,%' OR is_default = '1') AND products_type = '0' AND store_id IN (0, 128) AND product_info_layout.store_id IN (128, 0) ORDER BY info_layout_order ASC,store_id Desc, store_id DESC 0.0015 sec

60. SELECT products.products_id,products_additional_option.prod_add_opt_id, products_additional_option.ibs_option_type, products_additional_option_attributes.attribute_id, products_additional_option_attributes.label, products_additional_option_attributes.label_code, products_additional_option_attributes.label_type, products_additional_option_description.title, products_additional_option_description.title, products_attributes_price.size_id, products_attributes_price.size_id, products_attributes_price.quantity, (SELECT sort_order FROM products_sizes WHERE products_sizes.size_id = products_attributes_price.size_id AND products_sizes.site_language_id = 1) as srt_order, (SELECT size_title FROM products_sizes WHERE products_sizes.size_id = products_attributes_price.size_id AND products_sizes.site_language_id = 1) as size_title, products_attributes_price.attribute_price_id, products_attributes_price.attributes_price, products_attributes_price_markup.store_attributes_price, IF(products_attributes_price_markup.attribute_price_id IS NOT NULL, markup_price, 0) as markup_price, IF(products_attributes_price_markup.attribute_price_id IS NOT NULL, "public", "global") as markup_type, IF(products_attributes_price_markup.attribute_price_id IS NOT NULL, markup_price, "") as store_attributes_percent_markup, products_attributes_price_markup.ibs_wholesale_price FROM products LEFT JOIN products_sizes ON products_sizes.products_id = products.products_id LEFT JOIN products_additional_option ON products_additional_option.products_id = products.products_id LEFT JOIN products_additional_option_attributes ON products_additional_option_attributes.prod_add_opt_id = products_additional_option.prod_add_opt_id AND products_additional_option_attributes.site_language_id = 1 LEFT JOIN products_additional_option_description ON products_additional_option_description.prod_add_opt_id = products_additional_option.prod_add_opt_id AND products_additional_option_description.site_language_id = 1 LEFT JOIN products_attributes_price ON products_attributes_price.attribute_id = products_additional_option_attributes.attribute_id LEFT JOIN products_attributes_price_markup ON products_attributes_price_markup.attribute_price_id = products_attributes_price.attribute_price_id LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products_additional_option.products_id = 8624 AND products_additional_option_description.site_language_id = 1 AND products_attributes_price_markup.ibs_wholesale_price != 0 AND products_attributes_price_markup.store_id = 128 AND products_attributes_price_markup.store_attributes_price > 0 AND products_attributes_price.quantity IN (SELECT DISTINCT qty FROM product_price WHERE product_price.products_id = 8624 AND product_price.visible = 1 AND product_price.size_id = products_sizes.size_id ) AND products_additional_option_attributes.status = '1' AND products_additional_option.status = '1' AND (products_attributes_price.size_id IN (SELECT DISTINCT size_id FROM products_sizes WHERE products_sizes.visible = '1') OR products_attributes_price.size_id = 0 ) AND products_additional_option.ibs_option_type = 'C' AND products_additional_option_description.ibs_option_identifier = 'colours' AND store_products.store_id = 128 ORDER BY srt_order ASC, products_additional_option_attributes.label_code ASC, products_attributes_price.quantity ASC 0.0047 sec

61. SELECT * FROM product_settings WHERE products_id = 8624 AND setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'COMMON_QUANTITY', 'PRODUCT_BROWSE_DESIGN', 'PRODUCT_UPLOAD_DESIGN', 'PRODUCT_CUSTOME_DESIGN', 'PRODUCT_DESC_SELECT_STORE_TEMPLATE_HELP_TEXT', 'PRODUCT_DESC_USER_UPLOAD_ART_HELP_TEXT', 'PRODUCT_DESC_USER_CREATION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_ACTION_LABEL', 'PRODUCT_QUOTE', 'PRODUCT_DESC_HIRE_DESIGNER_HELP_TEXT', 'PRODUCT_DESC_QUOTE_HELP_TEXT', 'PRODUCT_HIRE_DESIGNER', 'BOOK_NO_COVER', 'BOOK_COVER_INCLUDED_IN_CONTENT', 'PRODUCT_UPDATE_PRICE_TABLE') 0.0016 sec

62. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'COMMON_QUANTITY', 'PRODUCT_BROWSE_DESIGN', 'PRODUCT_UPLOAD_DESIGN', 'PRODUCT_CUSTOME_DESIGN', 'PRODUCT_DESC_SELECT_STORE_TEMPLATE_HELP_TEXT', 'PRODUCT_DESC_USER_UPLOAD_ART_HELP_TEXT', 'PRODUCT_DESC_USER_CREATION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_ACTION_LABEL', 'PRODUCT_QUOTE', 'PRODUCT_DESC_HIRE_DESIGNER_HELP_TEXT', 'PRODUCT_DESC_QUOTE_HELP_TEXT', 'PRODUCT_HIRE_DESIGNER', 'BOOK_NO_COVER', 'BOOK_COVER_INCLUDED_IN_CONTENT', 'PRODUCT_UPDATE_PRICE_TABLE') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'COMMON_QUANTITY', 'PRODUCT_BROWSE_DESIGN', 'PRODUCT_UPLOAD_DESIGN', 'PRODUCT_CUSTOME_DESIGN', 'PRODUCT_DESC_SELECT_STORE_TEMPLATE_HELP_TEXT', 'PRODUCT_DESC_USER_UPLOAD_ART_HELP_TEXT', 'PRODUCT_DESC_USER_CREATION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_ACTION_LABEL', 'PRODUCT_QUOTE', 'PRODUCT_DESC_HIRE_DESIGNER_HELP_TEXT', 'PRODUCT_DESC_QUOTE_HELP_TEXT', 'PRODUCT_HIRE_DESIGNER', 'BOOK_NO_COVER', 'BOOK_COVER_INCLUDED_IN_CONTENT', 'PRODUCT_UPDATE_PRICE_TABLE') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0135 sec

63. SELECT coupon.*, IF (coupon.product_id != 'all',1,2) AS OrderBY FROM coupon WHERE coupon.type = 'discount' AND coupon.coupon_type = 'product' AND '2021-01-19 21:53:09' BETWEEN coupon.coupon_start_date AND coupon.coupon_end_date AND coupon_status = '1' AND store_id IN ('0', '128')
AND store_coupon_status NOT LIKE '%,128,%' ORDER BY store_id DESC, OrderBY, user_discount_group_id DESC, coupon_start_date DESC , coupon_id DESC 0.0027 sec

64. SELECT * FROM products_related_products WHERE products_id = 8624 AND products_related_id = 0 0.0005 sec

65. SELECT products_related_products.products_id, products_related_id, IF( store_products_description.product_description IS NOT NULL AND store_products_description.product_description!='', store_products_description.product_description,products_description.product_description ) AS description, IF(store_products_description.products_title IS NOT NULL AND store_products_description.products_title!='', store_products_description.products_title, products_description.products_title) AS title, IF(store_products_description.imagename IS NOT NULL AND store_products_description.imagename!='' , store_products_description.imagename, products_description.imagename) AS imagename, products_description.product_url FROM products_related_products RIGHT JOIN products ON ( products.products_id = products_related_products.products_related_id ) LEFT JOIN products_description ON ( products.products_id = products_description.products_id and products_description.site_language_id = 1) LEFT JOIN store_products ON products.products_id = store_products.products_id AND store_products.store_id = 128 LEFT JOIN store_products_description ON store_products_description.store_products_id = store_products.store_products_id AND store_products_description.site_language_id = 1 WHERE products_related_products.products_id = 8624 AND products.visible = 1 AND (store_products.user_type_id = '1' OR store_products.user_type_id = '0') AND products_related_products.store_id = 128 AND store_products.visible = 1 ORDER BY rand() 0.0021 sec

66. SELECT predefined_product_type FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0006 sec

67. select q.*,q.value as product_id, if(p.discount IS NULL OR p.discount=0 , q.coupon_amount,p.discount) as discount , if(p.min_quantity IS NULL OR p.min_quantity=0 , 0,p.min_quantity) as min_qty , if(p.max_quantity IS NULL OR p.max_quantity=0,0,p.max_quantity) as max_qty , pdc.products_title ,pdc.imagename from ( SELECT c.coupon_id,c.coupon_amount,c.coupon_name,c.combo_discount_cms,product_id,c.applicable_with_option, type,SUBSTRING_INDEX(SUBSTRING_INDEX(c.product_id, ',', n.n), ',', -1) value ,c.product_id as coupon_products
FROM coupon c CROSS JOIN
(
SELECT a.N + b.N * 10 + 1 n
FROM
(SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) a
,(SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) b
ORDER BY n
) n
WHERE n.n <= 1 + (LENGTH(c.product_id) - LENGTH(REPLACE(c.product_id, ',', ''))) and c.type='combo_discount' AND find_in_set('8624',c.product_id) AND c.store_id IN ('128', '0') AND NOT find_in_set('128',c.store_coupon_status) AND '2021-01-19 21:53:09' BETWEEN c.coupon_start_date AND c.coupon_end_date AND c.coupon_status = '1' GROUP BY c.coupon_id,value ORDER BY c.coupon_id,value ) as q LEFT JOIN coupon_combo_products_rules p ON p.coupon_id = q.coupon_id and p.products_id = q.value
LEFT JOIN products pt ON ( pt.products_id = q.value)
LEFT JOIN products_description pdc ON ( pdc.products_id = pt.products_id and pdc.site_language_id =1 )LEFT JOIN store_products as spt ON pt.products_id = spt.products_id AND spt.store_id = 128 LEFT JOIN store_products_description as spdc ON ( spdc.store_products_id = spt.store_products_id and spdc.site_language_id =1 ) where pt.visible=1 AND spt.store_id = '128' AND spt.visible = 1 ORDER BY coupon_id ASC 0.0057 sec

68. SELECT layout_name, is_mobile, sidebar_display FROM product_info_layout WHERE layout_name = 'ALB-2' AND product_info_layout.store_id IN (128, 0) ORDER BY store_id DESC 0.0003 sec

69. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_CSS_CLASS') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_CSS_CLASS') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0049 sec

70. SELECT * FROM seo_image_alt_text WHERE parent_type ='P' AND parent_id =8624 AND store_id =128 AND site_language_id =1 0.0013 sec

71. SELECT * FROM seo_image_alt_text WHERE parent_type ='P' AND parent_id =8624 AND store_id =0 AND site_language_id =1 0.0015 sec

Render > mainpage.tpl

72 13. SELECT * FROM website_logos WHERE corporate_id = 0 AND store_id IN (128, 0) ORDER BY store_id DESC 0.0004 sec

73. SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages_description.page_heading, cms_pages_description.page_content, cms_pages.corporate_id FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND cms_pages.page_name = 'cms_header_content' AND cms_pages.status = '1' AND (cms_pages.corporate_id = 0 OR cms_pages.corporate_id = 0) AND cms_pages.store_id IN (128, 0) ORDER BY cms_pages.corporate_id ASC, cms_pages.store_id DESC, corporate_id DESC 0.0004 sec

Render > top_header_search.block

Render > user_login.block

Render > header_toplinks.block

74. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_LANGUAGE') AND store_id = 128 0.0005 sec

75. SELECT * FROM site_language WHERE status = '1' 0.0003 sec

76. SELECT * FROM site_currency WHERE currency_id IN (3) AND status = '1' 0.0002 sec

77 74. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_LANGUAGE') AND store_id = 128 0.0002 sec

78 75. SELECT * FROM site_language WHERE status = '1' 0.0003 sec

79. SET SESSION group_concat_max_len = 100000;0.0002 sec

80. SELECT GROUP_CONCAT(IF(store_products.category_id != 0,store_products.category_id,products.category_id)) as category_id,GROUP_CONCAT(IF(store_products.multiple_category != 0,store_products.multiple_category,products.multiple_category)) as multiple_category FROM store_products LEFT JOIN products ON products.products_id = store_products.products_id WHERE store_products.visible = '1' AND products.visible = '1' AND products.products_id != -11 AND store_products.store_id = 128 0.0159 sec

81. SELECT IF( store_product_category.category_pro_enable IS NOT NULL , store_product_category.category_pro_enable , product_category.category_pro_enable ) AS category_pro_enable, IF( store_product_category_description.category_promotional_text IS NOT NULL AND store_product_category_description.category_promotional_text!='' , store_product_category_description.category_promotional_text , product_category_description.category_promotional_text ) AS category_promotional_text, IF( store_product_category.category_pro_pattern IS NOT NULL AND store_product_category.category_pro_pattern!='' , store_product_category.category_pro_pattern , product_category.category_pro_pattern ) AS category_pro_pattern, pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,products.multiple_category, product_category_description.category_name,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title, product_category.category_pro_enable,product_category_description.category_promotional_text,products_description.product_promotional_text,pcd.category_name AS group_name, product_category.category_id,IF( store_product_category.category_pro_enable IS NOT NULL , store_product_category.category_pro_enable , product_category.category_pro_enable ) AS category_pro_enable,products.multiple_category, product_category_description.category_name,IF(store_product_category_description.category_promotional_text IS NOT NULL AND store_product_category_description.category_promotional_text!='' , store_product_category_description.category_promotional_text ,product_category_description.category_promotional_text) AS category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,IF(store_products_description.product_promotional_text IS NOT NULL AND store_products_description.product_promotional_text!='' , store_products_description.product_promotional_text , products_description.product_promotional_text ) AS product_promotional_text,IF(store_product_category.sort_order != '', store_product_category.sort_order , product_category.sort_order) AS final_sort_order, IF( store_products_description.products_title IS NOT NULL AND store_products_description.products_title!='' , store_products_description.products_title , products_description.products_title ) AS products_title, IF( store_product_category.category_pro_enable IS NOT NULL , store_product_category.category_pro_enable , product_category.category_pro_enable ) AS category_pro_enable,
IF( store_product_category_description.category_promotional_text IS NOT NULL AND store_product_category_description.category_promotional_text!='' , store_product_category_description.category_promotional_text , product_category_description.category_promotional_text ) AS category_promotional_text,
IF( store_products_description.product_promotional_text IS NOT NULL AND store_products_description.product_promotional_text!='' , store_products_description.product_promotional_text , products_description.product_promotional_text ) AS product_promotional_text,
IF( (store_product_category.parent_id) > 0 , store_product_category.parent_id , product_category.parent_id ) AS parent_id, (SELECT spc.sort_order FROM product_category_description
LEFT JOIN store_product_category spc ON spc.category_id = product_category_description.category_id AND spc.store_id = 128
LEFT JOIN product_category p ON p.category_id = product_category_description.category_id AND p.status = '1'
INNER JOIN product_category pp ON pp.parent_id = if(spc.parent_id > 0, spc.parent_id, p.parent_id) AND pp.status = '1'
WHERE product_category_description.category_id=IF( store_product_category.parent_id >0, store_product_category.parent_id, product_category.parent_id ) AND product_category_description.site_language_id = 1 AND p.store_id IN (128,0) AND pp.store_id IN (128,0) GROUP BY products.products_id) AS group_sort_order FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id AND store_products.store_id = 128 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN store_products_description ON store_products.store_products_id = store_products_description.store_products_id AND products_description.site_language_id = store_products_description.site_language_id LEFT JOIN product_category ON (store_products.category_id = product_category.category_id OR Find_in_set(product_category.category_id,store_products.multiple_category) > 0) AND product_category.store_id IN (128,0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pcd.site_language_id = 1 LEFT JOIN store_product_category ON store_product_category.category_id=product_category.category_id AND store_product_category.store_id= 128 LEFT JOIN store_product_category_description ON store_product_category_description.store_category_id=store_product_category.store_category_id AND store_product_category_description.site_language_id = 1 WHERE product_category.status = '1' AND store_products.visible = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0') AND products.kit_type_id != '1' AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (store_products.user_type_id = '1' OR store_products.user_type_id = '0') AND store_products.store_id = 128 ORDER BY group_sort_order ASC, final_sort_order ASC,store_product_category.sort_order ASC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, store_products.sort_order ASC, store_products.products_id ASC, products.sort_order ASC, products.products_id ASC 0.5848 sec

82. SELECT SQL_CALC_FOUND_ROWS product_category_description.category_name , IF( store_product_category.category_id != "" , store_product_category.category_id , product_category_description.category_id ) AS category_id FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id LEFT JOIN store_product_category ON store_product_category.category_id = product_category_description.category_id AND store_product_category.store_id = 128 WHERE product_category.store_id IN (0, 128) AND IF (store_product_category.parent_id > 0, store_product_category.parent_id,product_category.parent_id) = 0 ORDER BY store_product_category.sort_order ASC 0.008 sec

83. SELECT product_category.category_id,IF( store_product_category.category_pro_enable IS NOT NULL , store_product_category.category_pro_enable , product_category.category_pro_enable) AS category_pro_enable,IF( store_product_category.category_pro_pattern IS NOT NULL AND store_product_category.category_pro_pattern!='' , store_product_category.category_pro_pattern , product_category.category_pro_pattern) AS category_pro_pattern,IF(store_product_category_description.category_promotional_text IS NOT NULL AND store_product_category_description.category_promotional_text!='' , store_product_category_description.category_promotional_text , product_category_description.category_promotional_text) AS category_promotional_text,product_category_description.category_icon,product_category_description.category_header_content FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id LEFT JOIN store_product_category ON store_product_category.category_id=product_category.category_id AND product_category.store_id IN (0, 128) LEFT JOIN store_product_category_description ON store_product_category_description.store_category_id=store_product_category.store_category_id AND store_product_category_description.site_language_id = 1 WHERE product_category.status = '1' AND product_category.parent_id = '0' AND product_category_description.site_language_id = 1 0.0008 sec

84. SELECT IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.products_id , product_settings.products_id ) AS products_id , IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_constant_name , product_settings.setting_constant_name ) AS setting_constant_name, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE' UNION SELECT IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.products_id , product_settings.products_id ) AS products_id , IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_constant_name , product_settings.setting_constant_name ) AS setting_constant_name, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE' AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.3483 sec

85. SELECT SQL_CALC_FOUND_ROWS products.*,products_description.* FROM store_product_kit LEFT JOIN product_kit ON product_kit.kit_id = store_product_kit.kit_id AND store_id =128 LEFT JOIN products ON store_product_kit.product_id = products.products_id LEFT JOIN products_description ON products.products_id = products_description.products_id AND site_language_id = 1 WHERE products.kit_type_id != '1' AND products.visible = '1' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND store_product_kit.store_id = 128 ORDER BY store_product_kit.kit_id ASC 0.0008 sec

Render > header_menu.block

86. SELECT SQL_CALC_FOUND_ROWS banner_image.* FROM banner_image LEFT JOIN site_language ON site_language.site_language_id = banner_image.banner_language WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2021-01-19 21:53:10' AND banner_image.banner_end_date >= '2021-01-19 21:53:10')) AND banner_available_to ='1' AND (FIND_IN_SET('8624',banner_image.banner_pages)) AND banner_image.corporate_id = 0 AND store_id IN (0, 128) AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC 0.0011 sec

Render > banner.block

87 82. SELECT SQL_CALC_FOUND_ROWS product_category_description.category_name , IF( store_product_category.category_id != "" , store_product_category.category_id , product_category_description.category_id ) AS category_id FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id LEFT JOIN store_product_category ON store_product_category.category_id = product_category_description.category_id AND store_product_category.store_id = 128 WHERE product_category.store_id IN (0, 128) AND IF (store_product_category.parent_id > 0, store_product_category.parent_id,product_category.parent_id) = 0 ORDER BY store_product_category.sort_order ASC 0.0086 sec

88 84. SELECT IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.products_id , product_settings.products_id ) AS products_id , IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_constant_name , product_settings.setting_constant_name ) AS setting_constant_name, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE' UNION SELECT IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.products_id , product_settings.products_id ) AS products_id , IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_constant_name , product_settings.setting_constant_name ) AS setting_constant_name, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE' AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.2972 sec

Render > products_menu_group_vertical.block

Render > user_login.block

89. SELECT * FROM breadcrumbs WHERE status = '1' AND store_id = 128 0.0005 sec

90. SELECT * FROM breadcrumbs WHERE status = '1' AND store_id = 0 0.0002 sec

91. SELECT products_description.products_title, product_category_description.category_name, IF(store_products.category_id IS NOT NULL AND store_products.category_id > 0 ,store_products.category_id,products.category_id)AS category_id, IF(store_products_description.products_title IS NOT NULL AND store_products_description.products_title!='',store_products_description.products_title,products_description.products_title) AS products_title FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN store_products ON store_products.products_id = products.products_id LEFT JOIN product_category_description ON product_category_description.category_id = IF(store_products.category_id!='',store_products.category_id,products.category_id) AND product_category_description.site_language_id = products_description.site_language_id LEFT JOIN store_products_description ON store_products.store_products_id = store_products_description.store_products_id AND products_description.site_language_id = store_products_description.site_language_id WHERE products.products_id = 8624 AND store_products_description.site_language_id = 1 AND products_description.site_language_id = 1 AND products.predefined_product_type IN ('0') AND store_products.store_id = 128 0.0018 sec

92. SELECT product_category.category_id,product_category_description.category_name FROM product_category
LEFT JOIN store_product_category ON store_product_category.category_id = product_category.category_id AND product_category.store_id = 128 LEFT JOIN product_category_description ON (product_category_description.category_id = IF(store_product_category.parent_id IS NOT NULL AND store_product_category.parent_id >0 ,store_product_category.category_id,product_category.category_id) AND product_category_description.site_language_id = '1')
WHERE 1 AND product_category.category_id= ( SELECT IF(store_product_category.parent_id IS NOT NULL AND store_product_category.parent_id >0 ,store_product_category.parent_id,product_category.parent_id) FROM `product_category` LEFT JOIN store_product_category ON store_product_category.category_id = product_category.category_id WHERE product_category.`category_id` = '2381' AND store_product_category.store_id = 128) AND product_category.parent_id = '0' 0.0015 sec

93. SELECT products.*, products_description.products_title, products_description.long_description, products_description.product_desc_image, products_description.bw_page_label, products_description.color_page_label, store_products.product_type, store_products.visible AS store_visible, store_products.display_product, store_products.corporate_id, store_products.user_type_id,store_products.department_id,store_products.csv_allow
, IF(store_products.sort_order IS NOT NULL , store_products.sort_order , products.sort_order ) AS sort_order , IF(products.visible = '1' AND store_products.visible = '1' , products.visible , 0 ) AS visible , IF(store_products_description.products_title IS NOT NULL AND store_products_description.products_title!='',store_products_description.products_title,products_description.products_title) AS products_title, IF( store_products_description.long_description IS NOT NULL AND store_products_description.long_description!='' , store_products_description.long_description , products_description.long_description ) AS long_description, CASE WHEN store_products_description.bw_page_label IS NOT NULL AND store_products_description.bw_page_label!='' THEN store_products_description.bw_page_label ELSE products_description.bw_page_label END AS bw_page_label, CASE WHEN store_products_description.color_page_label IS NOT NULL AND store_products_description.color_page_label!='' THEN store_products_description.color_page_label ELSE products_description.color_page_label END AS color_page_label FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN store_products ON store_products.products_id = products.products_id LEFT JOIN store_products_description ON store_products.store_products_id = store_products_description.store_products_id AND products_description.site_language_id = store_products_description.site_language_id WHERE products.products_id = 8624 AND products.kit_type_id != '2' AND store_products_description.site_language_id = 1 AND products_description.site_language_id = 1 AND store_products.visible = 1 AND products.visible = 1 AND store_products.store_id = 128 ORDER BY products.products_id ASC 0.0019 sec

94. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('EAP_ENABLE_M2_CALCULATOR', 'EAP_M2_CALC_ENABLE_MACHINE_COST') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('EAP_ENABLE_M2_CALCULATOR', 'EAP_M2_CALC_ENABLE_MACHINE_COST') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0034 sec

95. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'CUSTOM_SIZE_INFO', 'CUSTOM_SIZE_INFO', 'PRODUCT_DEFAULT_QUANTITY', 'PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'CUSTOM_PRODUCT_LOOKUP', 'CUSTOM_SIZE_RESTRICT_DATA', 'M2_CAL_VERSION') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'CUSTOM_SIZE_INFO', 'CUSTOM_SIZE_INFO', 'PRODUCT_DEFAULT_QUANTITY', 'PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'CUSTOM_PRODUCT_LOOKUP', 'CUSTOM_SIZE_RESTRICT_DATA', 'M2_CAL_VERSION') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0071 sec

96. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'CUSTOM_SIZE_PREDEFINED_SIZES', 'CUSTOM_SIZE_INFO', 'CUSTOM_SIZE_RESTRICT_DATA', 'CUSTOM_SIZE_UNIT_CHANGE', 'CUSTOM_SIZE_UNIT_CHANGE') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'CUSTOM_SIZE_PREDEFINED_SIZES', 'CUSTOM_SIZE_INFO', 'CUSTOM_SIZE_RESTRICT_DATA', 'CUSTOM_SIZE_UNIT_CHANGE', 'CUSTOM_SIZE_UNIT_CHANGE') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0064 sec

97 93. SELECT products.*, products_description.products_title, products_description.long_description, products_description.product_desc_image, products_description.bw_page_label, products_description.color_page_label, store_products.product_type, store_products.visible AS store_visible, store_products.display_product, store_products.corporate_id, store_products.user_type_id,store_products.department_id,store_products.csv_allow
, IF(store_products.sort_order IS NOT NULL , store_products.sort_order , products.sort_order ) AS sort_order , IF(products.visible = '1' AND store_products.visible = '1' , products.visible , 0 ) AS visible , IF(store_products_description.products_title IS NOT NULL AND store_products_description.products_title!='',store_products_description.products_title,products_description.products_title) AS products_title, IF( store_products_description.long_description IS NOT NULL AND store_products_description.long_description!='' , store_products_description.long_description , products_description.long_description ) AS long_description, CASE WHEN store_products_description.bw_page_label IS NOT NULL AND store_products_description.bw_page_label!='' THEN store_products_description.bw_page_label ELSE products_description.bw_page_label END AS bw_page_label, CASE WHEN store_products_description.color_page_label IS NOT NULL AND store_products_description.color_page_label!='' THEN store_products_description.color_page_label ELSE products_description.color_page_label END AS color_page_label FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN store_products ON store_products.products_id = products.products_id LEFT JOIN store_products_description ON store_products.store_products_id = store_products_description.store_products_id AND products_description.site_language_id = store_products_description.site_language_id WHERE products.products_id = 8624 AND products.kit_type_id != '2' AND store_products_description.site_language_id = 1 AND products_description.site_language_id = 1 AND store_products.visible = 1 AND products.visible = 1 AND store_products.store_id = 128 ORDER BY products.products_id ASC 0.001 sec

98 94. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('EAP_ENABLE_M2_CALCULATOR', 'EAP_M2_CALC_ENABLE_MACHINE_COST') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('EAP_ENABLE_M2_CALCULATOR', 'EAP_M2_CALC_ENABLE_MACHINE_COST') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0017 sec

99 48. SELECT SQL_CALC_FOUND_ROWS products_id, added_by FROM store_products WHERE products_id = 8624 AND store_id = 128 0.0008 sec

100 49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.001 sec

101 49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.0005 sec

102 51. SELECT pap.size_id, count(*),ps.default_size
FROM `products_additional_option` pao
LEFT JOIN `products_additional_option_attributes` paoa ON pao.prod_add_opt_id = paoa.prod_add_opt_id
LEFT JOIN products_attributes_price pap ON paoa.attribute_id = pap.attribute_id
LEFT JOIN products_sizes ps ON ps.size_id = pap.size_id
LEFT JOIN products_attributes_price_markup papm ON pap.attribute_price_id = papm.attribute_price_id
WHERE pao.`products_id` = 8624
AND pap.quantity IN (SELECT qty FROM product_price WHERE product_price.products_id = 8624 AND product_price.visible = 1)
AND `ibs_option_type` = 'C'
AND paoa.label_code IN ('37')
AND pap.size_id > 0
AND store_attributes_price > 0
AND papm.store_id = 128
AND ps.visible = '1'
group by pap.size_id, quantity having count(*) = (SELECT count(*)
FROM `products_additional_option` paoi
LEFT JOIN `products_additional_option_attributes` paoai ON paoi.prod_add_opt_id = paoai.prod_add_opt_id WHERE `products_id` = 8624
AND `ibs_option_type` = 'C'
AND paoai.label_code IN ('37') AND paoai.status = '1') ORDER BY ps.default_size 0.0027 sec

103. SELECT products.products_id, products.size_visible, products_sizes.*, product_price.price, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page, product_price.price AS products_wholesale_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.store_price, (product_price.price + ((product_price.price * 0)/100))) as price,product_price.color_page_price AS products_wholesale_color_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.color_store_price, (product_price.color_page_price + ((product_price.color_page_price * 0)/100))) as color_page_price FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = '1' AND (`product_price`.`user_type_id` = '1') LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' LEFT JOIN product_price_markup ON product_price.product_price_id = product_price_markup.product_price_id AND product_price_markup.store_id = 128 RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = 1 AND `products_sizes`.`visible`='1' AND products_sizes.size_id IN (28769,28769,28769,28769,28769,28768,28768,28768,28768,28768) LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE `products`.`products_id` IN (8624) AND IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty_to` != 0, 1) AND products.predefined_product_type IN ('0') AND store_products.store_id = 128 GROUP BY `products`.`products_id`, `products_sizes`.`size_id` ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 0.003 sec

104. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('COMMON_QUANTITY', 'PRODUCT_DEFAULT_QUANTITY', 'PRODUCT_COMMON_MAILING_QTY', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'M2_CAL_VERSION', 'M2_CAL_VERSION_LABEL') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('COMMON_QUANTITY', 'PRODUCT_DEFAULT_QUANTITY', 'PRODUCT_COMMON_MAILING_QTY', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'M2_CAL_VERSION', 'M2_CAL_VERSION_LABEL') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0074 sec

105 66. SELECT predefined_product_type FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0009 sec

106 48. SELECT SQL_CALC_FOUND_ROWS products_id, added_by FROM store_products WHERE products_id = 8624 AND store_id = 128 0.0004 sec

107 49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.0005 sec

108 49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.0004 sec

109. SELECT GROUP_CONCAT(DISTINCT quantity) as exclude_quantity
FROM `products_additional_option` pao
LEFT JOIN `products_additional_option_attributes` paoa ON pao.prod_add_opt_id = paoa.prod_add_opt_id
LEFT JOIN products_attributes_price pap ON paoa.attribute_id = pap.attribute_id
LEFT JOIN products_attributes_price_markup papm ON pap.attribute_price_id = papm.attribute_price_id
WHERE `products_id` = 8624
AND `ibs_option_type` = 'C'
AND paoa.label_code IN ('37')
AND pap.size_id = 28768
AND store_attributes_price <=0
AND papm.store_id = 128 0.0011 sec

110. SELECT `product_price`.*, product_price.price, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page, product_price.price AS products_wholesale_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.store_price, (product_price.price + ((product_price.price * 0)/100))) as price,product_price.color_page_price AS products_wholesale_color_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.color_store_price, (product_price.color_page_price + ((product_price.color_page_price * 0)/100))) as color_page_price FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = '1' AND `product_price`.qty NOT IN ('') AND (`product_price`.`user_type_id` = '1') LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' LEFT JOIN product_price_markup ON product_price.product_price_id = product_price_markup.product_price_id AND product_price_markup.store_id = 128 RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = 1 AND `products_sizes`.`visible`='1' LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE `products`.`products_id` IN (8624) AND `product_price`.`size_id` IN (28768) AND IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty_to` != 0, 1) AND products.predefined_product_type IN ('0') AND store_products.store_id = 128 ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 0.0023 sec

111. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('RESTRICT_QUANTITY_RANGE', 'CUSTOM_SIZE_RESTRICT_DATA', 'CUSTOM_SIZE_UNIT_CHANGE') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('RESTRICT_QUANTITY_RANGE', 'CUSTOM_SIZE_RESTRICT_DATA', 'CUSTOM_SIZE_UNIT_CHANGE') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0035 sec

112. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name = 'RESTRICT_QUANTITY_RANGE' UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name = 'RESTRICT_QUANTITY_RANGE' AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0033 sec

113. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name = 'CUSTOM_SIZE_RESTRICT_DATA' UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name = 'CUSTOM_SIZE_RESTRICT_DATA' AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0032 sec

114. SELECT * FROM products_sizes WHERE products_id =8624 0.0008 sec

115. SELECT products.*, store_products.product_type, store_products.visible AS store_visible, store_products.display_product, store_products.corporate_id, store_products.user_type_id,store_products.department_id,store_products.csv_allow
, IF(store_products.sort_order IS NOT NULL , store_products.sort_order , products.sort_order ) AS sort_order , IF(products.visible = '1' AND store_products.visible = '1' , products.visible , 0 ) AS visible FROM products LEFT JOIN products_sizes ON products_sizes.products_id = products.products_id LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE size_id =28768 AND store_products.store_id = 128 0.0013 sec

116. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('ENABLE_AUTO_CALCULATION') AND store_id = 128 0.0003 sec

117. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('M2_CAL_VERSION') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('M2_CAL_VERSION') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0034 sec

118 48. SELECT SQL_CALC_FOUND_ROWS products_id, added_by FROM store_products WHERE products_id = 8624 AND store_id = 128 0.0004 sec

119 49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.0005 sec

120 49. SELECT label_code FROM products_additional_option_attributes LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id WHERE products_additional_option.products_id = 8624 AND products_additional_option.ibs_option_type = 'C' AND products_additional_option.status = '1' AND products_additional_option_attributes.status = '1' 0.0004 sec

121 109. SELECT GROUP_CONCAT(DISTINCT quantity) as exclude_quantity
FROM `products_additional_option` pao
LEFT JOIN `products_additional_option_attributes` paoa ON pao.prod_add_opt_id = paoa.prod_add_opt_id
LEFT JOIN products_attributes_price pap ON paoa.attribute_id = pap.attribute_id
LEFT JOIN products_attributes_price_markup papm ON pap.attribute_price_id = papm.attribute_price_id
WHERE `products_id` = 8624
AND `ibs_option_type` = 'C'
AND paoa.label_code IN ('37')
AND pap.size_id = 28768
AND store_attributes_price <=0
AND papm.store_id = 128 0.0003 sec

122. SELECT `product_price`.*,products.enable_color_pages, product_price.price, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page, product_price.price AS products_wholesale_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.store_price, (product_price.price + ((product_price.price * 0)/100))) as price,product_price.color_page_price AS products_wholesale_color_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.color_store_price, (product_price.color_page_price + ((product_price.color_page_price * 0)/100))) as color_page_price FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = '1' AND `product_price`.qty NOT IN ('') AND (`product_price`.`user_type_id` = '1') LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' LEFT JOIN product_price_markup ON product_price.product_price_id = product_price_markup.product_price_id AND product_price_markup.store_id = 128 RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = 1 AND `products_sizes`.`visible`='1' LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE `products`.`products_id` IN (8624) AND `product_price`.`size_id` IN (28768) AND IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty` <= 100 AND `product_price`.`qty_to` >= 100 AND `product_price`.`qty_to` != 0 , `product_price`.`qty` IN (100)) AND products.predefined_product_type IN ('0') AND store_products.store_id = 128 ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 0.0027 sec

123. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('EAP_ENABLE_M2_CALCULATOR', 'EAP_M2_CALC_ENABLE_MACHINE_COST', 'CUSTOM_PRODUCT_LOOKUP') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('EAP_ENABLE_M2_CALCULATOR', 'EAP_M2_CALC_ENABLE_MACHINE_COST', 'CUSTOM_PRODUCT_LOOKUP') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0038 sec

124 53. SELECT enable_sheet_calculation,price_defining_method FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0008 sec

125. SELECT * FROM user_basket WHERE user_id = 0 AND cart_detail NOT LIKE '%cart_payment_request%' 0.0004 sec

126. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name = 'PRODUCT_SETUP_COST' UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name = 'PRODUCT_SETUP_COST' AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0036 sec

127. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('PRODUCT_ADDITIONAL_OPTION_FOR_STOCK_MANAGE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'PRODUCT_ADDITIONAL_OPTION_GALLERY', 'M2_CAL_VERSION') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('PRODUCT_ADDITIONAL_OPTION_FOR_STOCK_MANAGE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'PRODUCT_ADDITIONAL_OPTION_GALLERY', 'M2_CAL_VERSION') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0057 sec

128. SELECT products_weight.* FROM products_weight left join products_sizes on products_weight.size_id=products_sizes.size_id WHERE products_sizes.products_id= 8624 AND products_sizes.site_language_id= 1 0.0353 sec

129. SELECT predefined_product_type, enable_stock_management FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id = 8624 AND store_products.store_id = 128 0.0007 sec

130 48. SELECT SQL_CALC_FOUND_ROWS products_id, added_by FROM store_products WHERE products_id = 8624 AND store_id = 128 0.0004 sec

131. SELECT * FROM affiliate_wise_ibs_extras_visibility WHERE products_id = 8624 AND store_id = 128 0.0018 sec

132. SELECT * FROM product_option_rules WHERE products_id = 8624 AND status = '1' ORDER BY rule_type ASC 0.0311 sec

133. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name = 'CUSTOM_PRODUCT_LOOKUP' UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name = 'CUSTOM_PRODUCT_LOOKUP' AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0034 sec

134. SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM product_settings LEFT JOIN store_product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id AND store_product_settings.store_id = 128 WHERE 1 AND product_settings.products_id = 8624 AND product_settings.setting_constant_name IN ('M2_CAL_VERSION', 'M2_CAL_VERSION_LABEL') UNION SELECT product_settings.*, (IF( (store_product_settings.setting_constant_name IS NOT NULL), store_product_settings.setting_value , product_settings.setting_value )) AS setting_value , (IF( (store_product_settings.setting_constant_name IS NOT NULL), 'store' , 'master')) AS products_setting_from, (IF( (product_settings.setting_constant_name IS NULL), store_product_settings.setting_constant_name, product_settings.setting_constant_name)) as setting_constant_name FROM store_product_settings LEFT JOIN product_settings ON store_product_settings.setting_constant_name = product_settings.setting_constant_name AND store_product_settings.products_id = product_settings.products_id WHERE 1 AND store_product_settings.products_id = 8624 AND store_product_settings.setting_constant_name IN ('M2_CAL_VERSION', 'M2_CAL_VERSION_LABEL') AND product_settings.setting_constant_name IS NULL AND store_product_settings.store_id = 128 0.0034 sec

135. SELECT products.*, store_products.product_type, store_products.visible AS store_visible, store_products.display_product, store_products.corporate_id, store_products.user_type_id,store_products.department_id,store_products.csv_allow
, IF(store_products.sort_order IS NOT NULL , store_products.sort_order , products.sort_order ) AS sort_order , IF(products.visible = '1' AND store_products.visible = '1' , products.visible , 0 ) AS visible FROM products LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE products.products_id =8624 AND store_products.store_id = 128 0.0011 sec

136 116. SELECT SQL_CALC_FOUND_ROWS store_id, setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('ENABLE_AUTO_CALCULATION') AND store_id = 128 0.0003 sec

137. SELECT * FROM products_additional_option LEFT JOIN products_additional_option_group ON (products_additional_option_group.prod_add_opt_group_id = products_additional_option.prod_add_opt_group_id AND products_additional_option_group.site_language_id='1') LEFT JOIN products_additional_option_description ON products_additional_option_description.prod_add_opt_id = products_additional_option.prod_add_opt_id WHERE (products_additional_option.ibs_option_type = 'C' OR products_additional_option.ibs_included_extra = 'yes' OR products_additional_option.prod_add_opt_id IN (40371,40370) ) AND products_id = 8624 AND status = '1' AND products_additional_option_description.site_language_id = 1 AND (options_type != 'area' AND options_type != 'file') AND display_in_calculator = '1' AND products_additional_option.hire_designer_option != '1' AND products_additional_option.options_type != 'cfile' ORDER BY products_additional_option_group.sort_order ASC, products_additional_option_group.prod_add_opt_group_id ASC, products_additional_option.prod_add_opt_id DESC, products_additional_option.sort_order ASC 0.0033 sec

138. SELECT distinct products_additional_option.prod_add_opt_id, products_additional_option.status, products_additional_option_description.title, products_additional_option_description.description, products_additional_option.options_code, products_additional_option.options_type, products_additional_option.product_option_position, products_additional_option_attributes.attribute_id, products_additional_option_attributes.label, products_additional_option.hire_designer_option, products_additional_option.custom_txtbox_opt_id, products_additional_option_attributes.default_attribute, products_additional_option.apply_multiplication, products_attributes_price.attribute_price_id, products_attributes_price.size_id, products_attributes_price.attributes_price, products_additional_option.price_calculate_type, products_additional_option.required, products_additional_option_attributes.attributes_image, products_additional_option.applicable_for, products_additional_option_attributes.calculate_on_half_page_count, canvas_bind_attributes.eventattrid as canvas_event_attrid, canvas_bind_attributes.value as canvas_attr_value, canvas_event_attributes.eventid AS canvas_eventd, canvas_events.event AS canvas_event_name, canvas_event_attributes.attrvalue as canvas_event_type, products_additional_option_attributes.price_per_unit, products_attributes_price.attributes_price AS wholesale_option_price,IF(products_attributes_price_markup.attribute_price_id IS NOT NULL, store_attributes_price, (attributes_price + ((attributes_price * 0)/100))) AS attributes_price, vendor_price.vendor_price,vendor_price.vendor_price_extra_page FROM products_additional_option LEFT JOIN products_additional_option_description ON products_additional_option.prod_add_opt_id = products_additional_option_description.prod_add_opt_id AND products_additional_option_description.site_language_id = 1 LEFT JOIN products_additional_option_attributes ON products_additional_option.prod_add_opt_id = products_additional_option_attributes.prod_add_opt_id AND products_additional_option_attributes.site_language_id = 1 AND products_additional_option_attributes.status = '1' LEFT JOIN products_attributes_price ON products_additional_option_attributes.attribute_id = products_attributes_price.attribute_id AND products_attributes_price.quantity= 100 AND products_attributes_price.size_id IN ('28768', '0') LEFT JOIN products_attributes_price_markup ON products_attributes_price_markup.attribute_price_id = products_attributes_price.attribute_price_id AND products_attributes_price_markup.store_id = 128 LEFT JOIN store_products ON store_products.products_id = products_additional_option.products_id AND store_products.store_id = 128 LEFT JOIN vendor_price ON vendor_price.price_id = products_attributes_price.attribute_price_id AND vendor_price.price_type = 'A' LEFT JOIN canvas_bind_attributes ON canvas_bind_attributes.attrid = products_additional_option_attributes.attribute_id LEFT JOIN canvas_event_attributes ON canvas_event_attributes.attrid = canvas_bind_attributes.eventattrid LEFT JOIN canvas_events ON canvas_events.eventid = canvas_event_attributes.eventid WHERE products_additional_option.products_id = 8624 AND products_additional_option.status = '1' AND products_additional_option_attributes.attribute_id <> '' and 1 = 1 GROUP BY products_additional_option.prod_add_opt_id, products_additional_option_attributes.attribute_id, products_attributes_price.size_id ORDER BY products_additional_option.hire_designer_option DESC,products_additional_option_attributes.sort_order ASC 0.0122 sec