Booklets (Print Marketing Services)

1. SELECT set_value, constant_name FROM configuration_master WHERE constant_name IN ('CORPORATE_MODUEL_ENABLE') 0.0098 sec (Cached) c3b6d0443f6382a78ef81662f9216c30

2. SELECT ip_address FROM ip_address_management WHERE type = 'B' 0.0003 sec (Cached) 608e11da3aa72a6989538cb7a26086cb

3. SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE (corporate_user.directory_name = 'promo' OR corporate_user.main_url IN ('promo.fourprintshop.com', 'www.promo.fourprintshop.com')) ORDER BY corporate_user.corporate_type ASC 0.0013 sec

4. 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 (Cached) 92dd46f86c59b1ac5575508e01c5a6de

5. SELECT configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type FROM configuration_master WHERE (configuration_master.available_for_corporate LIKE '%%' OR configuration_master.available_for_corporate = '-1') ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.0006 sec

6. SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'etcmarketing' 0.0003 sec (Cached) b6863d9b1dd34bb0cb8c83d6f4731383

7. SELECT payment_method_id, directory FROM payment_method WHERE directory IN ('payon_account', 'partial_payment') ORDER BY sort_order ASC 0.0001 sec (Cached) e4e2b78166a96840443ba3ecc630401c

8. SELECT external_services.*,external_service_section.section_name FROM external_services LEFT JOIN external_service_section ON external_services.section_id = external_service_section.section_id WHERE external_services.corporate_id = 0 0.0004 sec (Cached) bafbd2c26416bc75c33b6795ee8c8935

9. SELECT website_logos.* FROM website_logos WHERE website_logos.corporate_id IN ('0') ORDER BY FIELD(corporate_id, 0, 0, 0) 0.0003 sec (Cached) c50417c897b06607152835b8442622ef

10. SELECT * FROM site_language 0.0003 sec (Cached) d006a14cdb095c4bf9083702065fe3f4

11. SELECT * FROM url_redirection_manage WHERE (old_url = 'https://promo.fourprintshop.com/print-marketing-services/booklets/' OR old_url = 'https://promo.fourprintshop.com/print-marketing-services/booklets/' OR old_url = 'https://promo.fourprintshop.com/print-marketing-services/booklets/') ORDER BY url_redirection_id ASC 0.0007 sec

12. SELECT * FROM site_currency WHERE default_currency = '1' 0.0021 sec

13. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id FROM products_description WHERE products_description.product_url = 'booklets' 0.0007 sec

14. SELECT * FROM product_settings WHERE product_settings.products_id = 419 0.0068 sec

15. select TC.category_id, TCD.category_name, TCD.category_url, TCD.site_language_id 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.001 sec

16. 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.0007 sec

17. SELECT name,parent_id,ps_category_id,category_url FROM ps_category 0.0017 sec

18. SELECT products.products_id, products_description.product_url as producturl, products_description.products_title as productname, products_description.site_language_id FROM products LEFT JOIN products_description on products_description.products_id = products.products_id 0.0003 sec (Cached) 04999c418c66ee0ce95a5faeceb9b7ef

19. SELECT product_category.category_id,product_category_description.category_name,product_category_description.category_url,product_category.status,product_category.parent_id FROM product_category
LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = '1')
WHERE 1 0.0007 sec

20. SELECT products_description.products_title, product_category_description.category_name, products.category_id, product_category_description.category_url,products.visible,product_category.status AS category_status, products.multiple_category, products.products_id FROM products LEFT JOIN product_category ON product_category.category_id = products.category_id LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_category_description ON product_category_description.category_id = products.category_id AND product_category_description.site_language_id = products_description.site_language_id WHERE products_description.site_language_id = 1 AND products.predefined_product_type IN ('0', '1') 0.0008 sec

21. select product_url,ps_products_id,product_name,product_code from ps_products 0.0101 sec

22. SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages.type, cms_pages_description.page_id, cms_pages_description.page_url, cms_pages_description.site_language_id, cms_pages.corporate_id, cms_pages.category_id, cms_pages_description.page_heading, cms_pages_description.image_name, cms_pages_description.short_description, cms_pages.blog_page, cms_pages.sort_order, cms_pages.status, cms_pages_description.site_language_id, cms_pages.blog_page, category_cms_pages.page_name AS category_page_name, category_cms_pages_description.page_url AS category_page_url, category_cms_pages_description.page_heading AS category_page_heading FROM cms_pages LEFT JOIN cms_pages AS category_cms_pages ON category_cms_pages.page_id = cms_pages.category_id AND category_cms_pages.status = '1' LEFT JOIN cms_pages_description AS category_cms_pages_description ON category_cms_pages_description.page_id = category_cms_pages.page_id AND category_cms_pages_description.site_language_id = 1 LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.type != 'I' AND cms_pages.corporate_id = 0 ORDER BY cms_pages.sort_order, cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0008 sec

23. SELECT site_seo_description.seo_page_title, site_seo.page_name,site_seo_description.seo_page_description, 0 AS corporate_id FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE IF(site_seo_description.site_language_id IS NOT NULL, site_seo_description.site_language_id = 1, 1) AND (site_seo.page_name = 'product_info.php' OR site_seo.page_name = 'product_info' OR site_seo.page_name = 'Default') ORDER BY site_seo.page_id desc 0.0005 sec

24 13. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id FROM products_description WHERE products_description.product_url = 'booklets' 0.0005 sec

25. SELECT products_description.seo_page_title,products_description.seo_page_description, products_description.seo_page_metatags, products_description.products_title,products_description.canonical_id, products_description.schema_markup, products_description.imagename FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products_description.site_language_id = 1 AND products.products_id = 419 0.0007 sec

26. SELECT site_general_metatag.name, site_general_metatag.content, site_general_metatag.type 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 site_general_metatag.corporate_id = 0 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)) ORDER BY site_front_pages.front_pages_id DESC 0.0002 sec (Cached) 3c57829f108685bdd23e904d34b9124d

27. SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'product_info' 0.002 sec

28. SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants.constant_id, Concat(site_constants.constant_id, IF(site_constants_description.corporate_id = -1, 1, IF(site_constants_description.corporate_id != 0 AND site_constants_description.corporate_id = 0, 2, 0))) AS corporateid, site_constants_description.corporate_id 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 OR site_constants_description.corporate_id IS NULL ) GROUP BY corporateid ORDER BY FIELD(corporate_id, 0, 0, 0)) AS site_constants_description GROUP BY site_constants_description.constant_id ORDER BY FIELD(corporate_id, 0, 0, 0) 0.001 sec

29. 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 menu_link.corporate_id = 0 AND (link_display = '2' OR link_display = '0') LIMIT 18446744073709551615) AS temp_table ORDER BY sort_order ASC, menu_id ASC 0.0006 sec

30. SELECT * FROM sidebar_management WHERE section_pages LIKE '%|product_info.php|%' AND sidebar_management.corporate_id = 0 OR sidebar_id = '1' ORDER BY sidebar_id DESC LIMIT 1 OFFSET 0 0.0002 sec (Cached) cfe806c3379e8cc2d47671cefc0b5152

31. SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND side_menu_link.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 LIMIT 18446744073709551615 ) AS temp_table ORDER BY sortorder ASC, status ASC, menu_title ASC 0.0007 sec

32. 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 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', 'product_info_extra_msg_two') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY FIELD(cms_pages.corporate_id, 0, 0, 0), cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0009 sec

33. SELECT * FROM testimonial INNER JOIN testimonial_description ON (testimonial.testimonial_id = testimonial_description.testimonial_id) WHERE testimonial.corporate_id = 0 AND testimonial.status = '1' AND testimonial_description.site_language_id = 1 ORDER BY RAND() LIMIT 0 OFFSET 0 0.0006 sec

34. SELECT product_category.category_id, pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.sort_order,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,pcd.category_name AS group_name,product_category_description.category_icon,product_category_description.category_header_content FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 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 pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '1') AND products.kit_type_id != '1' AND products.product_service_type NOT IN ('2', '3', '4', '5') AND ((products.user_type_id IN ('0', '1'))) ORDER BY product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC 0.0003 sec (Cached) faff849b44492646888ce5f4590fbd77

35. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE') 0.0002 sec (Cached) bbf87f8045e8db0bf5318438fb787874

36. SELECT type, page_id FROM cms_pages WHERE page_id IN (10) ORDER BY cms_pages.sort_order ASC 0.0012 sec

37. SELECT SQL_CALC_FOUND_ROWS ps_category_id,parent_id,name FROM ps_category WHERE name is not null ORDER BY parent_id 0.0019 sec

38. SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting 0.0003 sec (Cached) 3032d2886e227e87f9c8146b7a2b4507

40. SELECT * FROM external_services WHERE external_services.directory LIKE 'foreover' AND external_services.corporate_id = 0 0.0006 sec

41. SELECT * FROM tp_4over_settings WHERE setting_name = 'default_markup_4over' 0.0006 sec

42 13. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id FROM products_description WHERE products_description.product_url = 'booklets' 0.0009 sec

43 14. SELECT * FROM product_settings WHERE product_settings.products_id = 419 0 sec (Cached) b5392ff51fb82fe7e7070eb80d8bc35e

44. SELECT *, IF(prod_add_opt_ids='', IF(attribute_ids='', '1', '0'), '-1' ) AS matchvalue FROM products_sku WHERE products_id = 419 AND `attribute_ids` = '' AND `prod_add_opt_ids` = '' ORDER BY prod_add_opt_ids DESC , matchvalue DESC , products_sku_id ASC 0.0009 sec

45. SELECT price_defining_method FROM products WHERE products_id = 419 0.0006 sec

46. SELECT SQL_CALC_FOUND_ROWS category_uuid FROM tp_4over_category WHERE category_uuid = '8b570b5b-3ea9-4ea7-b869-dab31bb644d8' 0.0006 sec

47. SELECT forover_product_id FROM tp_move_ops_product WHERE ops_product_id = 419 ORDER BY default_selected DESC 0.0006 sec

48. SELECT * FROM products WHERE products.products_id = 419 0.0011 sec

49 14. SELECT * FROM product_settings WHERE product_settings.products_id = 419 0.0005 sec (Cached) b5392ff51fb82fe7e7070eb80d8bc35e

50. SELECT layout_name, is_mobile, sidebar_display, is_default, IF(FIND_IN_SET('419',products_id)>0,'1','0') AS info_layout_order, user_type_id, corporate_id, products_id, layout_data, full_width FROM product_info_layout WHERE (products_id LIKE '%,419,%' OR is_default = '1') AND products_type = '0' AND ((product_info_layout.user_type_id IN ('0', '1'))) ORDER BY user_type_id,corporate_id,info_layout_order ASC 0.0076 sec

51. SELECT products.*, products_description.*, seo_image_alt_text.image_alt FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN seo_image_alt_text ON seo_image_alt_text.parent_id = products.products_id AND parent_type = 'P' AND seo_image_alt_text.site_language_id = 1 WHERE products.products_id = 419 AND products_description.site_language_id = 1 AND products.visible = 1 AND ((products.user_type_id IN ('0', '1'))) 0.0014 sec

52. SELECT SQL_CALC_FOUND_ROWS 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 = 11 AND product_category_description.site_language_id = 1 AND product_category.parent_id != 0 0.0005 sec

53. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=419 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC 0.0011 sec

54. SELECT * FROM products_sizes WHERE products_id = 419 AND visible = '1' AND site_language_id = 1 0.0027 sec

55. SELECT SQL_CALC_FOUND_ROWS orders.customers_name,orders_feedback.* FROM orders_feedback LEFT JOIN orders ON orders_feedback.orders_id = orders.orders_id WHERE orders_feedback.products_type_id = 419 AND orders_feedback.status like '1' 0.0014 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 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 = 419 OR duplicate_product_id LIKE '%,419-%') 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.0018 sec

57. SELECT SQL_CALC_FOUND_ROWS products_image_gallery.*, products_additional_option.status AS option_status, products_additional_option_attributes.status AS attribute_status, IF((products_image_gallery.option_id != 0 or products_image_gallery.attribute_id != 0) and (products_additional_option.status != '1' OR products_additional_option_attributes.status != '1'), 0,1) AS is_active FROM products_image_gallery LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_image_gallery.option_id LEFT JOIN products_additional_option_attributes ON products_additional_option_attributes.attribute_id = products_image_gallery.attribute_id AND products_additional_option_attributes.site_language_id = 1 WHERE products_image_gallery.products_id = 419 AND (products_image_gallery.language = 1 OR products_image_gallery.language = 0) AND products_image_gallery.status = '1' HAVING is_active = 1 ORDER BY products_image_gallery.option_id ASC, products_image_gallery.option_ids ASC, products_image_gallery.sort_order ASC 0.0029 sec

58. SELECT * FROM products_related_products WHERE products_id = 419 AND products_related_id = 0 0.0082 sec

59. SELECT products_related_products.products_id, products_related_id, products_description.product_description as description, products_description.product_url, seo_image_alt_text.image_alt, (SELECT products_description.imagename FROM products_description WHERE products_description.products_id = products_related_products.products_related_id AND products_description.site_language_id = 1) AS imagename, (SELECT products_description.products_title FROM products_description WHERE products_description.products_id = products_related_products.products_related_id AND products_description.site_language_id = 1) AS title 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 seo_image_alt_text ON seo_image_alt_text.parent_id = products_description.products_id AND parent_type = "P" AND seo_image_alt_text.site_language_id = 1 WHERE products_related_products.products_id = 419 AND products.visible = 1 AND ((products.user_type_id IN ('0', '1'))) ORDER BY rand() 0.0056 sec

60. SELECT products.predefined_product_type FROM products WHERE products.products_id = 419 0.0064 sec

61. 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, products_description.products_title, products_description.imagename from (SELECT c.coupon_id, c.coupon_amount, c.coupon_name, product_id, c.user_discount_group_id, c.coupon_condition, c.applicable_with_option, type, SUBSTRING_INDEX(SUBSTRING_INDEX(c.product_id, ',', n.n), ',', -1) value, c.product_id as coupon_products, c.coupon_spec_users, c.user_type, c.created_by
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('419',c.product_id) AND c.created_by = 0 AND '2025-04-03 10:27:05' BETWEEN c.coupon_start_date AND c.coupon_end_date AND c.coupon_status = '1' GROUP BY c.coupon_id,value ORDER BY c.created_by DESC, 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 ON (products.products_id = q.value) AND ((products.user_type_id IN ('0', '1')))
LEFT JOIN products_description ON (products_description.products_id = products.products_id and products_description.site_language_id = 1) where products.visible = 1 0.0032 sec

62. SELECT layout_name, is_mobile, sidebar_display FROM product_info_layout WHERE layout_name = '4over products' 0.0003 sec (Cached) a678ee6e62660b2d3fdec4c5d7a150d8

63. SELECT * FROM tp_move_ops_product WHERE ops_product_id = 419 0.0009 sec

64. SELECT SQL_CALC_FOUND_ROWS * FROM tp_4over_products WHERE categories = '8b570b5b-3ea9-4ea7-b869-dab31bb644d8' AND default_selected = '1' 0.0066 sec

65. SELECT SQL_CALC_FOUND_ROWS tp_4over_product_group_option_master.*, tp_4over_product_group_master.order_by, tp_product_price.* FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master ON tp_4over_product_group_option_master.option_group_uuid = tp_4over_product_group_master.option_group_uuid LEFT JOIN tp_product_price ON tp_product_price.product_uuid = tp_4over_product_group_option_master.product_uuid WHERE tp_4over_product_group_option_master.product_uuid = '01940697-ff5f-47be-b31c-f27ecef8acd4' GROUP BY option_group_uuid ORDER BY tp_4over_product_group_master.order_by ASC, tp_product_price.product_baseprice ASC 0.0018 sec

66. SELECT SQL_CALC_FOUND_ROWS product_uuid FROM tp_4over_products WHERE categories = '8b570b5b-3ea9-4ea7-b869-dab31bb644d8' And status LIKE '1' 0.003 sec

67. SELECT SQL_CALC_FOUND_ROWS tp_4over_product_group_option_master.option_group_uuid,prd_grp_mst.option_group_name,count(tp_4over_product_group_option_master.option_group_uuid) grp_opt_cnt FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as prd_grp_mst ON prd_grp_mst.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('003c48e4-6c3c-40e9-91f4-22989a82ce75', '01940697-ff5f-47be-b31c-f27ecef8acd4', '024ecc7d-822f-468f-82f0-dbbdb0c728ef', '028b6a9d-0394-4e1c-9161-59d68d897534', '029f96c1-a187-42a6-bae7-6e84a362ffec', '0379d5a2-b6c6-4ac8-96c1-fe9360ae2a4b', '0589d774-b268-4bd4-aa0f-834d5530ffdf', '064228e5-b099-4250-ad72-39fb89128683', '0682cbb8-184c-4af2-9715-4678dbe9148e', '06b301d3-ade0-4afc-b132-39664e9af90e', '06c0f588-9182-4808-a5b1-dac0014ed174', '079edab3-5692-498b-ae6a-629b650ccac6', '07e14ce6-a9af-47d3-9059-11f48169c1ba', '08603380-d3b1-4f8a-85c9-c70535a59455', '0a742208-e65b-4fc0-947c-0eaeccd4f05b', '0ab95529-c06b-4bcb-b090-c394cf74daf1', '0d533817-f477-4d8f-b586-3d0ecef33dee', '0e9d8e5e-cf0b-410d-9acd-55dfb22508b6', '0ec32475-24e5-426e-abc6-793c70a2befe', '1043f18d-9fa8-43c2-8c7f-a81670fe336f', '10c924c4-e0c4-47cf-9a53-01968d04cee0', '1100aee8-e331-401b-9bb5-94c155bd1ae9', '119f4821-b2e5-4085-83da-eeb10e5f1c61', '13143b5e-8293-4cbb-a485-f8c4cb175fac', '14523fbd-aeca-4273-aa1d-143db4953739', '1550975f-af8f-4ddf-b70e-0ad3867d4bb9', '155f0f6c-e0e7-4510-b026-d8ac29d69dd9', '161c844e-f3f6-4e03-a300-b99a8739dc46', '16b11d73-d520-4d88-b769-4e1439d5b71b', '16d0ddcb-bff9-42e8-b8e7-72d18cd86d5c', '171e669c-1f1a-460c-81c4-094a21214236', '181cb9ea-ac6d-451a-924d-3e581f7fec76', '18d87b1f-4867-4766-ad36-88ac8fdc1229', '19aa1ee2-ec8e-47b6-8ffe-d70768b0f426', '1ae278ce-e5ad-4a97-a094-341374e72499', '1d0d748f-dc1c-49a1-b144-c52ccd4affcf', '1db2e2a7-3072-4da2-b706-b132d6bca3f2', '1e1b3bef-02f8-4856-b06e-fd44bc6212d0', '1f267bf7-46eb-49ac-9935-ac2bb9f22701', '1f4c0d83-74ea-45ed-ac3b-fb359d31d1e0', '2131dffd-ba40-401a-b97c-4ea6d95a67af', '217512ed-2cc3-4c6b-b43f-c4cf7ca395f6', '218e9f01-3e9c-4a85-b78c-99c73597bd88', '227119a8-6c0f-4d39-a9a3-cdcac6479276', '22790e66-915b-4eeb-9ef9-fe0881d486d0', '22fc2460-4981-4815-aef4-b8c6e1b7bf82', '248fbd9d-26a5-4c75-9f38-0e8995a3602c', '2536e7db-70a2-479c-bbab-f98087261573', '25966aeb-b483-4f87-8a3e-3fe57df45ef1', '25c978f4-dda9-4965-9cd8-8858029824d9', '261a4562-23da-40b3-b0df-6f9cb9fa1dc4', '271e16c6-81a2-4d3f-8420-e5a2c95431c1', '285fc540-1e49-44e0-a52d-844eab3f9093', '28a425e2-513f-49db-ba13-4c0127ae987e', '2a785f3d-ead7-46d7-a58f-3a5a0ce4e168', '2aba7eb1-bd81-4d0d-98ea-c950e82a3452', '2c9f3599-9c82-4ee2-a53e-41fc81481d42', '2cd3d652-2090-4bfd-ae85-5f6ff2be8d9b', '2d6edd5e-42d1-4438-ab72-f0e1aa823d32', '2ddd72b5-cc8c-40ff-98f6-46af8106736f', '2e246c57-627f-4aee-9dc5-e114feed755e', '2e7c7896-4883-4235-bf3b-ad643e8cf1a5', '2e98c64d-89ed-47a2-aa2a-9ca7b438c292', '2ff08e00-e7a9-409e-a4a9-fa11ce3a95cb', '30e46628-ecbb-430c-81ab-54296e46c135', '31804abb-4dfe-47aa-a6bc-d06c86bcecce', '31f44da7-9201-4940-ad5d-3eb35d5c5b44', '3357326d-677f-4295-a92e-bb013d309747', '3768cb19-9572-45c5-a91a-fa2e18f9399d', '381d65e2-0cba-407d-b223-119675275466', '3c66370b-7b1f-47cd-8953-30666001d392', '3cb40a73-ec4e-4c9c-903b-a277e51de33a', '3d4b806a-8d94-492d-a80b-4b0408b03e30', '3d66ece3-eb13-4eda-a857-78cc6faa6d9a', '3eb8a4b9-9fd1-41e9-b9e1-596828567801', '3fea8b84-6537-4579-8301-1d97d0d81cee', '402ef1c5-ce9f-4b93-881d-8ce1c4435914', '41402dfc-96e8-4707-b9d8-9504df098a7e', '43701cb2-633c-4db0-b6cb-a6158cd6a5ae', '44a0dfa5-9b0a-49e6-aa17-3f71a6a96e52', '44c0aebf-b933-4b2d-83bf-8aef34707e1b', '44dc9d64-4739-4791-8852-bfcb6eafac94', '46224678-cabe-49a1-82e8-6254962775b7', '4660d901-4bbf-41fd-b202-e109ca2e4040', '466b3ddc-a5c5-475e-99db-95b06c5e3d91', '476e0d82-208a-444d-9f3e-e0a51f6a09b2', '47985aa2-4617-4636-bc00-0bc8aab45841', '489f0922-77f3-4244-ae45-cd24c6465eee', '48b0025c-8770-4bb1-aa92-2bc4a30a130b', '49c84b5f-fa85-4f86-b0df-2953b95a46fb', '4a57943c-48e7-4f7c-8f27-06eb844a6eef', '4a89d18e-f7a1-4054-abeb-e188b5fa64a7', '4bc0320f-838e-4019-b051-755a207c5bef', '4c89c27d-b00d-4972-a641-bacf00fbb6e2', '4d8fbb74-71e5-49a2-8744-f4aefa0d09fa', '4e6d18d3-2191-4916-932b-e0484627e5f2', '4ecf1e74-5ee2-4e23-b4e8-4709e100477d', '5017937e-542b-4761-b98f-b8712a6180b1', '52fc56d8-e6ca-4a82-b35d-5402c6849aee', '541388b0-8435-482a-98d1-5b508f22dea2', '547c3740-609c-4873-b4dd-84dd777d18c5', '54b4a0f6-3078-4ba4-bb75-85fa8ec0a96a', '579b3406-b365-49ee-ace9-b95f095a062a', '5917929b-408c-4787-959d-fc0df5cccee7', '59d01bfb-b9eb-4b37-93b2-8a4f6947b95f', '5a2ccfb4-f87c-4354-88dc-93b75a8f85da', '5a632b62-0670-428e-8a08-7fc705a4ec81', '5b915d29-4ebe-4eba-a439-8566c82f3782', '5bb8fe0b-f876-4dba-a6b1-0c3446144948', '5c6c47af-54e3-41a0-9710-dbb76f096d8e', '5ce786dd-51b9-471e-a1d9-f4b209e1be09', '5cf6b4b6-ee0a-4b36-ac99-11e1189d2812', '5d25e9bd-c939-45fb-b458-05eb529262c1', '5db489c9-aa7f-4e80-89b8-cd740158c9cd', '5dfc66ef-492d-4a43-bf64-92e3071322b0', '5e9ea8c0-9bdc-4830-b819-b9d5f4c08571', '5f725ba2-5f41-4c84-b412-56bd6848ee0f', '606383cd-b6b1-4b48-ac5d-93b005eec71b', '622d7285-5def-4c5e-b926-929515306f97', '628b0b08-102b-4831-b4fd-a65b4ea99e06', '62c40800-4c68-4460-8495-d71e037f2c1f', '62e1e22b-ffae-4e0f-996f-315dd61efd8b', '6483bb84-d03f-4f26-b53f-f1688f84f921', '64da5471-64e4-4df3-99da-00b350e5dfc3', '6529e204-895f-4a76-99b0-68c9fb493e1b', '66ab679d-dc1d-4158-aa09-ee26fd590283', '677cba84-b337-40e1-9d59-8d8102a9dd90', '69302d5f-2424-42d2-9d8c-c9d6779b6587', '6ad3605b-493f-4a05-b7da-99a312c60d18', '6b17c920-2878-435a-826c-fb80056dc21b', '6b480e24-75e8-4eb0-bab6-efee2f896d7f', '6c9e862f-b5b1-4cd1-9ef3-15df7ae38fa0', '6cdebd2f-516b-4a46-a507-b4ebc776cecc', '6dad6207-7889-4b3a-9d8d-f3071ed31fb1', '6de5bde6-bc7c-402e-81d2-301bd0ec34f6', '6e3e9cb1-5bbf-4834-99ff-94dfe1d356dc', '6f09d93c-7de3-4ee3-b389-b5eea5b55aca', '6fa9fa5d-997f-4d67-a745-c6c2b1d77e7e', '704d801a-f278-4ab3-b48f-58d84d8e75b4', '707a2a58-de9f-4bfe-9c63-cc6f6298df52', '70c0ea13-6757-4aec-83bc-bbb06b3d7600', '71a8b726-e882-4ead-b518-73f3663c7325', '72e049ba-fe01-42ff-b585-a859ae8f1276', '732c56e5-9f7e-4d09-b5e7-f3d342da5fc9', '74a203e8-a9f6-4c33-809f-5ab4ee857b86', '74e5407d-3c5e-485f-9cb4-ff77ed7c302b', '74e59006-9fff-48e6-928a-eff6a737c1ff', '74f3ed48-53a1-4a6c-9386-a3e3d35f257b', '752f5686-b1eb-4fde-99d8-366fc25a7e75', '756ee6c2-2cf4-4783-b9e1-3cfc53dcc7cf', '762d7d8a-06b9-46bb-9368-4dff989c41a5', '76381925-6320-41f9-9338-0882c13dac79', '76dab224-0946-4d4f-aeff-76d059b4d0f0', '77a76883-8944-468a-9e57-aeaa4489513a', '7830aa00-388a-4b04-aa7e-094d051f204d', '7915df34-7c79-4648-9080-268f10dcce91', '7a750465-12c2-4146-9103-21eca4d02807', '7b0dfcc4-7c7b-479f-b49e-b05a95d66b54', '7dccf05d-4e4a-4822-a4af-22c97e7c4c75', '7eb2afc0-d65f-4851-83f8-4ba8bb9670da', '7f660509-b449-4869-b8f7-eab011f364b5', '801841b7-2db3-4bad-9ab8-37d6dc70e49e', '80a4c556-40a5-4aa5-826b-be7ebd159be5', '813b0487-716c-45c9-9b3b-b9cab93ba11b', '8242fac3-aa58-41b9-8fbf-40e80aa6d4a3', '82f081c9-5da1-4d77-a7d2-2de1d6d7b0d2', '834745de-0aca-4990-97ea-bd1f4cb0f5d5', '840863a4-b60d-4e9e-911d-125431a79e62', '840a33fe-879c-4793-8540-13b97b541b9e', '847354a1-0f3a-41cd-b0d1-9344ff2c05d5', '849b4817-ee5f-4e22-8c9a-9c513e77ddb7', '84c3440c-92b6-496e-b3b3-5e565391c3c0', '851ded28-abdb-4ea3-b9ed-12b2916f2d5b', '85f70e8c-3464-4d71-af37-37fbc2d5befa', '86d3fd63-3f5f-4a3f-88e8-1619de66e0a8', '8777bfbe-5204-431b-9f38-37842c4b6206', '88aaf24c-39c9-45a4-a94b-61a4b2a7ac0e', '89b759c0-50e5-4b6d-962d-487afa0bbb5b', '8a070822-acbf-4ee0-94ac-3380da5ca4c7', '8d2e17a0-f9f4-4392-9cdc-a3a1162f1bc9', '8d86cf0d-6407-456f-825a-02df71af9025', '8da08348-8c50-4c81-9d63-649a69a7e92a', '8e451da0-8c4e-47f4-ab5b-5d6e98a06baa', '8fe0a813-b68a-493b-9ebb-0286001a43e5', '908545b9-c53a-4726-9dfa-7bc2e116336f', '90bea9a5-0f6d-4532-a9e6-ce5e0f7db4a6', '91336ac2-5e79-4039-bbf6-0351446debe5', '91f1249b-5683-4529-941d-c960484d740c', '9223f2c6-ab6d-41aa-b97a-0b13ddaa517b', '92644528-3b17-48b1-8dbc-30df56b91a75', '94e3c4a6-24fe-4e15-922b-dacf72e64f5b', '950581ca-d4fa-45b8-964a-e44e76a2e27b', '95216903-8e3f-4a86-9788-9fbbc86e8ce6', '960ed9fe-3c1d-4708-adde-42c9f7f1a2da', '972fbce6-bfb3-498f-ba4a-89ebce62b9f1', '977d8f60-77eb-4b6b-a82f-8722cc76b1c1', '98f8d35b-165d-4c68-8143-5ffa505a9654', '9938ea97-51d4-49c0-83f7-afd9c474dfb3', '998d4ae9-e57c-4c8a-91c9-aeeca0cd6a3d', '999c0450-1fb4-4d79-b0b0-bf8b5fa02a8d', '9b4bddae-5531-4783-8695-e000a17e7c90', '9d2b5a14-3925-4ad4-ab7e-457e7e17e573', '9dbfe7f8-8f68-4483-b497-9c7c01dd9506', '9e7797cc-984e-452a-bbcc-f9cb74239d62', '9e9c725b-6f87-43a4-bdac-74b9622682b8', '9ebd358d-b8da-4aae-a949-df700b17cb95', 'a06abcc1-6d36-4019-abcb-bdef2c8a0f6d', 'a17f67c4-7953-4df2-8752-ac629882211f', 'a35e1a31-2730-4391-9ffa-f751aaa84b99', 'a777e7f8-8b2e-48e8-81d6-213046452bc7', 'a9e4f256-ed69-45b1-b1b2-00c88f2cf63e', 'aa201b5e-e42f-4f6b-aa60-218189025517', 'aa6a5de2-844e-48bc-be8e-e47615330777', 'aa852480-8682-46ae-8454-783e34df08a0', 'aab2c2c5-ea5e-4970-af1c-7af2aacd2420', 'ab039e81-61e2-4406-adbe-aa3353e55360', 'abb6904c-41e2-4253-b19d-3ae984471024', 'ad90ca77-41f8-4e66-a2d7-65a01e59203e', 'adb761aa-3045-4d6e-b580-1c85e944e926', 'ae882e78-e7ea-46bb-ae8f-d93744827801', 'afe0924a-acf4-4ec0-adc7-135cf68fe75b', 'b0de4c96-3f84-4f7f-88c4-f17929b71f55', 'b164164b-19ee-4a9e-9c87-5b87bbe274c8', 'b4345f36-9a86-4382-b462-d72a05f13fe1', 'b468ed5a-a308-42f4-968b-194e67bdd3fa', 'b4fcfb42-078d-4689-a0b6-109a800fad22', 'b674a7d9-3eba-40ad-941c-d9b4de347686', 'b6a3a666-85e5-4f0b-9f31-082d80c08f7b', 'b7b597e8-5d95-4bdb-83cd-a8cb4591f31f', 'b7bbd9d6-6269-4862-955a-d8f738d33eb0', 'b8bf2ed2-3ace-4697-b323-bb8fa0298e22', 'b8d6086d-7c95-4217-8c3a-1257fc39e096', 'bb1993b7-64f5-4224-9304-4467286ebb8f', 'bb82d1b0-5d28-4ae9-9dff-25ae4b717186', 'bbfd496a-c45a-49c5-a213-8e342d5fdefe', 'bcb7921a-cf01-48e2-8f02-03b85bc62571', 'bf79c91a-5f9a-473a-a2fb-e0d0263a48f2', 'bfcef5a7-8b4f-4694-b10b-57e10376d6b2', 'c0b222b0-5923-45a3-b5c8-e79bbc98b38c', 'c16514dd-2376-40b1-bf7f-c4bd5e2a20ef', 'c26064b5-d8a6-4f2c-9625-059796ed9698', 'c2eb42b5-61f7-4e46-827e-101f89890b34', 'c3f7b02e-b8f2-427f-899d-1925b254137c', 'c569854f-f9f9-4bd5-b780-18de45d9f96c', 'c56fe217-4425-4e13-9e67-a30c035b5404', 'c60571d9-097c-4377-bab4-1bb6839a6216', 'c79bacc4-8ab0-447d-a21f-4c12f60adbb0', 'c801dc50-9c0b-4eed-9e75-1ccb765794a2', 'c8ce77bf-26e5-4ee5-b623-32d9aad88921', 'c8d9548c-3114-428b-93f0-c38fa0c839e3', 'ca864853-327e-472e-8d1e-1bf1ace3802a', 'cacdb1db-5a6f-4c44-a818-e11644926116', 'cc146a38-f29c-4827-a79a-33f69bdceda8', 'cc4d4840-dceb-4d16-93b5-3f06a51e02a7', 'cd9cf6f6-7ea8-4b77-be1d-a3b88705f837', 'cdd0fc07-fe9e-4c93-bf20-66ad3ca07535', 'cdec9712-2587-4846-848e-feb44459ee79', 'cf962069-f2b1-4d0f-9ab9-b569cbd54bd8', 'cfa44afe-1b23-4f4d-a071-aa75d4af9338', 'd00e1c0c-c143-451d-a89f-7d058b962620', 'd08b3c3b-49a3-4862-89e5-842bb7f707db', 'd2699cb6-2876-4741-b567-3a9ca825513b', 'd332052b-7a98-44aa-9751-128ccc7b7827', 'd508fca9-d016-4e88-8e0f-1d83c11b1e6a', 'd60a1e5e-fa37-4ca3-b5eb-db36781e3476', 'd72ce650-3643-4bb0-828a-88a32eecaf58', 'd7c0bf0c-4f88-435c-b876-f3bfbad4a2c8', 'd9110b10-0fd4-41c1-b60a-39a34dbd673a', 'd983eab6-399f-4a14-b42f-04c59dc1f10b', 'd992f66e-0e70-4f7d-b928-db396cb4fa79', 'd9a78f3a-094f-47be-9793-129765cdede1', 'd9ead57d-854e-416f-af0f-e7b2730e6df5', 'da1cc195-09c1-4052-b51d-fe463d9c0fb8', 'da5a8726-0ab1-4f8d-9caa-4e91ae4ff463', 'db02061d-0617-429d-98f3-8e416c342f82', 'db34e1f1-e86b-4963-8794-601618d8c3f8', 'dbef05cc-c2a4-43e8-93b1-a3477b1e60d2', 'dc8eabb3-e401-4d37-b7a0-5a581b3a138f', 'dcf6752d-1973-43d0-b3f3-4541c67902c5', 'df77961e-0284-4316-9e17-295ee5208e72', 'e03eefc7-2dc7-4559-b6ae-a4721ef7aad6', 'e1dbdba0-91b1-487a-ba5b-1b4a2ae1a350', 'e2f2b193-53ee-40c3-9b0b-cbe18d5c70e2', 'e350f9bc-c33f-47e2-bd5e-e73a0208a692', 'e4402094-b2aa-4636-a823-4c999f87d3ea', 'e4a3dcc4-af4c-4cb8-88a5-80438b46eb33', 'e52e8d8e-d51f-4c4a-b4d4-55563b9aefa0', 'e6bf18dd-2c6f-45fa-909e-23d2a7167cd2', 'e6d7a85e-b8f1-4328-a5d1-bc4531a692af', 'e77d712d-f7d5-4fe7-bdaa-a40006d2dbba', 'e7be8ad4-0664-44fc-a424-59b4d5d32549', 'e7ef068f-a6f4-4ed3-a7b5-fff9fbac3f39', 'e87e358e-87c0-40a0-99be-e9fce08779b8', 'e8b5adf1-ffb3-4971-a857-048103ce4b55', 'e8dfc9b0-a467-40f0-9e7c-fa8a2da926c9', 'e9ad4d2a-221c-4791-a4e2-ee1d4f026dea', 'eaa9430d-4db8-49d8-9d7e-f68ec6a7b73a', 'eb32ba7f-7460-4694-aae4-1675d84aafda', 'eb9d5367-44e0-40af-81ad-bb090d7eb567', 'ecb35bab-3785-4110-aa3b-5e6766c0322c', 'ed8d458f-4a15-4aa9-9b17-9dd455ef6d53', 'eecde00c-5d21-451f-8d64-6fb8de728372', 'eeda01c5-23e6-47ab-8f2e-93b5742bb55f', 'f2412f9e-551c-4581-807c-14b6c6648a40', 'f25149f6-4f1f-4386-bd49-9ef2d2414334', 'f2de2b5b-1330-448a-a0ef-58469e25d7c8', 'f37894c5-34e8-49c1-9fe4-bb13af54cff7', 'f3903cac-b7db-432c-a767-70936f4572f9', 'f3b3dcdf-e93c-449d-8b7f-55c23efc086e', 'f3f9ca7d-5d6f-40e4-af43-5296af79b9fa', 'f4b84b1e-db77-4dd0-a874-01bfa8c5eca0', 'f5e9b814-9847-4f95-aeae-ef90adb66b00', 'f6af927c-a6d3-4ae5-910e-be128206e27e', 'f754288a-eb25-444f-873e-290df913df53', 'f898d0ed-3acb-4fd6-8d82-7b913a7c11a8', 'f89baa48-93fe-4f81-895e-c7ccc28218d7', 'f961e9ef-47ab-466a-8455-56b38c9e8cb2', 'fadf5b27-f282-4a53-abb8-e109bb383589', 'fb67a474-4e77-470f-a4d0-0ea99ff301e0', 'fbdcedca-d74e-4280-9d17-0edb16391c8c', 'fc19ebc7-1333-47c5-b9a7-15c327dd80e9', 'fd24c294-6c2e-47a6-9199-ac2f24684ddd', 'fdf56905-cacd-49bb-8dff-f984d5e3a446', 'fef37120-78bc-4abd-8b66-4a34be0de916', 'ffb39cd2-e3c5-47a2-9b05-ece5a5deb451') GROUP BY tp_4over_product_group_option_master.option_group_uuid ORDER BY prd_grp_mst.order_by ASC 0.0188 sec

68. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 1 0.0038 sec

69. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 3 0.0037 sec

70. SELECT shipping_method_id, directory, shipping_pcalc_config FROM shipping_method WHERE status = '1' 0.0003 sec (Cached) 2828f25f39945c0ea5663ab9cbe6de3c

71. SELECT * FROM address_book WHERE user_id = 0 0.0008 sec

72. SELECT * FROM countries WHERE countries_id = 223 0.0022 sec (Cached) 736a3a216c657882dc62d87c1b72e3c0

73 68. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 1 0.0057 sec

74 69. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 3 0.0038 sec

75 70. SELECT shipping_method_id, directory, shipping_pcalc_config FROM shipping_method WHERE status = '1' 0 sec (Cached) 2828f25f39945c0ea5663ab9cbe6de3c

76 14. SELECT * FROM product_settings WHERE product_settings.products_id = 419 0 sec (Cached) b5392ff51fb82fe7e7070eb80d8bc35e

77. SELECT count(countries_id) as total FROM countries WHERE status = '1' 0.001 sec (Cached) 5165b08688a12e4d085eb958c7b4b677

78. SELECT * FROM countries WHERE status = '1' ORDER BY countries_name ASC 0.0007 sec (Cached) 026b57ad4d90ed36205756dfbde00bf1

79 14. SELECT * FROM product_settings WHERE product_settings.products_id = 419 0 sec (Cached) b5392ff51fb82fe7e7070eb80d8bc35e

80. SELECT products_predefine_print_file.*, products_sizes.default_size FROM products_predefine_print_file LEFT JOIN products_sizes ON products_sizes.size_id = products_predefine_print_file.size_id AND site_language_id = 1 0.0006 sec

81. 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 ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0008 sec

82 36. SELECT type, page_id FROM cms_pages WHERE page_id IN (10) ORDER BY cms_pages.sort_order ASC 0.0009 sec

83 35. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE') 0 sec (Cached) bbf87f8045e8db0bf5318438fb787874

84. SELECT SQL_CALC_FOUND_ROWS products.sort_order, products_description.imagename, products_description.product_description, products_description.products_title, products_description.products_id, seo_image_alt_text.image_alt FROM product_kit LEFT JOIN products ON product_kit.product_id = products.products_id LEFT JOIN products_description ON products.products_id = products_description.products_id AND products_description.site_language_id = 1 LEFT JOIN seo_image_alt_text ON seo_image_alt_text.parent_id = product_kit.product_id AND parent_type = 'P' AND seo_image_alt_text.site_language_id = 1 WHERE products.kit_type_id != '1' AND products.visible = '1' AND ((products.user_type_id IN ('0', '1'))) ORDER BY product_kit.kit_id ASC 0.0001 sec (Cached) fb5419a6d905ab8bbb1daeb2c1b4470b

85 37. SELECT SQL_CALC_FOUND_ROWS ps_category_id,parent_id,name FROM ps_category WHERE name is not null ORDER BY parent_id 0.0008 sec

86 35. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE') 0 sec (Cached) bbf87f8045e8db0bf5318438fb787874

87. SELECT SQL_CALC_FOUND_ROWS ps_category_id,parent_id,name,category_icon,category_header_content FROM ps_category WHERE name is not null AND ps_category.status = 1 ORDER BY parent_id,name,ps_category_id 0.0009 sec

88 36. SELECT type, page_id FROM cms_pages WHERE page_id IN (10) ORDER BY cms_pages.sort_order ASC 0.0006 sec

89 37. SELECT SQL_CALC_FOUND_ROWS ps_category_id,parent_id,name FROM ps_category WHERE name is not null ORDER BY parent_id 0.0009 sec

90. SELECT * FROM site_currency WHERE status = '1' 0.0005 sec (Cached) 613b110f15bfd6188f372b9124b62c8e

91. SELECT SQL_CALC_FOUND_ROWS banner_image.*, seo_image_alt_text.image_alt FROM banner_image LEFT JOIN seo_image_alt_text ON seo_image_alt_text.parent_type = 'B' AND seo_image_alt_text.parent_id = banner_image.banner_image_id AND seo_image_alt_text.site_language_id = 1 WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2025-04-03 10:27:05' AND banner_image.banner_end_date >= '2025-04-03 10:27:05')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](419)[[:>:]]' AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC 0.0011 sec

92 91. SELECT SQL_CALC_FOUND_ROWS banner_image.*, seo_image_alt_text.image_alt FROM banner_image LEFT JOIN seo_image_alt_text ON seo_image_alt_text.parent_type = 'B' AND seo_image_alt_text.parent_id = banner_image.banner_image_id AND seo_image_alt_text.site_language_id = 1 WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2025-04-03 10:27:05' AND banner_image.banner_end_date >= '2025-04-03 10:27:05')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](419)[[:>:]]' AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC 0.0008 sec

93. SELECT * FROM breadcrumbs WHERE status = '1' 0.0002 sec (Cached) cfc88bdad1d3c808679011331b88f107

94. SELECT products_description.products_title, product_category_description.category_name, products.category_id, product_category.status, products.multiple_category FROM products LEFT JOIN product_category ON product_category.category_id = products.category_id LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_category_description ON product_category_description.category_id = products.category_id AND product_category_description.site_language_id = products_description.site_language_id WHERE products.products_id = 419 AND products_description.site_language_id = 1 AND products.predefined_product_type IN ('0', '1') 0.0022 sec

95 14. SELECT * FROM product_settings WHERE product_settings.products_id = 419 0.0001 sec (Cached) b5392ff51fb82fe7e7070eb80d8bc35e

96. SELECT * FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN measurement_unit ON products.measurement_unit_id = measurement_unit.unit_id AND measurement_unit.site_language_id=1 WHERE products.products_id = 419 AND products_description.site_language_id = 1 0.0011 sec

97 14. SELECT * FROM product_settings WHERE product_settings.products_id = 419 0 sec (Cached) b5392ff51fb82fe7e7070eb80d8bc35e

98 53. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=419 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC 0.0007 sec

99. SELECT product_master_option.`master_option_id`,
product_master_option.`option_key`,
product_master_option.`options_type`,
product_master_option.`status` As master_status,
product_master_option.`pricing_method`,
product_master_option.`linear_formula`,
product_master_option.`weight_setting`,
product_master_option.`price_range_lookup`,
product_master_option.`formula`,
product_master_option.`sort_order` AS master_sort_order,
product_master_option.`prod_add_opt_export_group_id`,
product_master_option.`custom_txtbox_opt_id`,
product_master_option.`min_default_value`,
product_master_option.`presentation_settings`,
product_master_option.`master_option_tag`,
product_master_option.`custom_weight_txtbox_opt_id`,
product_master_option_description.title,
product_master_option_description.description,
product_master_option_attributes.master_attribute_id,
product_master_option_attributes.attribute_key,
product_master_option_attributes.default_attribute,
product_master_option_attributes.setup_cost AS attr_setup_cost,
product_master_option_attributes.multiplier as attr_multiplier,
product_master_option_attributes.weight,
product_master_option_attributes.production_days,
product_master_option_attributes.attributes_image,
product_master_option_attributes.sort_order AS attr_sort_order,
product_master_option_attributes.status AS attr_status,
product_master_option_attributes_description.label, products_additional_option.`sort_order` AS option_sort_order, products_additional_option.`status`, products_additional_option.`prod_add_opt_id` FROM product_master_option LEFT JOIN product_master_option_description ON product_master_option_description.master_option_id = product_master_option.master_option_id AND product_master_option_description.site_language_id = 1 LEFT JOIN product_master_option_attributes ON product_master_option_attributes.master_option_id = product_master_option.master_option_id AND product_master_option_attributes.status = '1' LEFT JOIN product_master_option_attributes_description ON product_master_option_attributes_description.master_attribute_id = product_master_option_attributes.master_attribute_id AND product_master_option_attributes_description.site_language_id = 1 INNER JOIN products_additional_option ON products_additional_option.option_key = product_master_option.option_key AND products_additional_option.products_id = 419 WHERE product_master_option.status = '1' 0.0011 sec

100. 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, products_description.imagename FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.products_id = 419 AND products.kit_type_id != '2' AND products_description.site_language_id = 1 AND products.visible = 1 ORDER BY products.products_id ASC 0.0009 sec

101. SELECT option_id FROM products_mask WHERE product_id = 419 0.0012 sec

102. SELECT external_services.directory FROM external_services INNER JOIN external_service_section ON external_service_section.section_id = external_services.section_id WHERE external_service_section.section_name = 'Digital Marketing' AND external_services.status = '1' AND external_services.corporate_id = 0 0.0002 sec (Cached) ab7c4575a9b273fe5a0f41dc32ef7629