Catalogs (Print Marketing Services)

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

2. SELECT ip_address FROM ip_address_management WHERE type = 'B' 0.0002 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.0014 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.0002 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.0009 sec

6. SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'etcmarketing' 0.0004 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.0005 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.0007 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.0007 sec (Cached) c50417c897b06607152835b8442622ef

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

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

12. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id FROM products_description WHERE products_description.product_url = 'catalogs' 0.0011 sec

13. SELECT * FROM product_settings WHERE product_settings.products_id = 425 0.011 sec

14. 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.0012 sec

15. 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.0009 sec

16. SELECT name,parent_id,ps_category_id,category_url FROM ps_category 0.0019 sec

17. 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.0002 sec (Cached) 04999c418c66ee0ce95a5faeceb9b7ef

18. 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.0016 sec

19. 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

20. select product_url,ps_products_id,product_name,product_code from ps_products 0.0094 sec

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

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

23 12. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id FROM products_description WHERE products_description.product_url = 'catalogs' 0.0006 sec

24. 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 = 425 0.0008 sec

25. 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

26. SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'product_info' 0.0007 sec

27. 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

28. 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.0009 sec

29. 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.0004 sec (Cached) cfe806c3379e8cc2d47671cefc0b5152

30. 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.0008 sec

31. 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.001 sec

32. 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.0016 sec

33. 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

34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE') 0.0004 sec (Cached) bbf87f8045e8db0bf5318438fb787874

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

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

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

39. SELECT * FROM external_services WHERE external_services.directory LIKE 'foreover' AND external_services.corporate_id = 0 0.001 sec

40. SELECT * FROM tp_4over_settings WHERE setting_name = 'default_markup_4over' 0.0005 sec

41 12. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id FROM products_description WHERE products_description.product_url = 'catalogs' 0.0005 sec

42 13. SELECT * FROM product_settings WHERE product_settings.products_id = 425 0 sec (Cached) d49c590792390bfd0001dc5ae5ca9215

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

44. SELECT price_defining_method FROM products WHERE products_id = 425 0.0008 sec

45. SELECT SQL_CALC_FOUND_ROWS category_uuid FROM tp_4over_category WHERE category_uuid = '8977fb0b-5ebc-47e3-bd74-132204c203ea' 0.0007 sec

46. SELECT forover_product_id FROM tp_move_ops_product WHERE ops_product_id = 425 ORDER BY default_selected DESC 0.0008 sec

47. SELECT * FROM products WHERE products.products_id = 425 0.0009 sec

48 13. SELECT * FROM product_settings WHERE product_settings.products_id = 425 0 sec (Cached) d49c590792390bfd0001dc5ae5ca9215

49. SELECT layout_name, is_mobile, sidebar_display, is_default, IF(FIND_IN_SET('425',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 '%,425,%' 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.0084 sec

50. 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 = 425 AND products_description.site_language_id = 1 AND products.visible = 1 AND ((products.user_type_id IN ('0', '1'))) 0.0014 sec

51. 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.0008 sec

52. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=425 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC 0.0016 sec

53. SELECT * FROM products_sizes WHERE products_id = 425 AND visible = '1' AND site_language_id = 1 0.0011 sec

54. 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 = 425 AND orders_feedback.status like '1' 0.0008 sec

55. 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 = 425 OR duplicate_product_id LIKE '%,425-%') 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.0014 sec

56. 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 = 425 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.0011 sec

57. SELECT * FROM products_related_products WHERE products_id = 425 AND products_related_id = 0 0.0067 sec

58. 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 = 425 AND products.visible = 1 AND ((products.user_type_id IN ('0', '1'))) ORDER BY rand() 0.005 sec

59. SELECT products.predefined_product_type FROM products WHERE products.products_id = 425 0.0042 sec

60. 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('425',c.product_id) AND c.created_by = 0 AND '2025-04-03 10:28:10' 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.0019 sec

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

62. SELECT * FROM tp_move_ops_product WHERE ops_product_id = 425 0.0006 sec

63. SELECT SQL_CALC_FOUND_ROWS * FROM tp_4over_products WHERE categories = '8977fb0b-5ebc-47e3-bd74-132204c203ea' AND default_selected = '1' 0.0063 sec

64. 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 = '029d1fb8-d178-44ce-891e-119f51924513' GROUP BY option_group_uuid ORDER BY tp_4over_product_group_master.order_by ASC, tp_product_price.product_baseprice ASC 0.0018 sec

65. SELECT SQL_CALC_FOUND_ROWS product_uuid FROM tp_4over_products WHERE categories = '8977fb0b-5ebc-47e3-bd74-132204c203ea' And status LIKE '1' 0.0029 sec

66. 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 ('009dc4e9-b2fd-4b99-9922-0c7329892da7', '020b968d-37b0-4073-afc4-e954611ba773', '029978ce-90ae-4721-bf52-12063502f34e', '029d1fb8-d178-44ce-891e-119f51924513', '02dd2751-e65a-4f39-8b83-d44d170c598f', '02f8a7c9-6fb1-4a52-a6b7-3e67a741d0c1', '046703ec-d304-4055-b0dc-c3305520cfb5', '050ab30f-be1d-4a1a-be74-dfd82790c83e', '05ea18ab-19a7-4823-810f-4d476461d72c', '0641b2c4-8c05-4870-9dcb-644feade8424', '06d876d6-5b83-429d-95db-4beb30e00af6', '072a6866-249c-4d9d-ba58-43e82db4e4f3', '07301c72-895d-4cac-b73c-7664104075f8', '079bcb87-df5b-4338-b134-be9fb8b1920a', '08ed2732-14e1-44e1-aa81-4463fae72565', '0956ed27-328e-4de0-8f22-284ac2168ba6', '098258ea-26b9-4dc6-a311-0b1e574d0aae', '0a235d9e-36e4-4089-b8e8-513406f7f604', '0a8a820a-9007-4737-8837-f3bbfd23c31d', '0aca9e93-571d-4bb0-9f1b-a1312e605ee5', '0acb736b-24a1-4df6-9965-e25954fbef9e', '0b8a1406-6972-42cb-ac69-c7539b43ce21', '0bba2760-79db-4959-bbfa-410ebf015e3f', '0c51277c-4f8b-4552-b36c-4c3a7c5c6ba3', '0cf0b6eb-4c1a-4483-87d0-b139780fd9b4', '0d117f4e-689d-49f9-877b-f5ef4ee5d16e', '0db7d52a-a620-485c-8ffd-0f0826cbf25b', '0dbdd38a-7163-4b40-9dea-9ae7e0e9bc81', '0dc63e56-b2a8-4850-8a29-8bf9bff13872', '0df099fc-e51c-441c-a8e1-adc916a631a7', '0f671276-0d29-41a3-8f1f-a04b38ddda6d', '0f87bbfa-1b58-4d88-a181-305ee4f56a4e', '102c1047-e6c0-4b72-8064-7f0efbf36ca1', '1159d8a7-ff99-4ebd-b15e-f9b36a1a6bbc', '11e6df49-d763-490a-b4a8-ed7cb441cc75', '12a364a4-d084-4905-8368-412011f1a33d', '13ae9488-54d8-4d79-be77-655259849eda', '1467ad12-2d4e-4e73-bf8d-64dfdc312ceb', '14e9db71-75aa-4aeb-83e2-e76192e19afa', '15cd814d-ce41-42dc-8bbf-19802707bc84', '15d49654-c647-4fe9-9ad2-353d93f37794', '15fd92fd-906d-46dc-be97-a141e49c4ae8', '16037b34-6c70-4aa9-8ae8-f0e8dfdcea6e', '17241e3f-27e1-44cf-abab-7f75e23b27f8', '1755fbfd-db43-462e-a645-41b37e95570b', '181c3c1d-b767-4d3c-af6e-d6e5c67f9c6c', '18c5e060-3b7e-4103-affd-1700174c2d8a', '1a936489-b264-4e2f-9bae-8835898ab5be', '1bc1d585-b268-4e27-8f25-c0f2bf1ccacf', '1c1038c4-37e5-4fbf-8aa5-28441130e2ae', '1cfa877b-dce9-4350-9bc3-48bcd4154a65', '1d3ab3a6-eda9-4603-a30e-e0dbec9fdd6d', '1dbe5f78-a4ec-49d2-8449-d8d6a24848e3', '1dd63456-697c-49d3-bd16-5e29e29cbac7', '1f7a255f-b708-436b-877d-6bc485015660', '1fc2eb66-354e-4a9e-8dd8-fb5bacda459d', '237638c8-d8a6-4cd7-9887-1b1fb8dee7ba', '237d2a69-1dd5-4c55-b034-b864f15f4961', '23852a9a-c33f-4461-b666-35b75167e914', '244a7357-9124-4e25-80fd-deee840375d4', '24d23904-494e-4ef2-805b-72c62f83fb8e', '24e28318-d2ab-4a92-8897-3f66ce65ecf8', '2651694f-c6bb-4adf-b725-edba6bafbf24', '26a2df6c-717f-4d31-a8f5-ca4efc1c0f41', '290e69a6-32e8-4037-b876-75daa18bb35f', '29f5680a-cd8c-4efd-a5ae-f2862358ec19', '2a721bdd-66bc-4e8f-bb37-db1718595d30', '2bf39977-4300-4802-a1c6-5bbf3a0dd05c', '2d34a8e1-236e-4c57-8107-cb4a07550613', '2d6d4b7e-6161-4135-a95b-9a3f027ded4b', '2d7a44a5-e375-4033-943f-2dcd76fe83c6', '2ed0d5a8-ecf3-4bde-b69f-974c1b4a533d', '2f371e44-e914-4954-bca3-89fb402302f9', '2f5df85a-1878-40c8-8e34-5c56ce7a2dcf', '3010fb77-fe1c-406a-a1fd-dcfe50944c03', '303d905a-cdbb-47d4-ac4c-5aa5d4c79181', '304dcd72-a07e-4047-9db8-e78908ea55ea', '31cc33d8-6d06-4d72-9f2b-e99c68f0761f', '31ea2592-f23c-49c8-ae0e-53b7311009b6', '3209a85b-a4cb-4f83-ac1b-c2cfb42c14b7', '3298d7de-1757-4732-987d-1c96400974fc', '32d8333b-c9b7-40e9-9e79-287522c4adab', '335cfd2f-68bb-4f2b-a470-7d9428a2f2c8', '33f4bb8b-d3e2-4532-babb-9902efc23807', '3436d7e8-7283-4bb3-9447-5163309b4d87', '3515e1b2-46bb-47b7-b7bf-23888d435f32', '351a570b-b97e-4c12-999d-3b1caa756e87', '35a44b0d-d9b1-4e84-a754-8f7044218a5d', '3632b487-3696-482c-84f9-b728bc7014ad', '36d59056-1dbe-4bcd-9fd3-e9f5b7700066', '3736f34d-94a8-4784-8235-9e8e729f2efe', '37408fbf-911a-43ca-a8b9-8ec22ac6eb18', '3892a07f-f7cb-4c0b-8429-2436506fad37', '38ef2181-b7ba-4671-883c-a64cce99c211', '392650a3-69bf-4ebd-8853-ecc73e9bcd0c', '394fa939-e9d1-4704-ad18-3893c46e4d26', '3b342306-36ee-4043-bfde-51ec60b07bc5', '3b35cb1b-425a-4d31-9737-193a90d87d56', '3b802edb-c996-45fe-a778-9a9a3c8b9bcf', '3babc139-6db8-46af-a1c0-3d5ddaaa992a', '3d0bf969-4028-4f22-ad96-e83f1a4b0da5', '3d0de239-020a-4f53-a8fa-c7a4367993fa', '3d489dbf-d370-4d71-ac70-c0e3bbbe79ee', '3e0a3e46-63b5-4653-8fe7-427fc5608f3e', '3ea25437-16c0-4d08-961e-ede1efef5f33', '40ad8b17-bba6-47b8-b945-64d32db6b250', '40eeaac8-86b0-425c-ab20-7ab4bb21c42c', '42d90ecb-e1c6-49c1-8591-c741b6d350eb', '42fb1f0e-9fbe-40b1-91ed-5a4207cd56a3', '42fd255c-48bf-4993-9f91-76390b29d3d2', '4307713d-a855-4f4e-8292-e91d4b30e5cf', '44044026-1967-49dd-9b13-1ae80f6f2526', '446987b0-66c8-4af0-9984-13a735a62a38', '4556b2af-5188-4a3d-851b-024023ee73fc', '47539cb8-17ee-4054-8cee-fc4ae181a532', '478c35ec-ff87-4e52-8cfb-957fcc5cdb2c', '47a809cd-c45e-4951-b8b1-82a617187587', '481e6be0-c413-4043-84af-5534c71b898a', '482b779e-99a7-40ce-a43d-5d3c3e293efa', '4888a69f-1dc3-4b76-8e67-4a2e41d041c9', '48d47666-378a-4342-98ef-909417f06bfc', '48fd6b04-e54e-4c61-a293-404026701859', '49fc784c-493a-4f50-a871-a1abeb92e5a3', '4a25b8d8-47d5-4ddf-b5a1-2391ec5a13ea', '4a794cac-a8f3-4e62-81f5-098b8a3ffb33', '4b9f0410-c5ea-4455-845e-48157ebbb0fd', '4c633505-b1d3-4a49-8ee7-cd887bdffbba', '4c907e3e-d623-438d-ba80-b7ed7944e504', '4d2d6dd1-d2ea-4c4d-9317-77e6711f6616', '4e688fbb-6a1e-468f-ba65-da8d19bff74e', '50a96592-324c-4bf8-af0d-d089b5bd308b', '521fb3d6-7f57-4871-b085-c82a4689931d', '52a37de4-f208-4d4f-b9c8-a1749514c38e', '53553b89-fed7-413f-9207-62bde0590de1', '53af5fc6-411b-4ef9-b7c7-961ec7f624b9', '5510e4fe-e69c-43d4-b30b-75bc94e0e558', '555aceff-b416-4cce-886b-832d3eb0972f', '5567f650-3128-42c0-8aac-764b66c50605', '55fec12f-59f9-4ce5-89c4-901d3de44338', '56318fe1-7e16-490f-af87-b3e50616025b', '57ce96e5-dab8-4154-ada9-77cb14f15c61', '5808a43c-61c2-4d34-a4c8-d7c156f71193', '584348ac-49b3-477d-bc61-89d72c58362c', '590b127a-3c9a-4e9d-880e-3dd14ef4caf3', '5965a31e-9663-4bdb-979d-e54501594c6e', '59a6ad4a-3f14-4bf0-b2f8-92d944d24a0e', '5a384828-16d7-42ca-83a6-ec7a889842d6', '5b77ef2f-f8e4-45f0-9fae-6858a0362b2d', '5beed3af-6bf7-4d37-8dfb-5bfb2d9b5906', '5d110048-f728-4e85-824e-6ac555d0f9a4', '5d49ed4c-f32a-4985-a031-359d1a6730c3', '5dee306d-6c67-445c-b63e-e43bb7b75d81', '5f457827-e70a-488a-a26c-669bff2d5fbc', '5fbcd8d5-87d7-4ded-b04e-10c8834fdd12', '5ff05f95-d9a2-4910-acc4-597f3e3c20bf', '6028b3a8-342f-4c3c-b31a-c9e91e338817', '6037dfbc-7eb6-4e2f-af36-4da372332cdc', '60716795-5a9a-4d13-8d77-590c48116eeb', '607970ea-d723-40ad-97e5-b28124a457fb', '608dc5ac-ec37-4ff7-ac3c-476eb62bc9c2', '60eb2349-a214-46e4-b5c2-ea909fe4a8ea', '60fa1665-2b0a-48ee-949c-13c62b9adbf5', '61fc367d-e906-4306-b4ef-3a0d6dd4cb3e', '629222db-bd87-4e33-8e34-9a926bd74f1c', '62eaa4dc-0188-47d1-bd7a-6fef947db1c5', '6332ea5b-a059-448a-848d-69df436d005b', '63d92e9e-2205-44a0-9e6a-5d6f4836638e', '65330c58-2a4f-4381-8bae-91b190d9f011', '65f049f7-9b90-49c9-8ad7-40b22703425f', '667d3ab0-b5fd-4ea8-82fa-bb6a42185ce7', '66933c63-f2c1-4372-93d4-2acf8926e0cf', '67689133-3855-4c90-8b73-885443eab227', '67b76e7b-6451-414d-a7ba-371f86a37743', '6885bf19-b990-49b5-92c6-a838fe962242', '68dcd568-0033-4b6a-a1f8-0721040262a5', '6936d08e-a379-44ba-826e-cf59731d0538', '694908d6-ad1d-4d82-a377-115df4a46f39', '696e1755-cfc4-4e15-a9a0-ffa24d7ad6e7', '697efb2f-7186-4e20-8daa-70b0983e6d35', '6997216c-8eeb-4b3c-bfeb-3582f48b2802', '69ac2419-6b93-40ef-b750-ea565692b7dc', '6a9a4c57-e955-49d7-93b9-516b78d84a03', '6b0157d8-cc95-45b7-92c5-427ab82d571d', '6b4e21d9-44e7-426b-b448-9f0b1d21e995', '6b9af1c9-79dd-4fba-8233-65e91188ebc1', '6bc2aeb2-ce1c-4786-9e04-cb6777dc78c2', '6c73edf9-0318-4189-8e87-e52aafaca5bd', '6ca5bf5d-2a8f-4598-83fd-74ac66c86e2d', '6ce99588-93ff-4149-bd6a-2085a9661a02', '6d48c3ac-98de-420f-a6f4-086d04def503', '70a2a5d8-a3c8-41dd-ac27-8dbfe6b25e4c', '710d063d-0a6b-4fce-ae3f-0200caec2bc0', '732d9774-81bd-4649-9702-e8e6fa05f573', '733c2ff2-6a30-44e9-be0b-482b60f1ee5d', '73561455-c957-4a98-8d8c-05d939a75767', '73e1d536-2ddc-4fe7-8137-e9266d36d1c1', '73f21fc3-3ff2-4a55-a123-1c7e44a8bfa7', '742a6cf7-454e-4a65-8942-e8e1ca27193d', '74cffd6e-defc-430a-b51f-2cbb6381e8f9', '750ec2be-31e6-4e15-a6fd-bf4396184277', '756a5492-1943-40f0-9960-9d8822221aae', '7598905b-6b4a-4833-a8c3-1f77f733af44', '7650d026-5db4-4be9-b7be-1a88a91366bf', '773f1057-bc79-42e1-a632-1a3c096f85fe', '78cd35f8-4e5d-45c1-b904-5ffebe2007a1', '794af11b-0601-4604-bcd8-8c11ff013171', '7a121241-9e5c-46b1-8fa5-191ea076971a', '7aad78f8-03ee-43e1-8ed4-566e3c8edaf0', '7ac00aa0-1b14-4093-b69e-622653eb65aa', '7bb83731-51df-4de5-b1f1-922529450da0', '7c3e2851-3d40-4e66-b333-2820019ac566', '7cc3af30-0156-45db-ab59-94797a5a6108', '7d4b6931-a790-413d-83b4-c2b09de1e9be', '7f98c95a-46f9-47b5-8bc3-04a6d137ff5c', '80ba938a-df63-4f4f-9dfe-3ec9a95c20c3', '8102a911-2004-4461-962d-17095a926802', '8162809e-4cb6-4839-8c69-c6ae29ad24ed', '826a6070-e5d0-4e3a-abfc-e923139b1105', '832bfe1f-7c81-4bcb-8e2b-12652751d0ab', '844ef1b1-77b4-4303-9fbc-b557aa226f80', '84582abe-e416-4df6-aa71-033ec25616c3', '84ad7af4-86dc-44cd-a1ca-84a665f99d98', '8572d2db-263f-4a57-aaca-298edceece6e', '85f70937-9918-4666-8d5b-7b3cc8e910ce', '8641284e-9616-4e84-a769-2a301a536166', '868dc9b5-ebcb-4e5f-ab16-fe76617b4802', '86e08ae7-d4ed-423b-bc5b-3d13cbc98b18', '871f04d1-6b62-4c84-b8f0-4fbf885b8caa', '883658b0-7968-4a89-880f-7341a0ef99b0', '88f59a34-52cf-4d93-a8ba-740fd82b2c18', '891feb09-8abe-40a0-aed4-9a2d2e6578b1', '8a689778-c0db-4d49-8029-b41393d7335f', '8ae26404-175f-4fce-ad5b-e8d4a61cc977', '8b908bd4-69f3-40df-97a4-712d75950b15', '8bbd2998-0b87-4e59-96d6-293c4e7191cd', '8c3f0a9b-cb6d-4e2f-ab7e-ecd441c366ee', '8cad1d42-d04f-492c-90b0-010076d8fc3a', '8d7880bd-f9d8-4cea-8e2f-e576bf6254e7', '8dbb7ea0-452a-4d27-8e65-43d53864f6b2', '8e2953b1-e8cd-47b2-aa89-f65d9c1ee101', '8e8ab7ce-ad62-4e9e-8700-ab2ee8bd8f7e', '8eef18ad-6b31-460b-b772-b63e6ce99b18', '8f53ab39-a112-4ebb-8a94-8586d10808dd', '90139a5a-2298-423f-8853-fc4640159c05', '901caab6-c232-4038-88a4-8c30aff4b14d', '910ca299-162f-4ca1-a1f2-61464a40c1f5', '928c1444-a80f-45cb-9fb9-7d823d8b0173', '930beaa8-8228-4c1b-84a1-74b301ed7a8a', '9322cb39-57fa-4f4f-8049-86dff05fec27', '93359139-cb70-440a-9493-5e7cf83f94d8', '937a311f-aa20-4b92-a114-88bc79513213', '939cbcbe-95c8-4ecd-8586-0d206df76a4a', '93b959f9-13af-4ff8-9d09-82cfe9374fec', '93be3363-8d3c-43c1-b1f1-4d2aa063b9ba', '94275fca-424e-459a-90b4-8da6dcf0f51d', '9457564c-3ebd-4b6f-a833-1c12ebb44909', '949ff6d2-15f5-4d16-a30b-e4afb4b062fb', '94c0417b-e870-41bf-83c3-5c4a2d7ee7e2', '9638d139-4259-4764-b5c4-d5073a2e0a83', '9673ee80-ac81-48ad-b902-28fd3747f578', '968ab25d-1f2f-45c5-a8d5-eea7998006c8', '99b3b4e3-0676-4676-b7a9-58a896df1e7a', '99f7141e-045c-4b55-9027-f8f3af234078', '9a28442d-1b21-4f37-8aaa-f008dff455b2', '9a2c7c76-855c-47e8-9237-d79d11651692', '9bfcd22b-b94f-4a7a-95ff-67f91d067266', '9c276c00-6bc0-4115-bfd6-c6fe2e41da24', '9cd40ca1-bb7c-4a8e-9d11-51864fd16b81', '9cead706-febc-4ff0-b558-aa826c3db527', '9e2a1d0b-d6ee-4f5a-baee-f110531759c4', 'a1369903-f755-4566-807a-6883667ebb5e', 'a1ae2792-b005-417a-b9d0-2e6dd6ace9a0', 'a1f4c8ab-8473-4a76-8e38-7e8af06609c5', 'a22d23f9-711a-4c63-8a65-324e109205c6', 'a30b6c5f-9795-4194-9512-0a66acd840d1', 'a32b38c4-a811-4b76-9913-53d553193c3c', 'a33bd9d2-92d2-48fa-a32a-1243b486979c', 'a45f892b-6ccc-48f5-b781-0ecc61770152', 'a48ea46d-53c7-4d36-a037-fdf801c8984d', 'a4d03dea-d0a2-4445-be8d-3fb796199098', 'a76aff91-ca3b-467d-a917-660ade37a509', 'a76cd38f-2b36-49a5-a4cb-396d2f27bd12', 'a7bae309-5203-4ebd-b277-682b285cce36', 'a857829b-d8bf-4cd4-b2ac-52733e4d9b18', 'a8c88ad3-fcf0-4026-8ea1-9313ed3b9979', 'a9685a34-4ec4-4bf0-b70b-9d4151d6322a', 'aa0712ff-d8a8-4f04-af1f-6c7cf429ae0a', 'aa9ffcf1-a167-4297-979e-409862ccac8e', 'abdb5b7b-54a9-4745-bf0d-6380d49cd913', 'ac7279af-7145-4c7a-9a9b-c017972cb965', 'ace21c58-e585-40b1-8190-8db139b5bb65', 'aecc158d-44c9-450b-ae2d-0df1772d7c51', 'af72d484-2ad7-4606-b5d5-e9476988b944', 'af9c34ac-11cb-45ba-b7ad-c7c5140768bc', 'afe72273-5186-415b-817f-7f1fe77ce9fb', 'b011bcd1-cf21-4971-b385-a92d6b4566cb', 'b07ef2e4-2b7b-46d7-964e-6e38f202d68f', 'b0d5376c-e628-457a-972a-bf29376c798f', 'b14d8e87-764e-4d14-aeae-3231ac62db8e', 'b39a68d9-5827-4342-86b6-5eb9c6607e65', 'b449253c-244f-4cfb-85cd-f6d6272adda6', 'b59831a8-8f65-48b7-a7b4-ae049188c75a', 'b66ea012-c07b-4e02-b496-d6082050d078', 'b7181d24-99a8-4c64-b3d8-84d8d88755fd', 'b7b8f15c-bb36-4cfc-91d3-8f8106890b27', 'b947824a-de59-4460-91f7-56cda4facb1e', 'b9b20df7-c909-4574-838d-22a072076453', 'ba62f14b-5d6e-421f-8806-25d7a277787d', 'baac8942-4dd4-4dc1-8ca0-e493060aacbf', 'bc4857aa-2f17-4f9d-9557-decbceee7f3f', 'bc4fc902-6084-4acf-ab8c-c29d3ebbf75e', 'bc53874e-4f15-4dea-a344-e88d7d1a2350', 'bd01d387-734d-4125-a5b7-6b45c4cfe8d4', 'bd10c476-1e04-4621-8b68-6b1c5c428370', 'bd6b77a2-f608-4087-bf86-015911251756', 'be2b29e2-e0da-44b4-acf7-c54318fe45de', 'bf08eb2e-0419-4816-ad30-5c095f413ab4', 'bfe489d1-76ca-4026-b8db-d7ab3ca022ad', 'bfe87815-c23e-43f9-891b-139ee679abee', 'c0165763-4c1d-4959-ba1e-77c4d2570b71', 'c2320a5d-4ce9-49db-b0b9-23461bf8d2e3', 'c2843b06-3d9e-464f-b26f-1f3ebfd5d090', 'c288e660-5926-4bf7-85c6-f9aded11624d', 'c2b2b788-cfec-4fb4-bb7c-059a1329d04e', 'c462f4ac-7ca8-400b-bc75-e427f0647a2b', 'c46ae7ac-38f6-4180-b16b-ba6996e336d9', 'c4b6e7f9-201c-45c9-ac24-53a16ae6586b', 'c511cc5b-e09b-41ca-a147-372454a8e704', 'c60a0f01-c4b1-46ba-9f9b-d633b54c6e02', 'c6ab6911-e911-459a-9cd0-be3ee3927e96', 'c6d63a4c-3cc8-4361-93a7-7e1706d24dfe', 'c6e57bc5-997f-48ee-ba47-4061dbabc2f0', 'c7eb14d2-6ca4-48d2-a70a-c89a77a6311e', 'c8029701-8e25-4e31-95db-3fda8edae65d', 'ca6d8140-314f-4561-b508-ea2130ad2421', 'cc2e9aaa-b6ba-45e7-959b-4fc002d2fd09', 'cc645a2c-1413-4601-991b-a28ef0d687c8', 'cc87c4b7-3c80-471c-b082-770ea2d8dc1f', 'cd2e89d9-4d92-40d5-88b2-cccb92316f3d', 'cd939f79-2248-40f4-97d0-1370ff264c77', 'cde0c6d1-a727-46d2-8f59-e5deb575678a', 'cdffd0cb-4839-470c-862f-96bd3c1ac51a', 'd0183ce5-c3bf-4451-8368-8f19f92d8f61', 'd16760e8-0e59-4ca5-a1a9-0237ca05668d', 'd17eb56b-6dee-4de5-9dda-41ea320c95ce', 'd1fb8cfb-1cf0-4dad-acf0-52da96cbd8b1', 'd20645a8-0e39-406f-a304-255a307fc7b0', 'd28b7dc7-2cdb-4008-9bdd-4f52f73dc92b', 'd3210366-26b7-47f7-82d4-0a45599f5b59', 'd3a88dee-eb10-469f-ad23-12445e3033fb', 'd5961ced-5f93-4929-aa46-01888c616f08', 'd5a8520d-0b0a-4291-8fff-6c5013e98110', 'd76bf196-3d38-4dc1-b2ce-9fe2a3495848', 'd88d37b8-f9b7-4cd1-add0-54e8c974f00d', 'd8b9e8e6-1536-454a-ad84-d7f161d14c0b', 'd9375b38-3645-4d94-a12e-5e7233fba1f5', 'd9bd17dd-c471-452b-babb-2e2067940cb9', 'd9ea1ee4-838b-4372-bf0d-6b2176e72439', 'db9896cc-84fb-4533-8fd6-64572bea9042', 'dc729cee-2c36-4ab2-ba2c-cf3fa58d3100', 'dc767399-6b79-48cb-8bfb-aeefa13882a4', 'ddb328cd-ed64-4fff-8c3c-596e15c04281', 'deafa040-32af-4352-9aef-051a5cfaf051', 'dee650cd-db32-475d-8bb0-0017ff3bb224', 'dfe5ce9d-b2b7-4543-a96a-6f85468a9296', 'e0085881-e0a6-4d20-bfe0-2bcd4d67174d', 'e10db0cf-f51e-4ec9-a715-dfa8bd3a46cd', 'e1677db8-c857-423d-8a8f-345dfbdddc62', 'e2075faa-76b9-4fd9-839c-ae701a8a1b18', 'e2a64889-c08c-4e3a-bdb0-ff4a11bc2c48', 'e397e7d8-1609-4363-9781-74d49efb9319', 'e468908b-f3d2-4f46-a3a0-26c24699162e', 'e4ed1d63-d237-4975-9393-7196601fe78c', 'e5b6f8ac-b55a-4737-b25a-1dfdcff3404a', 'e6283d19-a8a0-4036-87e0-b36d8a9d7d15', 'e6b7c78c-08c4-4507-8b45-8df24ba106cc', 'e8037210-1dce-4ba5-af15-454d03b1a5b4', 'e9100393-0117-4cb5-acc2-16daf61c709b', 'ea7d2936-17ee-4d57-9afa-23091aa35b3d', 'eaa5adec-b958-4d28-b5b1-f64420beb083', 'eacdf0ad-dc9b-42ed-838e-0ab5f08902a9', 'eafd840f-2b58-4349-be5e-efac69d4d6e8', 'ec2a53d2-7a3c-43c9-94a6-f77d68b083f2', 'ec38c5f6-a273-48d8-8cb5-8bf976dea81d', 'edc27d1d-2e80-4e7c-92e5-433c91eea0b5', 'edf4ba79-24a7-4336-addd-9feb1893c092', 'edf940a0-77f5-4983-b58e-041805444715', 'ef18e075-e903-486d-8a53-8c40ebc2823d', 'f00e4c2e-e127-470a-91c3-7cec3d77e54d', 'f2ca2da2-be42-4ee7-9e30-53e16ac16d28', 'f331fa25-06ca-4c37-a3bb-42a24bcac523', 'f3ab232d-e0c8-498c-92cf-36f279f1a36d', 'f464ed15-7b76-4f08-8e6a-9d4d7ff2492d', 'f4adc1ad-f67b-4023-b994-5674f41e4787', 'f4c3e069-7364-4cf9-abba-58ac2b4a96dc', 'f4cc2e85-33d3-4ae2-b761-ea2a8515cb5c', 'f50ed263-4bf8-4f79-b859-490d60acdea9', 'f5951d26-3d6a-4594-b27b-425e39a51f33', 'f642f113-f78c-44c5-b6db-47e9dad32694', 'f664fadc-5533-4b77-8977-7d5c3fad8d33', 'f75d8922-f536-4487-8f60-de17af854fe8', 'f76513fd-17d8-47a0-8145-0e5817499956', 'f81148ce-18f7-4508-8e22-93ec3945dbdc', 'f8122cfd-e026-4e83-86a9-ea9522a32fc8', 'f845a403-fa04-48b2-bda1-9a66a1bce1e7', 'f8569441-efda-49e0-ada8-4f769152267a', 'f8faf5e1-81e7-479a-b2c5-34a7ea530db5', 'f91ce042-8f49-4fef-b06f-c1cba72468d6', 'f9b29d47-62b8-4f89-afab-f7738787ce17', 'f9e78bde-3d0a-4072-ace1-6ad05cd634ee', 'fa5023ba-fe54-4668-b0b3-e0a7119616ee', 'fa76f0d9-d76e-42fc-844a-e3480d0b860f', 'fa9ad3e8-b901-4230-becd-557ed90e30b4', 'fb1aa08a-d8ff-4491-8b71-6b35b14d948c', 'fb7eab0b-33d8-4d79-8197-328923bd06c6', 'fc38c790-829e-456c-98ba-76b34bde8c31', 'fc4360f8-8bf8-40a5-8f7f-cdafccdb000c', 'fc8a42d7-f364-4c5c-86cb-7fb1491ee158', 'fd1df4fc-ef01-4f1a-b06d-c9a5d31e40af', 'fd7c560f-5114-446b-8426-aec2e0a874e2', 'fdca8cc3-b80a-48da-9453-62e60e0f1905', 'fdedec97-d71c-409e-b8ca-6a56c74feea1', 'feb6386b-dfc5-4e19-bc23-55f9e3a71f44', 'fedbbb11-4598-4a8d-879a-bffd0fa70ce4') GROUP BY tp_4over_product_group_option_master.option_group_uuid ORDER BY prd_grp_mst.order_by ASC 0.0131 sec

67. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 1 0.004 sec

68. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 3 0.0034 sec

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

70. SELECT * FROM address_book WHERE user_id = 0 0.0006 sec

71. SELECT * FROM countries WHERE countries_id = 223 0.0001 sec (Cached) 736a3a216c657882dc62d87c1b72e3c0

72 67. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 1 0.0032 sec

73 68. UPDATE shipping_method SET shipping_pcalc_config = 'C' WHERE shipping_method_id = 3 0.0034 sec

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

75 13. SELECT * FROM product_settings WHERE product_settings.products_id = 425 0 sec (Cached) d49c590792390bfd0001dc5ae5ca9215

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

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

78 13. SELECT * FROM product_settings WHERE product_settings.products_id = 425 0 sec (Cached) d49c590792390bfd0001dc5ae5ca9215

79. 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

80. 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.0006 sec

81 35. SELECT type, page_id FROM cms_pages WHERE page_id IN (10) ORDER BY cms_pages.sort_order ASC 0.0005 sec

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

83. 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

84 36. 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

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

86. 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.0006 sec

87 35. SELECT type, page_id FROM cms_pages WHERE page_id IN (10) ORDER BY cms_pages.sort_order ASC 0.0005 sec

88 36. SELECT SQL_CALC_FOUND_ROWS ps_category_id,parent_id,name FROM ps_category WHERE name is not null ORDER BY parent_id 0.0007 sec

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

90. 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:28:10' AND banner_image.banner_end_date >= '2025-04-03 10:28:10')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](425)[[:>:]]' 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.0009 sec

91 90. 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:28:10' AND banner_image.banner_end_date >= '2025-04-03 10:28:10')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](425)[[:>:]]' 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.0007 sec

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

93. 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 = 425 AND products_description.site_language_id = 1 AND products.predefined_product_type IN ('0', '1') 0.0009 sec

94 13. SELECT * FROM product_settings WHERE product_settings.products_id = 425 0 sec (Cached) d49c590792390bfd0001dc5ae5ca9215

95. 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 = 425 AND products_description.site_language_id = 1 0.001 sec

96 13. SELECT * FROM product_settings WHERE product_settings.products_id = 425 0 sec (Cached) d49c590792390bfd0001dc5ae5ca9215

97 52. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=425 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC 0.0006 sec

98. 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 = 425 WHERE product_master_option.status = '1' 0.001 sec

99. 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 = 425 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

100. SELECT option_id FROM products_mask WHERE product_id = 425 0.0006 sec

101. 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.0001 sec (Cached) ab7c4575a9b273fe5a0f41dc32ef7629