扬州玩具网

基本文件流程错误 SQL 调试

D:\phpstudy_pro\WWW\www.yztoy.com\index.php ( 0.81 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\base.php ( 1.71 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Loader.php ( 12.70 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\vendor\composer\autoload_static.php ( 1.83 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Error.php ( 4.00 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Container.php ( 15.53 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\App.php ( 26.71 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Env.php ( 2.85 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Config.php ( 9.71 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\convention.php ( 11.74 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\tags.php ( 0.96 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Hook.php ( 5.58 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\common.php ( 4.90 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\helper.php ( 20.40 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\provider.php ( 0.62 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\app.php ( 5.77 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\facade\Env.php ( 1.17 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Facade.php ( 3.44 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\cache.php ( 0.95 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\console.php ( 0.91 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\cookie.php ( 1.11 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\database.php ( 2.23 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\log.php ( 1.16 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\middleware.php ( 0.85 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\session.php ( 1.06 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\template.php ( 1.75 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\config\trace.php ( 0.84 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\vendor\topthink\think-captcha\src\helper.php ( 1.54 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\facade\Route.php ( 3.83 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Route.php ( 25.79 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Request.php ( 57.50 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\route\Domain.php ( 7.07 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\route\RuleGroup.php ( 16.45 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\route\Rule.php ( 28.92 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\route\RuleItem.php ( 8.84 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\route\RuleName.php ( 3.92 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\facade\Validate.php ( 4.83 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Validate.php ( 43.85 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Db.php ( 7.67 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Lang.php ( 7.38 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Log.php ( 8.92 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\log\driver\File.php ( 8.97 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\lang\zh-cn.php ( 12.58 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\route\route.php ( 1.22 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\route\dispatch\Module.php ( 5.19 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\route\Dispatch.php ( 9.26 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Middleware.php ( 5.34 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Cookie.php ( 7.35 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\View.php ( 5.74 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\view\driver\Think.php ( 6.12 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Template.php ( 47.31 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\template\driver\File.php ( 2.29 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Session.php ( 14.13 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Debug.php ( 7.57 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Cache.php ( 3.27 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\cache\driver\File.php ( 7.99 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\cache\Driver.php ( 8.64 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\index\controller\Category.php ( 7.59 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\index\controller\Base.php ( 2.64 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Controller.php ( 7.53 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\traits\controller\Jump.php ( 4.76 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\index\model\Article.php ( 0.70 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Model.php ( 27.48 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\model\concern\Attribute.php ( 17.64 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\model\concern\RelationShip.php ( 19.85 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\model\concern\ModelEvent.php ( 6.04 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\model\concern\TimeStamp.php ( 2.58 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\model\concern\Conversion.php ( 7.83 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\facade\Cache.php ( 2.06 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\index\model\Cate.php ( 1.12 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\db\Connection.php ( 58.93 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\db\connector\Mysql.php ( 6.24 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\db\builder\Mysql.php ( 5.54 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\db\Builder.php ( 36.78 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\db\Query.php ( 105.00 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\model\Collection.php ( 2.80 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Collection.php ( 13.59 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\facade\Session.php ( 2.05 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\index\model\Conf.php ( 0.34 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\index\model\Category.php ( 1.76 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\db\Expression.php ( 1.11 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\application\index\model\Goods.php ( 5.83 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\extend\catetree\Catetree.php ( 1.80 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\paginator\driver\Bootstrap.php ( 5.25 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Paginator.php ( 9.83 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Response.php ( 9.68 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\response\View.php ( 2.77 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\runtime\temp\3d605983f3612aa8d6e3e5ef1d83e144.php ( 53.04 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\facade\Url.php ( 1.13 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\Url.php ( 13.22 KB )
D:\phpstudy_pro\WWW\www.yztoy.com\thinkphp\library\think\debug\Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.001801s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fc_cate` [ RunTime:0.001015s ]
[ SQL ] SELECT * FROM `fc_cate` WHERE `cate_type` = 3 ORDER BY `sort` DESC [ RunTime:0.000433s ]
[ SQL ] SHOW COLUMNS FROM `fc_article` [ RunTime:0.000808s ]
[ SQL ] SELECT * FROM `fc_article` WHERE `cate_id` = 4 [ RunTime:0.000399s ]
[ SQL ] SELECT * FROM `fc_article` WHERE `cate_id` = 5 [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `fc_article` WHERE `cate_id` = 7 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `fc_article` WHERE `cate_id` = 16 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `fc_article` WHERE `cate_id` = 17 [ RunTime:0.000369s ]
[ SQL ] SELECT `id`,`title` FROM `fc_article` WHERE `cate_id` = 3 [ RunTime:0.000287s ]
[ DB ] CONNECT:[ UseTime:0.006265s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fc_user` [ RunTime:0.000854s ]
[ SQL ] SELECT `u`.`id`,`u`.`hytype`,`u`.`username`,`i`.`avatar_src` FROM `fc_user` `u` INNER JOIN `fc_user_info` `i` ON `u`.`id`=`i`.`user_id` WHERE `u`.`id` IS NULL LIMIT 1 [ RunTime:0.000328s ]
[ DB ] CONNECT:[ UseTime:0.012653s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fc_nav` [ RunTime:0.001017s ]
[ SQL ] SELECT * FROM `fc_nav` ORDER BY `sort` ASC [ RunTime:0.000434s ]
[ SQL ] SHOW COLUMNS FROM `fc_conf` [ RunTime:0.000791s ]
[ SQL ] SELECT `ename`,`value` FROM `fc_conf` [ RunTime:0.000358s ]
[ SQL ] SHOW COLUMNS FROM `fc_category` [ RunTime:0.000741s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 0 ORDER BY `sort` ASC [ RunTime:0.000475s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 7 [ RunTime:0.000334s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 2 [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 33 [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 38 [ RunTime:0.000302s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 40 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 41 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 42 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 43 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 44 [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 45 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 46 [ RunTime:0.000303s ]
[ SQL ] SELECT * FROM `fc_category` WHERE `pid` = 47 [ RunTime:0.000290s ]
[ DB ] CONNECT:[ UseTime:0.004357s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT * FROM `fc_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000417s ]
[ DB ] CONNECT:[ UseTime:0.015263s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fc_attr` [ RunTime:0.001050s ]
[ SQL ] SELECT `id`,`attr_name` FROM `fc_attr` WHERE `id` = 21 [ RunTime:0.000363s ]
[ DB ] CONNECT:[ UseTime:0.013733s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fc_goods_attr` [ RunTime:0.000960s ]
[ SQL ] SELECT `attr_value`,`attr_id`,`goods_id` FROM `fc_goods_attr` WHERE `attr_id` = 21 [ RunTime:0.000354s ]
[ DB ] CONNECT:[ UseTime:0.013810s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fc_goods` [ RunTime:0.001045s ]
[ SQL ] SELECT DISTINCT `brand_id` FROM `fc_goods` WHERE `category_id` = 2 [ RunTime:0.000387s ]
[ DB ] CONNECT:[ UseTime:0.013286s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fc_brand` [ RunTime:0.000948s ]
[ SQL ] SELECT `id`,`brand_name` FROM `fc_brand` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000344s ]
[ DB ] CONNECT:[ UseTime:0.013547s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT MIN(shop_price) min_price, MAX(shop_price) max_price FROM `fc_goods` WHERE `category_id` = 2 LIMIT 1 [ RunTime:0.000517s ]
[ DB ] CONNECT:[ UseTime:0.014804s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fc_goods` WHERE `category_id` = 2 AND `on_sale` = 1 AND `shop_price` BETWEEN '44' AND '59' [ RunTime:0.000644s ]
[ DB ] CONNECT:[ UseTime:0.044532s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fc_goods` WHERE `category_id` = 2 AND `on_sale` = 1 AND `shop_price` BETWEEN '60' AND '69' [ RunTime:0.000592s ]
[ DB ] CONNECT:[ UseTime:0.004454s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fc_goods` WHERE `category_id` = 2 AND `on_sale` = 1 AND `shop_price` BETWEEN '70' AND '79' [ RunTime:0.000583s ]
[ DB ] CONNECT:[ UseTime:0.014863s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fc_goods` WHERE `category_id` = 2 AND `on_sale` = 1 AND `shop_price` BETWEEN '80' AND '89' [ RunTime:0.000552s ]
[ DB ] CONNECT:[ UseTime:0.019003s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fc_goods` WHERE `category_id` = 2 AND `on_sale` = 1 AND `shop_price` BETWEEN '90' AND '99' [ RunTime:0.000573s ]
[ DB ] CONNECT:[ UseTime:0.009490s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT `id`,`pid` FROM `fc_category` [ RunTime:0.000486s ]
[ DB ] CONNECT:[ UseTime:0.013538s ] mysql:host=localhost;dbname=zky_yzfc_yztoy;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fc_goods` `g` LEFT JOIN `fc_order_goods` `b` ON `g`.`id`=b.goods_id AND b.order_id IN(SELECT id FROM fc_order WHERE pay_status=1) WHERE `g`.`on_sale` = 1 AND `g`.`category_id` = 2 GROUP BY `g`.`id` ) `_group_count_` [ RunTime:0.000852s ]
[ SQL ] SELECT g.id, g.goods_name, g.shop_price price, g.time, g.mid_thumb, IFNULL(SUM(b.goods_num), 0) xl, (SELECT COUNT(id) FROM fc_comment c WHERE g.id=c.goods_id) pl, (SELECT group_concat(mid_photo) FROM fc_goods_photo gp WHERE g.id=gp.goods_id) mid_photo, (SELECT group_concat(id) FROM fc_recpos WHERE rec_type=1 AND id IN(SELECT recpos_id FROM fc_rec_item WHERE value_type=1 AND g.id=value_id)) recpos FROM `fc_goods` `g` LEFT JOIN `fc_order_goods` `b` ON `g`.`id`=b.goods_id AND b.order_id IN(SELECT id FROM fc_order WHERE pay_status=1) WHERE `g`.`on_sale` = 1 AND `g`.`category_id` = 2 GROUP BY `g`.`id` ORDER BY `xl` DESC LIMIT 0,24 [ RunTime:0.001073s ]

猜你喜欢

1

2

3

4

新手上路

配送与支付

会员中心

服务保证

联系我们