海合咨询

基本文件流程错误 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/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/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/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/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/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/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.000456s ] mysql:host=localhost;port=3306;dbname=hhdbdb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.002488s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.001173s ]
[ 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.000403s ]
[ 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.000627s ]
[ 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.000431s ]
[ 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.000426s ]
[ 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.000406s ]
[ 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.000629s ]
[ 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.000563s ]
[ 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.000589s ]
[ 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.000531s ]
[ 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.000493s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_category` [ RunTime:0.001096s ]
[ 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.000386s ]
[ 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 'W%' AND (`category_id` LIKE '%,55,%') LIMIT 1 [ RunTime:0.000539s ]
[ 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 'W%' [ RunTime:0.000347s ]
[ 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 'W%' AND `brand_id` = 1 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_brand` [ RunTime:0.000861s ]
[ SQL ] SELECT `name` FROM `fwshop_brand` WHERE `fwshop_brand`.`wxapp_id` = '10001' AND `brand_id` = 1 LIMIT 1 [ RunTime:0.000431s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_attr` [ RunTime:0.000709s ]
[ 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.000278s ]
[ 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 'W%' LIMIT 1 [ RunTime:0.000330s ]
[ 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 'W%' LIMIT 1 [ RunTime:0.000266s ]
[ 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 'W%' AND `discount` BETWEEN 0.001 AND 24.999 LIMIT 1 [ RunTime:0.000257s ]
[ 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 'W%' AND `discount` BETWEEN 25 AND 50 LIMIT 1 [ RunTime:0.000327s ]
[ 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 'W%' AND `discount` BETWEEN 50.001 AND 75 LIMIT 1 [ RunTime:0.000341s ]
[ 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 'W%' AND `discount` BETWEEN 75.001 AND 99.99 LIMIT 1 [ RunTime:0.000372s ]
[ 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 'W%' LIMIT 1 [ RunTime:0.000377s ]
[ 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 'W%' ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,12 [ RunTime:0.000605s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.000840s ]
[ SQL ] SELECT * FROM `fwshop_goods_image` WHERE `fwshop_goods_image`.`wxapp_id` = '10001' AND `goods_id` IN (103,102,100) ORDER BY `id` ASC [ RunTime:0.000462s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000753s ]
[ SQL ] SELECT * FROM `fwshop_upload_file` WHERE `fwshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (754,755,757) [ RunTime:0.000546s ]
[ 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.000458s ]
[ 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.000652s ]
[ 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.000335s ]