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.025168s ] mysql:host=udm821017170.my3w.com;dbname=udm821017170_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `categories` [ RunTime:0.013282s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.017939s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.017528s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.012287s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.259229s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.116599s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.015504s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.018491s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013771s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013886s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.017598s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013631s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.087465s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.185996s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.117201s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.021610s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.017166s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.020862s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.021209s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.186326s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.021046s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.014658s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.088110s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.114242s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.017419s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016523s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019043s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013855s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016492s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016541s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.017015s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016446s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016518s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016329s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016479s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016426s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019932s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019230s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019244s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019082s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019212s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019253s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019263s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019247s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019300s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019214s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019256s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019239s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019290s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019272s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019269s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019226s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019291s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019237s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019306s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019290s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019148s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019260s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019614s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.018905s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019206s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019206s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019250s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019215s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019316s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019192s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.021704s ]
[ SQL ] SELECT `id`,`parent_id` FROM `categories` WHERE `is_show` = 1 [ RunTime:0.018044s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 6 LIMIT 1 [ RunTime:0.020019s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 5 LIMIT 1 [ RunTime:0.018332s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 4 LIMIT 1 [ RunTime:0.018794s ]
[ SQL ] SHOW COLUMNS FROM `products` [ RunTime:0.019798s ]
[ 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.020506s ]
[ 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.020717s ]

Filters Clear All

Price

Minimum Order

Filters Clear All

Price

Minimum Order

Product Title

Available Colours: