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.107483s ] mysql:host=udm821017170.my3w.com;dbname=udm821017170_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `categories` [ RunTime:0.007736s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007435s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006839s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008179s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008154s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008756s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008184s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007847s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007652s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007695s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006163s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006694s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009259s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009989s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007604s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007729s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004978s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003375s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003855s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006596s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.081797s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.268402s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.011370s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004794s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004590s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005400s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007350s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007573s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008827s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008186s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008071s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008780s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008067s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008183s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008058s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008074s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008109s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008145s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008111s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008129s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008096s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008136s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008183s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009290s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.011938s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010949s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009918s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010895s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010852s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010832s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010802s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010969s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010781s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010849s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010912s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010926s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010981s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010792s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010901s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010875s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010727s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010992s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010893s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010943s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010848s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010914s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010848s ]
[ SQL ] SELECT `id`,`parent_id` FROM `categories` WHERE `is_show` = 1 [ RunTime:0.010569s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 6 LIMIT 1 [ RunTime:0.010479s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 5 LIMIT 1 [ RunTime:0.010414s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 4 LIMIT 1 [ RunTime:0.010487s ]
[ SQL ] SHOW COLUMNS FROM `products` [ RunTime:0.010843s ]
[ 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.011834s ]
[ 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.013094s ]

Filters Clear All

Price

Minimum Order

Filters Clear All

Price

Minimum Order

Product Title

Available Colours: