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.011075s ] mysql:host=udm821017170.my3w.com;dbname=udm821017170_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `categories` [ RunTime:0.009628s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010185s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008963s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010911s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010901s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010893s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010969s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010916s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010963s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010995s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010947s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010958s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010801s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010931s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010942s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010883s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.011749s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010583s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010449s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010605s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009379s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.011868s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.012979s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010322s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010900s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009024s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007988s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.080986s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.106433s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008046s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.011945s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003492s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008125s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008926s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006912s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007661s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007723s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006203s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005407s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013392s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001950s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010532s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007629s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007893s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005075s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003929s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004629s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006839s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.128345s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.058174s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008663s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003384s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005423s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005375s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006581s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.125538s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.055446s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005191s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005920s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005418s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005389s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005381s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005481s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005338s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005353s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005474s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005390s ]
[ SQL ] SELECT `id`,`parent_id` FROM `categories` WHERE `is_show` = 1 [ RunTime:0.005399s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 6 LIMIT 1 [ RunTime:0.005282s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 5 LIMIT 1 [ RunTime:0.004895s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 4 LIMIT 1 [ RunTime:0.005089s ]
[ SQL ] SHOW COLUMNS FROM `products` [ RunTime:0.005355s ]
[ 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.034238s ]
[ 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.011258s ]

Filters Clear All

Price

Minimum Order

Filters Clear All

Price

Minimum Order

Product Title

Available Colours: