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.004618s ] mysql:host=udm821017170.my3w.com;dbname=udm821017170_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `categories` [ RunTime:0.003324s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002545s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002521s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002521s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002518s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002465s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005603s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002623s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002490s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002480s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002539s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002433s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002505s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002460s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002525s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002473s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002468s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002470s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002519s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002596s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002522s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002495s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002470s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002436s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002564s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002496s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002489s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002497s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002424s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002566s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002462s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002493s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002618s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002520s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 0 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002546s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 22 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002654s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 4 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002618s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 5 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002477s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 6 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002491s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 7 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002489s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 8 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002444s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 9 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002488s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 10 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002441s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 11 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002514s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 15 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002536s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 16 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002509s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 32 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002517s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 17 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002476s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 18 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002602s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 19 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002496s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 20 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002529s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 21 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002481s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 23 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002545s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 27 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002414s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 30 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002491s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 31 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002440s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 24 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002514s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 33 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002453s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 35 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002455s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 25 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002468s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 28 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002508s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 29 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002521s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 36 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002478s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 37 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002717s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 38 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002696s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 26 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002626s ]
[ SQL ] SELECT * FROM `categories` WHERE `parent_id` = 34 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002653s ]
[ SQL ] SELECT `id`,`parent_id` FROM `categories` WHERE `is_show` = 1 [ RunTime:0.002516s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 6 LIMIT 1 [ RunTime:0.002709s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 5 LIMIT 1 [ RunTime:0.002621s ]
[ SQL ] SELECT * FROM `categories` WHERE `id` = 4 LIMIT 1 [ RunTime:0.002490s ]
[ SQL ] SHOW COLUMNS FROM `products` [ RunTime:0.003290s ]
[ 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.002967s ]
[ 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.002896s ]

Filters Clear All

Price

Minimum Order

Filters Clear All

Price

Minimum Order

Product Title

Available Colours: