Pearl Postcards (Postcards)

1. SELECT set_value, constant_name FROM configuration_master WHERE constant_name IN ('CORPORATE_MODUEL_ENABLE', 'COUNTRY_BASED_IP_SETTING') sec

(Cached) 23c4c596bd6ed98c168f1756c4bd368d

2. SELECT corporate_user.*, (SELECT pcu.corporate_settings FROM corporate_user pcu WHERE pcu.corporate_id = corporate_user.parent_corporate_id) AS parent_corporate_settings FROM corporate_user WHERE (corporate_user.directory_name = 'uday' OR corporate_user.main_url IN ('uday.fourprintshop.com', 'www.uday.fourprintshop.com')) ORDER BY corporate_user.corporate_type ASC sec

3. 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')) sec

(Cached) 92dd46f86c59b1ac5575508e01c5a6de

4. 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 sec

5. SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'greensward' sec

(Cached) eabac4887f5bca72eac7656056ff7ec0

6. SELECT payment_method_id, directory FROM payment_method WHERE directory IN ('payon_account', 'partial_payment') ORDER BY sort_order ASC sec

(Cached) e4e2b78166a96840443ba3ecc630401c

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

(Cached) 01725a75647885828b24e7604b95b263

8. SELECT website_logos.* FROM website_logos WHERE website_logos.corporate_id = 0 ORDER BY FIELD(corporate_id, 0, 0, 0) sec

(Cached) 265fd0b99fb9b4b66ea20f75bc4bb5b8

9. SELECT * FROM site_language sec

(Cached) d006a14cdb095c4bf9083702065fe3f4

10. SELECT * FROM url_redirection_manage WHERE (old_url = 'https://uday.fourprintshop.com/marketing-material/postcards/pearl-postcards/' OR old_url = 'https://uday.fourprintshop.com/marketing-material/postcards/pearl-postcards/' OR old_url = 'https://uday.fourprintshop.com/marketing-material/postcards/pearl-postcards/') ORDER BY url_redirection_id ASC sec

11. SELECT * FROM site_currency WHERE default_currency = '1' sec

12. SET time_zone = '-04:00' sec

13. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id,products.predefined_product_type FROM products_description LEFT JOIN products on products_description.products_id=products.products_id WHERE products_description.product_url = 'pearl-postcards' sec

14. SELECT products.predefined_product_type, products.price_defining_method, products.is_promotional FROM products WHERE products.products_id = 394 sec

(Cached) 9b8900c9fb6a6700374d9559479a66bd

15. SELECT studio_configuration_setting.variable_name, studio_configuration_product_setting.products_id, IF(studio_configuration_product_setting.configuration_id IS NOT NULL ,studio_configuration_product_setting.value,studio_configuration_setting.value) as setting_value, studio_configuration_setting.value AS default_value FROM studio_configuration_setting LEFT JOIN studio_configuration_product_setting ON studio_configuration_setting.configuration_id = studio_configuration_product_setting.configuration_id AND ( IF(studio_configuration_product_setting.products_id != 0,
studio_configuration_product_setting.products_id = 394 AND studio_configuration_product_setting.corporate_id = 0,
studio_configuration_product_setting.products_type_id = 1 AND studio_configuration_product_setting.corporate_id = 0 ) ) WHERE ( IF( studio_configuration_setting.exclude_products_type IS NOT NULL AND studio_configuration_setting.exclude_products_type != '', studio_configuration_setting.exclude_products_type NOT LIKE '%1%', studio_configuration_setting.products_type IS NULL OR studio_configuration_setting.products_type = '' OR studio_configuration_setting.products_type LIKE '%1%' OR studio_configuration_setting.products_type = '-1') ) AND studio_configuration_setting.variable_name = 'config[3DPreview]' ORDER BY studio_configuration_product_setting.products_id sec

(Cached) d272528a00dee45a732dee27e62440b0

16. SELECT * FROM products_studio_3d_models WHERE products_studio_3d_models.products_id = 394 AND products_studio_3d_models.status = '1' sec

17. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'COMMON_QUANTITY') sec

(Cached) 7655a7dd62322598597264e96f0d506c

18. SELECT site_template_category.category_id, site_template_category_description.category_name, site_template_category_description.category_url, site_template_category_description.site_language_id FROM site_template_category_description LEFT JOIN site_template_category ON site_template_category_description.category_id = site_template_category.category_id WHERE site_template_category_description.site_language_id = 1 sec

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

20. 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 WHERE ((products.user_type_id IN ('0', '1'))) sec

(Cached) 8010202bafea16bd20888b7d9a0ef5b4

21. 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') sec

22. SELECT products.products_id, 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') sec

23. 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 sec

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

(Cached) 3c57829f108685bdd23e904d34b9124d

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

28. SELECT * FROM(SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants.constant_id, ROW_NUMBER() OVER(PARTITION BY site_constants.constant_id ORDER BY FIELD(site_constants_description.constant_id, 0)) AS rank, site_constants_description.corporate_id FROM site_constants INNER JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 INNER 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', '-1', '-2') AND (site_constants_description.corporate_id = 0 OR site_constants_description.corporate_id IS NULL )) AS ranked WHERE rank = 1 sec

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

33. CALL USPGetProductsDetail('product_category.category_id,products.category_id AS cat_id,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,product_category_description.category_icon,product_category_description.category_header_content,product_category_description.metadata,products.products_id,products.predefined_product_type,products_description.product_url,products_description.products_title,products_description.product_promotional_text', '{\"status\":\"1\",\"visible\":1,\"hidden_product\":\"yes\",\"include_kit\":\"false\",\"site_language_id\":1,\"corporate_id\":0,\"parent_corporate_id\":0,\"product_service_type\":\"1,3,4,5\",\"store_access\":\" AND ((products.user_type_id IN (\'0\',\'1\')))\",\"include_group\":\"group\",\"is_admin\":0,\"modules\":\"0,1\"}', '{\"orderby\":\"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\"}') sec

(Cached) c00a9da814defd601e9d8f3eb6878d2c

34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

35. SELECT product_category.category_id, product_category.category_pro_enable, product_category.category_pro_pattern, product_category_description.category_promotional_text, product_category_description.category_icon, product_category_description.category_header_content, product_category_description.metadata, product_category.status FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id WHERE product_category.parent_id = '0' AND product_category_description.site_language_id = 1 sec

(Cached) 0d49af1c9847aa1d844fc8b9f1bc41c4

36. SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting sec

(Cached) 3032d2886e227e87f9c8146b7a2b4507

38. SELECT * FROM products WHERE products.products_id = 394 sec

39. SELECT products.product_service_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.products_id = 394 AND products_description.site_language_id = 1 sec

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

41. SELECT * FROM tp_4over_settings WHERE setting_name IN ('payment_billing', 'shipping_address_4over', 'Payment', 'default_markup_4over', 'clients_detail', 'include_shipping_and_turnaround_days_in_edd', 'allow_group_shipment', 'default_bypass_address_4over', 'pay_by_echeck', 'default_profile_id') sec

42. SELECT * FROM tp_4over_settings WHERE setting_name = 'default_markup_4over' sec

43. SELECT * FROM tp_4over_settings WHERE setting_name = 'clients_detail' sec

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

45. SELECT category_uuid FROM tp_4over_category WHERE category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

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

47. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name IN ('PRODUCT_ADDITIONAL_OPTION_FOR_STOCK_MANAGE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'PRODUCT_MINIMUM_PRICE', 'PRODUCT_BROWSE_DESIGN', 'PRODUCT_UPLOAD_DESIGN', 'PRODUCT_CUSTOME_DESIGN', 'PRODUCT_DESC_SELECT_STORE_TEMPLATE_HELP_TEXT', 'PRODUCT_DESC_USER_UPLOAD_ART_HELP_TEXT', 'PRODUCT_DESC_USER_CREATION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_ACTION_LABEL', 'PRODUCT_QUOTE', 'PRODUCT_DESC_HIRE_DESIGNER_HELP_TEXT', 'PRODUCT_DESC_QUOTE_HELP_TEXT', 'PRODUCT_HIRE_DESIGNER', 'BOOK_NO_COVER', 'BOOK_COVER_INCLUDED_IN_CONTENT', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_ADDITIONAL_OPTION_GALLERY', 'PRODUCT_UPLOAD_LOCATION', 'ARTWORK_LATER_OPTION', 'PRODUCT_PDF_PREVIEW_ENABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_CSS_CLASS', 'PRODUCT_DOWNLOAD_PRINT_FILE', 'CUSTOM_SIZE_INFO', 'PRODUCT_CREATE_HELP_TEMPLATE', 'PRODUCT_START_PRICE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_SETUP_COST', 'PRODUCT_APPLY_SETUP_COST', 'ENABLE_BUYNOW', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'CUSTOM_SIZE_SETUP_COST', 'CUSTOM_SIZE_CHECK', 'CUSTOM_SIZE_IMAGE') sec

(Cached) c099cfbad9a7521e6a833340480b7312

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

(Cached) 63cf6db702691d1df0d74b63bbaee1ac

49. SELECT products.*, products_description.* FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.products_id = 394 AND products_description.site_language_id = 1 AND products.visible = 1 AND ((products.user_type_id IN ('0', '1'))) sec

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

51. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=394 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC sec

52. SELECT * FROM products_sizes WHERE products_sizes.products_id = 394 AND products_sizes.visible = '1' AND site_language_id = 1 sec

53. 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 = 394 AND orders_feedback.status like '1' sec

54. SELECT product_template.tp4over_template, 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 = 394 OR duplicate_product_id LIKE '%,394-%') 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 sec

55. SELECT products_image_gallery.corporate_id, 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 = 394 AND (products_image_gallery.language = 1 OR products_image_gallery.language = 0) AND products_image_gallery.status = '1' AND products_image_gallery.corporate_id = 0 HAVING is_active = 1 ORDER BY products_image_gallery.option_id ASC, products_image_gallery.option_ids ASC, products_image_gallery.sort_order ASC sec

56. SELECT GROUP_CONCAT(products_related_id) AS products_related_id FROM products_related_products WHERE product_assignment_type = 'R' AND products_id = 394 sec

57. SELECT products.predefined_product_type FROM products WHERE products.products_id = 394 sec

(Cached) f9e0b39507d3e00970ec139d2df23e41

58. SELECT coupon.coupon_id, coupon.type, coupon.bogo_config, coupon.coupon_amount, coupon.coupon_name, coupon.product_id, coupon.user_discount_group_id, coupon.coupon_condition, coupon.applicable_with_option, coupon.type, pids.value, coupon.product_id AS coupon_products, coupon.coupon_spec_users, coupon.user_type, coupon.created_by, pids.value AS product_id, IF(coupon_combo_products_rules.discount IS NULL OR coupon_combo_products_rules.discount = 0, coupon.coupon_amount, coupon_combo_products_rules.discount) as discount, IF(coupon_combo_products_rules.min_quantity IS NULL OR coupon_combo_products_rules.min_quantity = 0, 0, coupon_combo_products_rules.min_quantity) as min_qty, IF(coupon_combo_products_rules.max_quantity IS NULL OR coupon_combo_products_rules.max_quantity = 0, 0, coupon_combo_products_rules.max_quantity) as max_qty FROM coupon CROSS JOIN JSON_TABLE(CONCAT('["', REPLACE(product_id, ',', '","'), '"]'), '$[*]' COLUMNS(value INT PATH '$')) AS pids LEFT JOIN coupon_combo_products_rules ON coupon_combo_products_rules.coupon_id = coupon.coupon_id and coupon_combo_products_rules.products_id = pids.value LEFT JOIN products ON products.products_id = pids.value AND ((products.user_type_id IN ('0', '1'))) WHERE products.visible = 1 AND (
coupon.type = 'combo_discount'
OR (coupon.type = 'bogo' AND (coupon_combo_products_rules.coupon_id IS NULL OR coupon_combo_products_rules.products_id IS NULL))
) AND coupon.product_id REGEXP '(^|,)(394)(,|$)' AND coupon.created_by = 0 AND '2026-06-13 01:35:23' BETWEEN coupon.coupon_start_date AND coupon.coupon_end_date AND coupon.coupon_status = '1' AND products.predefined_product_type IN ('0', '1') GROUP BY coupon.coupon_id,value ORDER BY coupon.created_by DESC, coupon.coupon_id, pids.value; sec

59. SELECT layout_name, is_mobile, sidebar_display FROM product_info_layout WHERE layout_name = 'L1' sec

(Cached) 38cd42efff1fff38bed6470c2cfe436b

60. SELECT * FROM tp_move_ops_product WHERE ops_product_id = 394 sec

61. SELECT 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 = '4e0b6b1c-b641-4249-b52d-e136014fb8ac' AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' GROUP BY option_group_uuid ORDER BY tp_4over_product_group_master.order_by ASC, tp_product_price.product_baseprice ASC sec

62. SELECT * FROM tp_4over_product_options_settings WHERE category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' AND tp_4over_product_options_settings.ops_product_id IN ('0', '394') AND tp_4over_product_options_settings.corporate_id = 0 ORDER BY tp_4over_product_options_settings.ops_product_id DESC, FIELD(tp_4over_product_options_settings.corporate_id, 0, 0) sec

63. SELECT * FROM tp_4over_site_constant WHERE tp_4over_site_constant.default_value = '1' sec

64. SELECT * FROM tp_4over_product_group_orderby_and_quote WHERE ops_product_id IN ('0', '394') AND categoryId = '4cb9f549-5376-4d43-8530-b04632d026a8' GROUP BY ops_product_id,option_group_uuid ORDER BY ops_product_id DESC sec

65. SELECT option_group_uuid,option_group_name FROM tp_4over_product_group_master sec

(Cached) b4f1269419b4ab10b5b7d25eb2c214cf

66. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

67. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') GROUP BY colorspec_uuid sec

68. SELECT * FROM tp_4over_product_option_rules WHERE category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' AND status = '1' sec

69 66. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

70. SELECT product_uuid FROM tp_4over_products WHERE categories = '4cb9f549-5376-4d43-8530-b04632d026a8' And status = '1' sec

71. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = '3407938c-39e0-402b-b4dc-c16fd21759a6' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P9 INNER JOIN (SELECT t4pgo.product_uuid as pid_10 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c2849f26-63d8-4ba1-99a0-6cf51e03354e' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P10 INNER JOIN (SELECT t4pgo.product_uuid as pid_11 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'f80e8179-b264-42ce-9f80-bb258a09a1fe' AND t4pgo.option_uuid = '50979118-b3a2-4556-9f46-d1da268f2354' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P11 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P1.pid_1 = P9.pid_9) AND (P1.pid_1 = P10.pid_10) AND (P1.pid_1 = P11.pid_11) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P2.pid_2 = P9.pid_9) AND (P2.pid_2 = P10.pid_10) AND (P2.pid_2 = P11.pid_11) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P3.pid_3 = P9.pid_9) AND (P3.pid_3 = P10.pid_10) AND (P3.pid_3 = P11.pid_11) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P4.pid_4 = P9.pid_9) AND (P4.pid_4 = P10.pid_10) AND (P4.pid_4 = P11.pid_11) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P5.pid_5 = P9.pid_9) AND (P5.pid_5 = P10.pid_10) AND (P5.pid_5 = P11.pid_11) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P6.pid_6 = P9.pid_9) AND (P6.pid_6 = P10.pid_10) AND (P6.pid_6 = P11.pid_11) AND (P7.pid_7 = P8.pid_8) AND (P7.pid_7 = P9.pid_9) AND (P7.pid_7 = P10.pid_10) AND (P7.pid_7 = P11.pid_11) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P10.pid_10 = P11.pid_11) sec

72. SELECT DISTINCT(FPAG.product_uuid) as product_uuid FROM tp_4over_product_group_option_master AS FPAG LEFT JOIN tp_4over_products as FP ON FP.product_uuid = FPAG.product_uuid AND FP.status = '1' WHERE FPAG.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND FP.categories = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

74. SELECT 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 ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' GROUP BY tp_4over_product_group_option_master.option_group_uuid sec

75. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name IN ('PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_CUT_OFF_TIME', 'PRODUCT_DESC_HIRE_DESIGNER_OPTION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_OPTION_LABEL', 'PRODUCT_HIRE_DESIGNER_NO', 'PRODUCT_HIRE_DESIGNER_YES') sec

(Cached) d535f6b82ccfaa4dd706b2c665aff5c2

76 66. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

77. SELECT DISTINCT product_uuid FROM (SELECT t4pgo.product_uuid FROM tp_4over_product_group_option_master as t4pgo LEFT JOIN tp_4over_products as FP ON FP.product_uuid = t4pgo.product_uuid WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND FP.status = '1' AND FP.categories = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as product_data sec

78. SELECT DISTINCT(FPAG.product_uuid) as product_uuid FROM tp_4over_product_group_option_master AS FPAG LEFT JOIN tp_4over_products as FP ON FP.product_uuid = FPAG.product_uuid AND FP.status = '1' WHERE FPAG.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') AND FP.categories = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

79 66. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

80. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 ON (P1.pid_1 = P2.pid_2) sec

81 66. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

82. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P2.pid_2 = P3.pid_3) sec

83 66. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac', '5c635c06-8273-4a94-98f1-fe5cf3d3e20b', '73e5fcd9-b1ce-452f-8454-b6e1ce331c61', '8fe39f4a-8f35-4056-9d07-8807f05ac615', '945c235b-79a4-4b3b-a637-a33f66d54b58', 'bb425a2d-90b8-4c01-b686-c592d72981ee', 'c7e3715b-5977-428e-86f1-5047e5e83b55', 'ea459898-9279-4ba0-a11e-d85c70cf3466', 'ef98b976-8282-46af-a94c-51110a8d6c45') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

84. SELECT size_id,tp4over_size_title FROM tp_4over_ops_size_mapping WHERE ops_product_id =394 sec

85. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P3.pid_3 = P4.pid_4) sec

86. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

87. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P5 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P4.pid_4 = P5.pid_5) sec

88 86. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

89. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P6 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P5.pid_5 = P6.pid_6) sec

90 86. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

91. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = '3407938c-39e0-402b-b4dc-c16fd21759a6' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P7 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P6.pid_6 = P7.pid_7) sec

92 86. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

93. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = '3407938c-39e0-402b-b4dc-c16fd21759a6' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P8 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P7.pid_7 = P8.pid_8) sec

94 86. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

95. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') GROUP BY colorspec_uuid sec

96. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = '3407938c-39e0-402b-b4dc-c16fd21759a6' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P9 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P1.pid_1 = P9.pid_9) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P2.pid_2 = P9.pid_9) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P3.pid_3 = P9.pid_9) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P4.pid_4 = P9.pid_9) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P5.pid_5 = P9.pid_9) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P6.pid_6 = P9.pid_9) AND (P7.pid_7 = P8.pid_8) AND (P7.pid_7 = P9.pid_9) AND (P8.pid_8 = P9.pid_9) sec

97 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

98 86. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

99. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = 'd7282f7f-e4d8-43c2-b727-91667f6257bd' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd10848ac-8885-441a-a835-3c38050ff964' AND t4pgo.option_uuid = 'b59d3ba3-3690-4871-b4f4-90906a925b88' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = '3407938c-39e0-402b-b4dc-c16fd21759a6' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P9 INNER JOIN (SELECT t4pgo.product_uuid as pid_10 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c2849f26-63d8-4ba1-99a0-6cf51e03354e' AND t4pgo.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' ) as P10 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P1.pid_1 = P9.pid_9) AND (P1.pid_1 = P10.pid_10) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P2.pid_2 = P9.pid_9) AND (P2.pid_2 = P10.pid_10) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P3.pid_3 = P9.pid_9) AND (P3.pid_3 = P10.pid_10) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P4.pid_4 = P9.pid_9) AND (P4.pid_4 = P10.pid_10) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P5.pid_5 = P9.pid_9) AND (P5.pid_5 = P10.pid_10) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P6.pid_6 = P9.pid_9) AND (P6.pid_6 = P10.pid_10) AND (P7.pid_7 = P8.pid_8) AND (P7.pid_7 = P9.pid_9) AND (P7.pid_7 = P10.pid_10) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P9.pid_9 = P10.pid_10) sec

100 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

101. SELECT DISTINCT(option_uuid) FROM tp_4over_product_turnaround_time_price WHERE product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND runsize_uuid = 'c2849f26-63d8-4ba1-99a0-6cf51e03354e' sec

102. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' AND tp_4over_product_group_option_master.option_uuid IN ('50979118-b3a2-4556-9f46-d1da268f2354', '9f85d0c4-d344-4088-a719-86f8f84d504d', 'ad290b77-c9d5-476c-b847-9ad4d25ae14e') sec

103 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('4e0b6b1c-b641-4249-b52d-e136014fb8ac') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

104. SELECT DISTINCT(option_uuid),option_name FROM tp_4over_product_group_option_master WHERE option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' sec

