Product List

基本文件流程错误 SQL 调试

/usr/home/wh-augtb74n2lh0dzr99on/htdocs/public/index.php ( 0.82 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/base.php ( 1.71 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Loader.php ( 12.70 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/vendor/composer/autoload_static.php ( 1.44 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Error.php ( 4.00 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Container.php ( 17.20 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/App.php ( 26.63 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Env.php ( 2.85 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Config.php ( 9.71 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/convention.php ( 11.74 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/application/tags.php ( 0.96 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Hook.php ( 5.58 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/application/common.php ( 0.60 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/helper.php ( 20.40 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/application/provider.php ( 0.62 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/app.php ( 5.50 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Facade.php ( 3.44 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/cache.php ( 0.95 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/console.php ( 0.91 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/cookie.php ( 1.11 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/database.php ( 2.19 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/log.php ( 1.16 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/middleware.php ( 0.85 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/session.php ( 1.06 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/template.php ( 1.46 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/config/trace.php ( 0.84 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Db.php ( 7.67 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Lang.php ( 7.56 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Request.php ( 57.54 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Log.php ( 8.92 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/lang/zh-cn.php ( 12.58 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/route/route.php ( 1.10 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/facade/Route.php ( 3.84 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Route.php ( 25.84 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/Domain.php ( 7.08 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/dispatch/Url.php ( 5.24 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/route/dispatch/Module.php ( 5.19 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Middleware.php ( 5.34 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Cookie.php ( 7.35 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/View.php ( 5.74 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Template.php ( 47.31 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Session.php ( 14.13 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Debug.php ( 7.57 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Cache.php ( 3.27 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/application/index/controller/Index.php ( 9.14 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/application/index/controller/Base.php ( 0.36 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Controller.php ( 7.53 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/application/common/model/Category.php ( 1.68 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Model.php ( 28.59 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/model/concern/RelationShip.php ( 20.60 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/db/Builder.php ( 36.76 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/db/Query.php ( 105.00 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/model/Collection.php ( 3.23 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Collection.php ( 13.60 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.25 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Paginator.php ( 9.83 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Response.php ( 9.68 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/response/View.php ( 2.77 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/runtime/temp/4f9a4442bfbe2065bfdb4b03c4160ce2.php ( 49.25 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/Url.php ( 13.22 KB )
/usr/home/wh-augtb74n2lh0dzr99on/htdocs/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.003807s ] mysql:host=udm821017170.my3w.com;dbname=udm821017170_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `categories` [ RunTime:0.004524s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001911s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001924s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001896s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002060s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001902s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001900s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001876s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001930s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001854s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001854s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001858s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001948s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001937s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001845s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001861s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002016s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001906s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002131s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002692s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002626s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002669s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002712s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002670s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002591s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002693s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002668s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002651s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002605s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002698s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002670s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002707s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002621s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002659s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005273s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001993s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001892s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001892s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002096s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002653s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002679s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002694s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002676s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002638s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002671s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002619s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002688s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002716s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002623s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002759s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002750s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002744s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002439s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002645s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002711s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006277s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001992s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001931s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001893s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001865s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001893s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002572s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002617s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002698s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002702s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002924s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002378s ]
[ SQL ] SELECT `id`,`parent_id` FROM `categories` WHERE `is_show` = 1 [ RunTime:0.002375s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 6 LIMIT 1 [ RunTime:0.002418s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 5 LIMIT 1 [ RunTime:0.002090s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 4 LIMIT 1 [ RunTime:0.002227s ]
[ SQL ] SHOW COLUMNS FROM `products` [ RunTime:0.008977s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM products p LEFT JOIN `product_skus` `sku` ON `p`.`id`=`sku`.`product_id` WHERE `p`.`is_on_sale` = 1 AND `sku`.`is_default` = 1 AND `sku`.`status` = 1 AND `p`.`category_id` = 6 AND `p`.`name` LIKE '%%' [ RunTime:0.002468s ]
[ SQL ] SELECT `p`.`id`,`p`.`name`,`p`.`moq`,`p`.`short_desc`,`p`.`is_hot`,`p`.`is_new`,`sku`.`price`,`sku`.`stock` FROM products p LEFT JOIN `product_skus` `sku` ON `p`.`id`=`sku`.`product_id` WHERE `p`.`is_on_sale` = 1 AND `sku`.`is_default` = 1 AND `sku`.`status` = 1 AND `p`.`category_id` = 6 AND `p`.`name` LIKE '%%' ORDER BY `p`.`sort` ASC,`p`.`id` DESC LIMIT 0,12 [ RunTime:0.002218s ]

Filters Clear All

Price

Minimum Order

Filters Clear All

Price

Minimum Order

Product Title

Available Colours: