海合咨询

基本文件流程错误 SQL 调试

/www/web/hh_fonwi_com/public_html/index.php ( 0.24 KB )
/www/web/hh_fonwi_com/source/thinkphp/start.php ( 0.72 KB )
/www/web/hh_fonwi_com/source/thinkphp/base.php ( 2.60 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Loader.php ( 21.07 KB )
/www/web/hh_fonwi_com/source/vendor/composer/autoload_static.php ( 18.66 KB )
/www/web/hh_fonwi_com/source/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/web/hh_fonwi_com/source/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/web/hh_fonwi_com/source/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/web/hh_fonwi_com/source/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/web/hh_fonwi_com/source/vendor/guzzlehttp/psr7/src/functions.php ( 13.09 KB )
/www/web/hh_fonwi_com/source/vendor/paragonie/random_compat/lib/random.php ( 7.79 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/polyfill-intl-normalizer/bootstrap.php ( 0.62 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/polyfill-php70/bootstrap.php ( 0.85 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.50 KB )
/www/web/hh_fonwi_com/source/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/web/hh_fonwi_com/source/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/deprecation-contracts/function.php ( 0.98 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/polyfill-ctype/bootstrap.php ( 1.50 KB )
/www/web/hh_fonwi_com/source/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.07 KB )
/www/web/hh_fonwi_com/source/vendor/khanamiryan/qrcode-detector-decoder/lib/common/customFunctions.php ( 1.75 KB )
/www/web/hh_fonwi_com/source/vendor/qcloud/cos-sdk-v5/src/Qcloud/Cos/Common.php ( 1.33 KB )
/www/web/hh_fonwi_com/source/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 8.20 KB )
/www/web/hh_fonwi_com/source/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 3.56 KB )
/www/web/hh_fonwi_com/source/vendor/topthink/think-captcha/src/helper.php ( 1.94 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Route.php ( 60.23 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Config.php ( 6.38 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Validate.php ( 41.63 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Error.php ( 3.75 KB )
/www/web/hh_fonwi_com/source/thinkphp/convention.php ( 10.37 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/App.php ( 21.51 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Request.php ( 49.78 KB )
/www/web/hh_fonwi_com/source/application/config.php ( 8.12 KB )
/www/web/hh_fonwi_com/source/application/database.php ( 1.49 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Hook.php ( 4.71 KB )
/www/web/hh_fonwi_com/source/application/tags.php ( 1.79 KB )
/www/web/hh_fonwi_com/source/application/task/behavior/Order.php ( 6.47 KB )
/www/web/hh_fonwi_com/source/application/common.php ( 9.90 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Env.php ( 1.21 KB )
/www/web/hh_fonwi_com/source/thinkphp/helper.php ( 17.30 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Lang.php ( 7.23 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Log.php ( 6.05 KB )
/www/web/hh_fonwi_com/source/thinkphp/lang/zh-cn.php ( 11.81 KB )
/www/web/hh_fonwi_com/source/application/route.php ( 1.02 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Url.php ( 12.72 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Debug.php ( 7.13 KB )
/www/web/hh_fonwi_com/source/application/common/behavior/App.php ( 0.66 KB )
/www/web/hh_fonwi_com/source/application/home/config.php ( 1.07 KB )
/www/web/hh_fonwi_com/source/application/home/tags.php ( 0.75 KB )
/www/web/hh_fonwi_com/source/application/home/common.php ( 1.82 KB )
/www/web/hh_fonwi_com/source/application/home/controller/Cat.php ( 3.94 KB )
/www/web/hh_fonwi_com/source/application/home/controller/Controller.php ( 5.66 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Controller.php ( 6.07 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/View.php ( 6.77 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Template.php ( 44.90 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/template/driver/File.php ( 2.21 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Session.php ( 10.86 KB )
/www/web/hh_fonwi_com/source/application/home/model/setting/Config.php ( 0.99 KB )
/www/web/hh_fonwi_com/source/application/common/model/setting/Config.php ( 0.23 KB )
/www/web/hh_fonwi_com/source/application/common/model/BaseModel.php ( 3.93 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Model.php ( 69.14 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Db.php ( 6.67 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/db/Query.php ( 93.74 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/db/builder/Mysql.php ( 4.53 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/db/Builder.php ( 31.55 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Cache.php ( 6.10 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/cache/driver/File.php ( 7.27 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
/www/web/hh_fonwi_com/source/application/home/model/content/Menu.php ( 2.07 KB )
/www/web/hh_fonwi_com/source/application/common/model/content/Menu.php ( 0.42 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/model/Collection.php ( 2.27 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Collection.php ( 10.91 KB )
/www/web/hh_fonwi_com/source/application/home/model/setting/Pic2.php ( 1.07 KB )
/www/web/hh_fonwi_com/source/application/common/model/setting/Pic2.php ( 0.22 KB )
/www/web/hh_fonwi_com/source/application/home/model/setting/Pic.php ( 1.06 KB )
/www/web/hh_fonwi_com/source/application/common/model/setting/Pic.php ( 0.22 KB )
/www/web/hh_fonwi_com/source/application/home/model/setting/Follow.php ( 1.08 KB )
/www/web/hh_fonwi_com/source/application/common/model/setting/Follow.php ( 0.23 KB )
/www/web/hh_fonwi_com/source/application/home/model/content/Footlink.php ( 1.66 KB )
/www/web/hh_fonwi_com/source/application/common/model/content/Footlink.php ( 1.07 KB )
/www/web/hh_fonwi_com/source/application/home/model/Goods.php ( 14.49 KB )
/www/web/hh_fonwi_com/source/application/common/model/Goods.php ( 12.32 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/model/relation/HasMany.php ( 9.97 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/model/Relation.php ( 3.61 KB )
/www/web/hh_fonwi_com/source/application/home/model/GoodsImage.php ( 0.33 KB )
/www/web/hh_fonwi_com/source/application/common/model/GoodsImage.php ( 0.47 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/model/relation/BelongsTo.php ( 7.75 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/model/relation/OneToOne.php ( 10.03 KB )
/www/web/hh_fonwi_com/source/application/home/model/UploadFile.php ( 0.33 KB )
/www/web/hh_fonwi_com/source/application/common/model/UploadFile.php ( 1.72 KB )
/www/web/hh_fonwi_com/source/application/home/model/ExchangeRate.php ( 3.27 KB )
/www/web/hh_fonwi_com/source/application/common/model/ExchangeRate.php ( 0.41 KB )
/www/web/hh_fonwi_com/source/application/home/model/GoodsSku.php ( 1.79 KB )
/www/web/hh_fonwi_com/source/application/common/model/GoodsSku.php ( 0.67 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Cookie.php ( 7.54 KB )
/www/web/hh_fonwi_com/source/application/home/model/Country.php ( 0.19 KB )
/www/web/hh_fonwi_com/source/application/common/model/Country.php ( 1.15 KB )
/www/web/hh_fonwi_com/source/application/home/model/setting/Oauth.php ( 1.45 KB )
/www/web/hh_fonwi_com/source/application/common/model/setting/Oauth.php ( 0.46 KB )
/www/web/hh_fonwi_com/source/application/home/model/Cat.php ( 23.46 KB )
/www/web/hh_fonwi_com/source/application/home/model/Category.php ( 0.64 KB )
/www/web/hh_fonwi_com/source/application/common/model/Category.php ( 3.28 KB )
/www/web/hh_fonwi_com/source/application/home/model/Brand.php ( 0.21 KB )
/www/web/hh_fonwi_com/source/application/common/model/Brand.php ( 0.76 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/web/hh_fonwi_com/source/application/home/model/GoodsAttr.php ( 1.17 KB )
/www/web/hh_fonwi_com/source/application/common/model/GoodsAttr.php ( 0.37 KB )
/www/web/hh_fonwi_com/source/application/home/model/GoodsAttrSel.php ( 1.04 KB )
/www/web/hh_fonwi_com/source/application/common/model/GoodsAttrSel.php ( 0.21 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.23 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Paginator.php ( 9.75 KB )
/www/web/hh_fonwi_com/source/runtime/temp/a69eebabb11100c0740ba01e1d55b53c.php ( 70.02 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/Response.php ( 8.28 KB )
/www/web/hh_fonwi_com/source/thinkphp/library/think/debug/Html.php ( 4.17 KB )

[ DB ] CONNECT:[ UseTime:0.000301s ] mysql:host=localhost;port=3306;dbname=hhdbdb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.000942s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `goods_status` = 10 AND `is_delete` = 0 ORDER BY `goods_sort`,`goods_id` DESC LIMIT 10 [ RunTime:0.001087s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.002451s ]
[ SQL ] SELECT * FROM `fwshop_goods_image` WHERE `fwshop_goods_image`.`wxapp_id` = '10001' AND `goods_id` IN (105,104,103,102,101,100,99,98,97,96) ORDER BY `id` ASC [ RunTime:0.000622s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000671s ]
[ SQL ] SELECT * FROM `fwshop_upload_file` WHERE `fwshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (752,753,754,755,756,758,757,759,760,761) [ RunTime:0.001181s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.000970s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 105 ORDER BY `goods_sku_id` ASC [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 104 ORDER BY `goods_sku_id` ASC [ RunTime:0.000413s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 103 ORDER BY `goods_sku_id` ASC [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 102 ORDER BY `goods_sku_id` ASC [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 101 ORDER BY `goods_sku_id` ASC [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 100 ORDER BY `goods_sku_id` ASC [ RunTime:0.000251s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 99 ORDER BY `goods_sku_id` ASC [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 98 ORDER BY `goods_sku_id` ASC [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 97 ORDER BY `goods_sku_id` ASC [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 96 ORDER BY `goods_sku_id` ASC [ RunTime:0.000262s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_category` [ RunTime:0.000958s ]
[ SQL ] SELECT * FROM `fwshop_category` WHERE `fwshop_category`.`wxapp_id` = '10001' AND `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC,`category_id` ASC [ RunTime:0.000334s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' AND (`category_id` LIKE '%,55,%') LIMIT 1 [ RunTime:0.000443s ]
[ SQL ] SELECT DISTINCT `brand_id` FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' [ RunTime:0.001476s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_attr` [ RunTime:0.000861s ]
[ SQL ] SELECT * FROM `fwshop_goods_attr` WHERE `fwshop_goods_attr`.`wxapp_id` = '10001' AND `category_id` IN ('') AND `status` = 1 ORDER BY `sort` ASC,`attr_id` ASC [ RunTime:0.000380s ]
[ SQL ] SELECT DISTINCT MIN(goods_price) AS tp_min FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' LIMIT 1 [ RunTime:0.000395s ]
[ SQL ] SELECT DISTINCT MAX(goods_price) AS tp_max FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' AND `discount` BETWEEN 0.001 AND 24.999 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' AND `discount` BETWEEN 25 AND 50 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' AND `discount` BETWEEN 50.001 AND 75 LIMIT 1 [ RunTime:0.000437s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' AND `discount` BETWEEN 75.001 AND 99.99 LIMIT 1 [ RunTime:0.000331s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'A%' ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,12 [ RunTime:0.000447s ]