20+ Years Focus on Stainless Steel Flatware Manufacturing20+ Years Exporting to 100+ Countries100+ Countries sale@flatcutlery.com +86 20 8479 0028
Home/Products/Flatware Set/20 Piece Sets

Flatware Set Listing

20 Piece Flatware Set Manufacturer

Explore 20 piece stainless steel flatware sets with custom finishes, packaging, logo and OEM support.

Get Set Quote
Showing 1-5 of 5 products
Sort: Recommended Newest Name A-Z
Jieyang Cutlery Factory 410ss Mirror Polish 20 Pieces Flatware Set For USA Market Mirror Polish 13/0 Stainless Steel

Jieyang Cutlery Factory 410ss Mirror Polish 20 Pieces Flatware Set For USA Market

SKU: SM065

Set Type
20 Piece Sets
Finish
Mirror Polish
Material
13/0 Stainless Steel
Application
Hotel & Restaurant, Supermarket Retail
View Details
Jieyang Stainless Steel Cutlery Set Blue PVD Modern Flatware For Restaurant Mirror Polish 18/0 Stainless Steel

Jieyang Stainless Steel Cutlery Set Blue PVD Modern Flatware For Restaurant

SKU: SM031-B

Set Type
20 Piece Sets
Finish
Mirror Polish
Material
18/0 Stainless Steel
Application
Hotel & Restaurant, Supermarket Retail
View Details
Stainless Steel Cutlery Set Rainbow Titanium Coated Luxury Flatware Collection Mirror Polish 18/0 Stainless Steel

Stainless Steel Cutlery Set Rainbow Titanium Coated Luxury Flatware Collection

SKU: SM031-C

Set Type
20 Piece Sets
Finish
Mirror Polish
Material
18/0 Stainless Steel
Application
Hotel & Restaurant, Supermarket Retail
View Details
Jieyang Stainless Steel Cutlery Factory Golden Ion Plating 18/0 Flatware Set Gold PVD 18/0 Stainless Steel

Jieyang Stainless Steel Cutlery Factory Golden Ion Plating 18/0 Flatware Set

SKU: SM031-J

Set Type
20 Piece Sets
Finish
Gold PVD
Material
18/0 Stainless Steel
Application
Hotel & Restaurant, Wedding & Banquet, Supermarket Retail
View Details
Jieyang Stainless Steel Cutlery Factory 18/0 Mirror Polish 20 Pcs Flatware Set Matte Black 18/0 Stainless Steel

Jieyang Stainless Steel Cutlery Factory 18/0 Mirror Polish 20 Pcs Flatware Set

SKU: SM031-A

Set Type
20 Piece Sets
Finish
Matte Black
Material
18/0 Stainless Steel
Application
Hotel & Restaurant, Wedding & Banquet, Supermarket Retail
View Details

Why Choose Flat Cutlery Set

Matched stainless steel flatware sets help buyers control design consistency, packing efficiency, and repeat order planning.

OEM/ODM Flatware Set Service

Customize set combination, logo, surface finish, handle profile, carton plan, and retail-ready packaging.

Packaging Options

Gift box, retail box, mailer box, window box, and bulk pack options are available by project requirement.

Quality Control

Material inspection, polishing checks, edge safety review, dishwasher-safe control, and final packing QC support bulk production.

Custom 20 Piece Sets Projects

Wholesale 20 piece stainless steel flatware sets for retail, home dining, gifting, private label and OEM projects.