105. SELECT is_flat_fee,qty,price_per_qty,price,startqty,endqty,product_option_group_uuid,is_percentage, option_uuid FROM tp_product_opt_price WHERE product_uuid = '4e0b6b1c-b641-4249-b52d-e136014fb8ac' AND product_option_group_uuid IN ('b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb', 'd10848ac-8885-441a-a835-3c38050ff964', 'b19d4ac3-2d48-40c0-9729-e35af6846271', '34f407f8-0b50-4227-9378-10fddefbe596', '88c28e92-7c8c-4c05-9908-dcd495e0957a', '5fffd29b-af78-41af-a216-7cdaf8d55177', '24865ffa-793d-43ea-b3b1-d1b5cf22268d', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('d7282f7f-e4d8-43c2-b727-91667f6257bd', 'b59d3ba3-3690-4871-b4f4-90906a925b88', '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858', 'e09b1c54-68fa-416c-94c5-bb5327cde533', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'ee567ae7-d0e9-47ca-830a-b172c097b44f', '3407938c-39e0-402b-b4dc-c16fd21759a6', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', 'c2849f26-63d8-4ba1-99a0-6cf51e03354e', '50979118-b3a2-4556-9f46-d1da268f2354') AND startqty <= 25 AND endqty >= 25 sec

(Cached) 7d918eabf5947bc14a3776ba0270ad59

106. SELECT * FROM tp_4over_product_turnaround_time_price WHERE product_uuid ='4e0b6b1c-b641-4249-b52d-e136014fb8ac' And option_uuid ='50979118-b3a2-4556-9f46-d1da268f2354' And colorspec_uuid ='32d3c223-f82c-492b-b915-ba065a00862f' And runsize_uuid ='c2849f26-63d8-4ba1-99a0-6cf51e03354e' sec

107. SELECT markup, markup_type FROM tp_4over_category WHERE category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

108. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 394 sec

109. SELECT size_id FROM tp_4over_ops_size_mapping LEFT JOIN tp_4over_product_group_option_master as opt ON opt.option_name = tp_4over_ops_size_mapping.tp4over_size_title WHERE opt.option_uuid = 'e09b1c54-68fa-416c-94c5-bb5327cde533' AND ops_product_id =394 LIMIT 1 OFFSET 0 sec

110. SELECT grp.option_group_name,tp_4over_product_group_option_master.* FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as grp ON grp.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid = '4e0b6b1c-b641-4249-b52d-e136014fb8ac' AND tp_4over_product_group_option_master.category_uuid = '4cb9f549-5376-4d43-8530-b04632d026a8' sec

111. SELECT coupon.*, IF (coupon.product_id != 'all',1,2) AS OrderBY FROM coupon WHERE coupon.type = 'discount' AND coupon.coupon_type = 'product' AND '2026-06-13 01:35:23' BETWEEN coupon.coupon_start_date AND coupon.coupon_end_date
AND coupon.coupon_status = '1' ORDER BY OrderBY, user_discount_group_id DESC, coupon_start_date DESC , coupon_id DESC sec

112 75. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name IN ('PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_CUT_OFF_TIME', 'PRODUCT_DESC_HIRE_DESIGNER_OPTION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_OPTION_LABEL', 'PRODUCT_HIRE_DESIGNER_NO', 'PRODUCT_HIRE_DESIGNER_YES') sec

(Cached) d535f6b82ccfaa4dd706b2c665aff5c2

113 75. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name IN ('PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_CUT_OFF_TIME', 'PRODUCT_DESC_HIRE_DESIGNER_OPTION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_OPTION_LABEL', 'PRODUCT_HIRE_DESIGNER_NO', 'PRODUCT_HIRE_DESIGNER_YES') sec

(Cached) d535f6b82ccfaa4dd706b2c665aff5c2

114. SELECT production_days FROM products_production_days left join products_sizes on products_production_days.size_id=products_sizes.size_id WHERE products_production_days.size_id = 8842 AND products_production_days.attribute_id = 0 AND products_sizes.products_id= 394 AND products_sizes.site_language_id= 1 sec

115. SELECT setting_constant_name, setting_value FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name = 'DEFAULT_PRODUCTION_DAYS' sec

(Cached) 9e675052ece2aad54e2b1a6af72d5f4d

116. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name = 'PRODUCT_CUT_OFF_TIME' sec

(Cached) cd26f6c2b08cd0b2848e4fa38a067602

117 105. SELECT is_flat_fee,qty,price_per_qty,price,startqty,endqty,product_option_group_uuid,is_percentage, option_uuid FROM tp_product_opt_price WHERE product_uuid = '4e0b6b1c-b641-4249-b52d-e136014fb8ac' AND product_option_group_uuid IN ('b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb', 'd10848ac-8885-441a-a835-3c38050ff964', 'b19d4ac3-2d48-40c0-9729-e35af6846271', '34f407f8-0b50-4227-9378-10fddefbe596', '88c28e92-7c8c-4c05-9908-dcd495e0957a', '5fffd29b-af78-41af-a216-7cdaf8d55177', '24865ffa-793d-43ea-b3b1-d1b5cf22268d', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('d7282f7f-e4d8-43c2-b727-91667f6257bd', 'b59d3ba3-3690-4871-b4f4-90906a925b88', '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858', 'e09b1c54-68fa-416c-94c5-bb5327cde533', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'ee567ae7-d0e9-47ca-830a-b172c097b44f', '3407938c-39e0-402b-b4dc-c16fd21759a6', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', 'c2849f26-63d8-4ba1-99a0-6cf51e03354e', '50979118-b3a2-4556-9f46-d1da268f2354') AND startqty <= 25 AND endqty >= 25 sec

(Cached) 7d918eabf5947bc14a3776ba0270ad59

118 108. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 394 sec

119. SELECT shipping_method_id, directory, shipping_pcalc_config, shipping_details FROM shipping_method WHERE status = '1' sec

(Cached) 52520048f72321f7fc95c1219427ab6d

120. SELECT * FROM address_book WHERE user_id = 0 sec

121. SELECT * FROM countries WHERE countries_id = 223 AND countries.available_for_default_store = '1' sec

(Cached) cd3fa65484d94fadd06c251b01a31fd8

122 119. SELECT shipping_method_id, directory, shipping_pcalc_config, shipping_details FROM shipping_method WHERE status = '1' sec

(Cached) 52520048f72321f7fc95c1219427ab6d

123. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name IN ('PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'ALLOW_FREE_SHIPPING') sec

(Cached) ea3982dcb8205b0020fa098459c3a9c9

124. SELECT count(countries_id) as total FROM countries WHERE status = '1' AND countries.available_for_default_store = '1' sec

(Cached) 6eaa3b39c2718890711cfd27fb194775

125. SELECT * FROM countries WHERE status = '1' AND countries.available_for_default_store = '1' ORDER BY countries_name ASC sec

(Cached) 09edf8b51add513de8d19a10ef493375

126. SELECT shipping_method_id,shipping_pcalc_config, shipping_method.* FROM shipping_method WHERE status ='1' AND FIND_IN_SET('1',user_type) AND (NOT FIND_IN_SET(1, user_group_lookup)) ORDER BY sort_order ASC sec

127. 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 sec

128. SELECT * FROM site_currency WHERE status = '1' sec

(Cached) 613b110f15bfd6188f372b9124b62c8e

129 34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

130. SELECT SQL_CALC_FOUND_ROWS products.sort_order, products_description.imagename, products_description.product_description, products_description.products_title, products_description.products_id, products_description.imagename_alt, products_description.product_desc_image_alt, products_description.metadata 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 WHERE products.kit_type_id != '1' AND products.visible = '1' AND ((products.user_type_id IN ('0', '1'))) AND hidden_product = '0' ORDER BY product_kit.kit_id ASC sec

(Cached) 1cffd954f20a0fb38cfc672226b9b38a

131 34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

132. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

133 34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

134 132. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

135 34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

136 132. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

137 34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

138 132. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

139 34. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

140 132. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

141. SELECT SQL_CALC_FOUND_ROWS banner_image.title, banner_image.banner_image_name, banner_image.banner_mobile_image_name, banner_image.banner_link, banner_image.open_target, banner_image.banner_text, banner_image.mobile_banner_text, banner_image.banner_image_id, banner_image.banner_upperimage_name, banner_image.banner_display_type, banner_image.banner_display, banner_image.banner_advance_settings, banner_image.metadata FROM banner_image WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2026-06-13 01:35:23' AND banner_image.banner_end_date >= '2026-06-13 01:35:23')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](394)[[:>:]]' AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC sec

142 141. SELECT SQL_CALC_FOUND_ROWS banner_image.title, banner_image.banner_image_name, banner_image.banner_mobile_image_name, banner_image.banner_link, banner_image.open_target, banner_image.banner_text, banner_image.mobile_banner_text, banner_image.banner_image_id, banner_image.banner_upperimage_name, banner_image.banner_display_type, banner_image.banner_display, banner_image.banner_advance_settings, banner_image.metadata FROM banner_image WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2026-06-13 01:35:23' AND banner_image.banner_end_date >= '2026-06-13 01:35:23')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](394)[[:>:]]' AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC sec

143. SELECT * FROM breadcrumbs WHERE status = '1' sec

(Cached) cfc88bdad1d3c808679011331b88f107

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

145. SELECT SQL_CALC_FOUND_ROWS * FROM product_category_description WHERE category_url = 'postcards' AND site_language_id = 1 sec

146. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name IN ('PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) 4647d28fd0258cf049e21574b98d44e6

147. SELECT product_category.category_id,product_category_description.category_name,product_category.parent_id,product_category.status 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 AND (product_category.category_id= ( SELECT `parent_id` FROM `product_category` WHERE `category_id` = '22' ) AND product_category.parent_id = '0' ) OR product_category.category_id = 22 AND product_category.status = '1' sec

148. SELECT id, process_id, status FROM background_processes WHERE tag = 'products_product_gallery' AND status = 'running' sec

149. SELECT * FROM product_settings WHERE product_settings.products_id = 394 AND product_settings.setting_constant_name = 'PRODUCT_CREATE_HELP_TEMPLATE' sec

(Cached) 7bb17818ad8ff15f7bb0671e5e337616

150. SELECT studio_configuration_setting.variable_name, (studio_configuration_setting.value) as setting_value FROM studio_configuration_setting WHERE studio_configuration_setting.variable_name IN ('custom_add_cut_customsize') sec

(Cached) ab6870bc59dbc9ac402298b62edb44b3

151. SELECT products.*, products_description.*, measurement_unit.* 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 = 394 AND products_description.site_language_id = 1 sec

152. SELECT * FROM product_settings WHERE product_settings.products_id = 394 sec

(Cached) a796ffe0b2a6ab350f8a688f02ed373a

153 51. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=394 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC sec

154. 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.`hire_designer_option` AS master_hire_designer_option,
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.`additional_lookup_details`,
product_master_option_description.title,
product_master_option_description.description,
product_master_option_attributes.master_attribute_id,
product_master_option_attributes.multiplier_type as attr_multiplier_type,
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.material_thickness,
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.material_thickness,
product_master_option_attributes_description.label,
product_master_option_attributes.metadata, products_additional_option.`sort_order` AS option_sort_order, products_additional_option.`setup_cost` as option_setup_cost, products_additional_option.`multiplier` as option_multiplier, products_additional_option.`multiplier_type` as option_multiplier_type, 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 = 394 WHERE product_master_option.status = '1' sec

155. 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 = 394 AND products.kit_type_id != '2' AND products_description.site_language_id = 1 AND products.visible = 1 ORDER BY products.products_id ASC sec

156. SELECT size_id, size_title, size_width, size_height, no_of_folding, orientation, page_size_details FROM products_sizes WHERE site_language_id = 1 AND products_sizes.products_id = 394 sec

157. SELECT pages_id, page_title FROM products_pages WHERE visible = '1' AND products_id = 394 AND site_language_id = 1 ORDER BY sort_order ASC, pages_id ASC sec

(Cached) b9edc69a6b55c2ce7bc6ded6bf286a6b

158. SELECT unit_type_name FROM measurement_unit WHERE unit_type_code = 'Inch' AND site_language_id = 1 sec

159. SELECT option_id,mask_image_landscape,mask_image_potrait,pages_id,size_id,attribute_id FROM products_mask WHERE product_id = 394 sec

160 14. SELECT products.predefined_product_type, products.price_defining_method, products.is_promotional FROM products WHERE products.products_id = 394 sec

(Cached) 9b8900c9fb6a6700374d9559479a66bd

161. SELECT studio_configuration_setting.variable_name, studio_configuration_product_setting.products_id, IF(studio_configuration_product_setting.configuration_id IS NOT NULL ,studio_configuration_product_setting.value,studio_configuration_setting.value) as setting_value, studio_configuration_setting.value AS default_value FROM studio_configuration_setting LEFT JOIN studio_configuration_product_setting ON studio_configuration_setting.configuration_id = studio_configuration_product_setting.configuration_id AND ( IF(studio_configuration_product_setting.products_id != 0,
studio_configuration_product_setting.products_id = 394 AND studio_configuration_product_setting.corporate_id = 0,
studio_configuration_product_setting.products_type_id = 1 AND studio_configuration_product_setting.corporate_id = 0 ) ) WHERE ( IF( studio_configuration_setting.exclude_products_type IS NOT NULL AND studio_configuration_setting.exclude_products_type != '', studio_configuration_setting.exclude_products_type NOT LIKE '%1%', studio_configuration_setting.products_type IS NULL OR studio_configuration_setting.products_type = '' OR studio_configuration_setting.products_type LIKE '%1%' OR studio_configuration_setting.products_type = '-1') ) AND studio_configuration_setting.variable_name IN ('product[margins][data][0][border][color]', 'product[margins][data][1][border][color]') ORDER BY studio_configuration_product_setting.products_id sec

(Cached) 30bbd71c154b4a887d5a53c9464651c0