20 Piece Sets Catalog
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-08-12 14:46:29 HTTP/2.0 GET : https://flatcutlery.com/products/flatware-set/20-piece?application=supermarket-retail
  2. 运行时间 : 0.349609s [ 吞吐率：2.86req/s ] 内存消耗：5,493.02kb 文件加载：145
  3. 缓存信息 : 0 reads,0 writes
  1. /www/wwwroot/flatcutlery/public/index.php ( 0.79 KB )
  2. /www/wwwroot/flatcutlery/vendor/autoload.php ( 0.17 KB )
  3. /www/wwwroot/flatcutlery/vendor/composer/autoload_real.php ( 2.49 KB )
  4. /www/wwwroot/flatcutlery/vendor/composer/platform_check.php ( 0.90 KB )
  5. /www/wwwroot/flatcutlery/vendor/composer/ClassLoader.php ( 14.03 KB )
  6. /www/wwwroot/flatcutlery/vendor/composer/autoload_static.php ( 4.90 KB )
  7. /www/wwwroot/flatcutlery/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /www/wwwroot/flatcutlery/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  9. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  10. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  11. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  12. /www/wwwroot/flatcutlery/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  13. /www/wwwroot/flatcutlery/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  14. /www/wwwroot/flatcutlery/vendor/symfony/polyfill-mbstring/bootstrap.php ( 0.35 KB )
  15. /www/wwwroot/flatcutlery/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.81 KB )
  16. /www/wwwroot/flatcutlery/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.49 KB )
  17. /www/wwwroot/flatcutlery/vendor/topthink/think-dumper/src/helper.php ( 0.18 KB )
  18. /www/wwwroot/flatcutlery/vendor/symfony/var-dumper/VarDumper.php ( 4.30 KB )
  19. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  20. /www/wwwroot/flatcutlery/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  21. /www/wwwroot/flatcutlery/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  22. /www/wwwroot/flatcutlery/app/provider.php ( 0.19 KB )
  23. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Http.php ( 6.22 KB )
  24. /www/wwwroot/flatcutlery/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  25. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  26. /www/wwwroot/flatcutlery/app/common.php ( 0.03 KB )
  27. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  28. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  29. /www/wwwroot/flatcutlery/config/app.php ( 0.95 KB )
  30. /www/wwwroot/flatcutlery/config/cache.php ( 1.60 KB )
  31. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  32. /www/wwwroot/flatcutlery/config/console.php ( 0.30 KB )
  33. /www/wwwroot/flatcutlery/config/cookie.php ( 0.56 KB )
  34. /www/wwwroot/flatcutlery/config/database.php ( 2.13 KB )
  35. /www/wwwroot/flatcutlery/config/filesystem.php ( 0.61 KB )
  36. /www/wwwroot/flatcutlery/config/lang.php ( 0.91 KB )
  37. /www/wwwroot/flatcutlery/config/legal.php ( 16.79 KB )
  38. /www/wwwroot/flatcutlery/config/log.php ( 1.35 KB )
  39. /www/wwwroot/flatcutlery/config/middleware.php ( 0.19 KB )
  40. /www/wwwroot/flatcutlery/config/route.php ( 1.89 KB )
  41. /www/wwwroot/flatcutlery/config/session.php ( 0.57 KB )
  42. /www/wwwroot/flatcutlery/config/sitemap.php ( 0.61 KB )
  43. /www/wwwroot/flatcutlery/config/trace.php ( 0.34 KB )
  44. /www/wwwroot/flatcutlery/config/view.php ( 0.99 KB )
  45. /www/wwwroot/flatcutlery/app/event.php ( 0.25 KB )
  46. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  47. /www/wwwroot/flatcutlery/app/service.php ( 0.13 KB )
  48. /www/wwwroot/flatcutlery/app/AppService.php ( 0.26 KB )
  49. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  50. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  51. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  52. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  53. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  54. /www/wwwroot/flatcutlery/vendor/services.php ( 0.14 KB )
  55. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  56. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  57. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  58. /www/wwwroot/flatcutlery/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  59. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  60. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  61. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  62. /www/wwwroot/flatcutlery/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  63. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  64. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  65. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  66. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  67. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  68. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  69. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  70. /www/wwwroot/flatcutlery/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  71. /www/wwwroot/flatcutlery/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  72. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  73. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  74. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  75. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  76. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  77. /www/wwwroot/flatcutlery/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  78. /www/wwwroot/flatcutlery/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  79. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  80. /www/wwwroot/flatcutlery/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  81. /www/wwwroot/flatcutlery/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  82. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  83. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  84. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  85. /www/wwwroot/flatcutlery/app/Request.php ( 0.09 KB )
  86. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  87. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  88. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  89. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  90. /www/wwwroot/flatcutlery/app/middleware.php ( 0.29 KB )
  91. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  92. /www/wwwroot/flatcutlery/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  93. /www/wwwroot/flatcutlery/app/middleware/AdminCsrf.php ( 2.02 KB )
  94. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  95. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  96. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  97. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  98. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  99. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  100. /www/wwwroot/flatcutlery/route/app.php ( 11.49 KB )
  101. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  102. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  103. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  104. /www/wwwroot/flatcutlery/app/controller/Site.php ( 221.75 KB )
  105. /www/wwwroot/flatcutlery/app/BaseController.php ( 2.96 KB )
  106. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  107. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  108. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  109. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  110. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  111. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  112. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  113. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  114. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  115. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  116. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  117. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  118. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  119. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  120. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  121. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  122. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  123. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  124. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  125. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  126. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  127. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  128. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  129. /www/wwwroot/flatcutlery/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  130. /www/wwwroot/flatcutlery/vendor/topthink/think-orm/src/db/Raw.php ( 1.30 KB )
  131. /www/wwwroot/flatcutlery/app/service/StructuredDataService.php ( 16.58 KB )
  132. /www/wwwroot/flatcutlery/app/controller/admin/Market.php ( 11.62 KB )
  133. /www/wwwroot/flatcutlery/view/site/flatware_set_list.html ( 8.16 KB )
  134. /www/wwwroot/flatcutlery/view/site/components/header.html ( 9.32 KB )
  135. /www/wwwroot/flatcutlery/view/site/components/structured_data.html ( 0.13 KB )
  136. /www/wwwroot/flatcutlery/view/site/components/sidebar.html ( 3.18 KB )
  137. /www/wwwroot/flatcutlery/view/site/components/product_bottom_cta.html ( 0.63 KB )
  138. /www/wwwroot/flatcutlery/view/site/components/footer.html ( 3.38 KB )
  139. /www/wwwroot/flatcutlery/app/service/ImageDimensionService.php ( 6.53 KB )
  140. /www/wwwroot/flatcutlery/app/common/SafeCache.php ( 0.82 KB )
  141. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
  142. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  143. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/response/Html.php ( 0.97 KB )
  144. /www/wwwroot/flatcutlery/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  145. /www/wwwroot/flatcutlery/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.015121s ] mysql:host=127.0.0.1;port=3306;dbname=flatcutlery_db;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fc_flatware_set_types` [ RunTime:0.002539s ]
  3. SELECT * FROM `fc_flatware_set_types` WHERE `slug` = '20-piece-sets' AND `status` = 1 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.002471s ]
  4. SHOW FULL COLUMNS FROM `fc_attributes` [ RunTime:0.014730s ]
  5. SELECT `id` FROM `fc_attributes` WHERE `attr_group` = 'application' AND `slug` = 'supermarket-retail' AND `status` = 1 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.001286s ]
  6. SHOW FULL COLUMNS FROM `fc_products` [ RunTime:0.003056s ]
  7. SELECT COUNT(DISTINCT `p`.`id`) AS think_count FROM `fc_products` `p` LEFT JOIN `fc_flatware_set_types` `fst` ON `fst`.`id`=`p`.`flatware_set_type_id` INNER JOIN `fc_product_attributes` `pa_application` ON `pa_application`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_application` ON `a_application`.`id`=`pa_application`.`attribute_id` WHERE `p`.`product_kind` = 'set' AND `p`.`flatware_set_type_id` = '7' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_application`.`attr_group` = 'application' AND `a_application`.`slug` = 'supermarket-retail' AND `a_application`.`status` = '1' AND `a_application`.`delete_time` IS NULL [ RunTime:0.002194s ]
  8. SELECT `p`.`id`,`p`.`name`,`p`.`slug`,`p`.`sku`,`p`.`main_image`,`p`.`short_description`,`p`.`spec_summary`,fst.name AS set_type_name FROM `fc_products` `p` LEFT JOIN `fc_flatware_set_types` `fst` ON `fst`.`id`=`p`.`flatware_set_type_id` INNER JOIN `fc_product_attributes` `pa_application` ON `pa_application`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_application` ON `a_application`.`id`=`pa_application`.`attribute_id` WHERE `p`.`product_kind` = 'set' AND `p`.`flatware_set_type_id` = '7' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_application`.`attr_group` = 'application' AND `a_application`.`slug` = 'supermarket-retail' AND `a_application`.`status` = '1' AND `a_application`.`delete_time` IS NULL GROUP BY `p`.`id` ORDER BY `p`.`is_recommended` DESC,`p`.`sort` ASC,`p`.`id` DESC LIMIT 0,20 [ RunTime:0.019345s ]
  9. SHOW FULL COLUMNS FROM `fc_product_attributes` [ RunTime:0.001576s ]
  10. SELECT `pa`.`product_id`,`a`.`attr_group`,`a`.`name` FROM `fc_product_attributes` `pa` INNER JOIN `fc_attributes` `a` ON `a`.`id`=`pa`.`attribute_id` WHERE `pa`.`product_id` IN ('107','38','36','34','32') AND `a`.`attr_group` IN ('finish','material','application') AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL ORDER BY `a`.`sort` ASC,`a`.`id` ASC [ RunTime:0.002045s ]
  11. SHOW FULL COLUMNS FROM `fc_product_images` [ RunTime:0.001265s ]
  12. SELECT * FROM `fc_product_images` WHERE `product_id` IN ('107','38','36','34','32') AND `type` IN ('main','set','gallery') ORDER BY FIELD(type, 'main', 'set', 'gallery'),`sort` ASC,`id` ASC [ RunTime:0.003485s ]
  13. SELECT a.attr_group, a.name, a.slug, COUNT(DISTINCT p.id) AS product_count FROM `fc_products` `p` INNER JOIN `fc_product_attributes` `pa` ON `pa`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a` ON `a`.`id`=`pa`.`attribute_id` WHERE `p`.`product_kind` = 'set' AND `p`.`flatware_set_type_id` = '7' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`attr_group` ASC,`a`.`sort` ASC,`a`.`id` ASC [ RunTime:0.001935s ]
  14. SHOW FULL COLUMNS FROM `fc_pages` [ RunTime:0.001603s ]
  15. SELECT * FROM `fc_pages` WHERE `status` = 1 AND `delete_time` IS NULL AND `url` = '/products/flatware-set/20-piece' LIMIT 1 [ RunTime:0.001096s ]
  16. CREATE TABLE IF NOT EXISTS `fc_markets` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(120) NOT NULL, `slug` VARCHAR(160) NOT NULL, `description` TEXT NULL, `image` VARCHAR(500) NULL, `seo_title` VARCHAR(255) NULL, `seo_description` VARCHAR(500) NULL, `sort` INT UNSIGNED NOT NULL DEFAULT 100, `status` TINYINT UNSIGNED NOT NULL DEFAULT 1, `created_at` DATETIME NULL, `updated_at` DATETIME NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_fc_markets_slug` (`slug`), KEY `idx_fc_markets_status_sort` (`status`, `sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.031252s ]
  17. CREATE TABLE IF NOT EXISTS `fc_product_markets` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` BIGINT UNSIGNED NOT NULL, `market_id` BIGINT UNSIGNED NOT NULL, `sort` INT UNSIGNED NOT NULL DEFAULT 100, `created_at` DATETIME NULL, `updated_at` DATETIME NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_fc_product_markets_product_market` (`product_id`, `market_id`), KEY `idx_fc_product_markets_market_sort` (`market_id`, `sort`), KEY `idx_fc_product_markets_product` (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.041165s ]
  18. SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.001420s ]
  19. SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000890s ]
  20. SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000948s ]
  21. SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000916s ]
  22. SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.001440s ]
  23. SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000785s ]
  24. SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000925s ]
  25. SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000911s ]
  26. CREATE TABLE IF NOT EXISTS `fc_markets` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(120) NOT NULL, `slug` VARCHAR(160) NOT NULL, `description` TEXT NULL, `image` VARCHAR(500) NULL, `seo_title` VARCHAR(255) NULL, `seo_description` VARCHAR(500) NULL, `sort` INT UNSIGNED NOT NULL DEFAULT 100, `status` TINYINT UNSIGNED NOT NULL DEFAULT 1, `created_at` DATETIME NULL, `updated_at` DATETIME NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_fc_markets_slug` (`slug`), KEY `idx_fc_markets_status_sort` (`status`, `sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.047745s ]
  27. CREATE TABLE IF NOT EXISTS `fc_product_markets` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` BIGINT UNSIGNED NOT NULL, `market_id` BIGINT UNSIGNED NOT NULL, `sort` INT UNSIGNED NOT NULL DEFAULT 100, `created_at` DATETIME NULL, `updated_at` DATETIME NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_fc_product_markets_product_market` (`product_id`, `market_id`), KEY `idx_fc_product_markets_market_sort` (`market_id`, `sort`), KEY `idx_fc_product_markets_product` (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.023528s ]
  28. SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000950s ]
  29. SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000842s ]
  30. SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000864s ]
  31. SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000866s ]
  32. SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000888s ]
  33. SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000918s ]
  34. SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000920s ]
0.350868s