没弄清楚这些关键点，乱用磷酸二氢钾，算“白瞎”了！

2025-03-22

做任何事情都应该事先摸清其中的规模，因为做事就该像做学问一样，条条是道，否则花了很多的时间和精力，却收获不多。而今天所要介绍的肥料

店铺商品销售排行榜

标签

店铺商品销售排行榜

基本文件流程错误 SQL 调试

/www/wwwroot/lvzhi/index.php ( 0.80 KB )
/www/wwwroot/lvzhi/thinkphp/start.php ( 0.72 KB )
/www/wwwroot/lvzhi/thinkphp/base.php ( 2.60 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Loader.php ( 21.07 KB )
/www/wwwroot/lvzhi/vendor/composer/autoload_static.php ( 8.87 KB )
/www/wwwroot/lvzhi/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.07 KB )
/www/wwwroot/lvzhi/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/wwwroot/lvzhi/vendor/symfony/polyfill-intl-normalizer/bootstrap.php ( 0.71 KB )
/www/wwwroot/lvzhi/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/wwwroot/lvzhi/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/wwwroot/lvzhi/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/wwwroot/lvzhi/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/wwwroot/lvzhi/vendor/guzzlehttp/psr7/src/functions.php ( 13.09 KB )
/www/wwwroot/lvzhi/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.52 KB )
/www/wwwroot/lvzhi/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/wwwroot/lvzhi/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/wwwroot/lvzhi/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/www/wwwroot/lvzhi/vendor/overtrue/wechat/src/Payment/helpers.php ( 1.61 KB )
/www/wwwroot/lvzhi/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 8.92 KB )
/www/wwwroot/lvzhi/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 8.44 KB )
/www/wwwroot/lvzhi/vendor/topthink/think-captcha/src/helper.php ( 1.94 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Route.php ( 60.23 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Config.php ( 6.38 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Validate.php ( 41.63 KB )
/www/wwwroot/lvzhi/vendor/yfcmf/geetest/src/helper.php ( 1.36 KB )
/www/wwwroot/lvzhi/vendor/yfcmf/tp5-addons/src/common.php ( 7.21 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Hook.php ( 4.71 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Error.php ( 3.75 KB )
/www/wwwroot/lvzhi/thinkphp/convention.php ( 10.37 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/App.php ( 21.51 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Request.php ( 49.78 KB )
/www/wwwroot/lvzhi/app/config.php ( 17.21 KB )
/www/wwwroot/lvzhi/app/database.php ( 1.87 KB )
/www/wwwroot/lvzhi/app/tags.php ( 0.33 KB )
/www/wwwroot/lvzhi/app/common.php ( 67.05 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Env.php ( 1.21 KB )
/www/wwwroot/lvzhi/thinkphp/helper.php ( 17.30 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Lang.php ( 7.23 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Log.php ( 6.05 KB )
/www/wwwroot/lvzhi/thinkphp/lang/zh-cn.php ( 11.81 KB )
/www/wwwroot/lvzhi/app/lang/zh-cn.php ( 4.90 KB )
/www/wwwroot/lvzhi/app/route.php ( 5.49 KB )
/www/wwwroot/lvzhi/extend/Route.php ( 2.29 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Cache.php ( 6.10 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/cache/driver/File.php ( 7.27 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
/www/wwwroot/lvzhi/app/home/config.php ( 0.57 KB )
/www/wwwroot/lvzhi/app/home/lang/zh-cn.php ( 3.04 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Debug.php ( 7.13 KB )
/www/wwwroot/lvzhi/app/common/behavior/WebLog.php ( 3.22 KB )
/www/wwwroot/lvzhi/extend/ReadClass.php ( 3.74 KB )
/www/wwwroot/lvzhi/app/home/controller/Base.php ( 7.84 KB )
/www/wwwroot/lvzhi/app/common/controller/Common.php ( 2.02 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Controller.php ( 6.07 KB )
/www/wwwroot/lvzhi/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
/www/wwwroot/lvzhi/app/home/controller/Center.php ( 103.58 KB )
/www/wwwroot/lvzhi/app/home/controller/Comment.php ( 2.52 KB )
/www/wwwroot/lvzhi/app/home/controller/Customer.php ( 7.75 KB )
/www/wwwroot/lvzhi/app/home/controller/Demand.php ( 10.19 KB )
/www/wwwroot/lvzhi/app/home/controller/Dzforum.php ( 16.22 KB )
/www/wwwroot/lvzhi/app/home/controller/Error.php ( 0.61 KB )
/www/wwwroot/lvzhi/app/home/controller/Fmenu.php ( 10.74 KB )
/www/wwwroot/lvzhi/app/admin/controller/Base.php ( 1.38 KB )
/www/wwwroot/lvzhi/app/home/controller/Forum.php ( 22.42 KB )
/www/wwwroot/lvzhi/app/home/controller/Im.php ( 1.93 KB )
/www/wwwroot/lvzhi/app/home/controller/Index.php ( 18.83 KB )
/www/wwwroot/lvzhi/app/home/controller/Listn.php ( 3.46 KB )
/www/wwwroot/lvzhi/app/home/controller/Login.php ( 8.23 KB )
/www/wwwroot/lvzhi/app/home/controller/Model.php ( 0.99 KB )
/www/wwwroot/lvzhi/app/home/controller/News.php ( 5.99 KB )
/www/wwwroot/lvzhi/app/home/controller/Oauth.php ( 8.18 KB )
/www/wwwroot/lvzhi/app/home/controller/Pay.php ( 22.70 KB )
/www/wwwroot/lvzhi/app/home/controller/Payment.php ( 8.49 KB )
/www/wwwroot/lvzhi/app/home/controller/PaymentNotify.php ( 0.49 KB )
/www/wwwroot/lvzhi/app/home/controller/Problem.php ( 1.55 KB )
/www/wwwroot/lvzhi/app/home/controller/Register.php ( 6.27 KB )
/www/wwwroot/lvzhi/app/home/controller/Shop.php ( 9.88 KB )
/www/wwwroot/lvzhi/app/home/controller/Skill.php ( 5.53 KB )
/www/wwwroot/lvzhi/app/home/controller/Tag.php ( 3.01 KB )
/www/wwwroot/lvzhi/app/home/controller/User.php ( 4.62 KB )
/www/wwwroot/lvzhi/app/home/controller/Video.php ( 3.99 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Session.php ( 10.86 KB )
/www/wwwroot/lvzhi/extend/Ip.php ( 2.82 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Db.php ( 6.67 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/db/Query.php ( 93.74 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/db/builder/Mysql.php ( 4.53 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/db/Builder.php ( 31.55 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/View.php ( 6.77 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Template.php ( 44.90 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/www/wwwroot/lvzhi/app/admin/model/Options.php ( 5.14 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Model.php ( 69.14 KB )
/www/wwwroot/lvzhi/app/home/model/Pluglink.php ( 1.45 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/wwwroot/lvzhi/app/home/model/Message.php ( 2.65 KB )
/www/wwwroot/lvzhi/app/home/model/Problem.php ( 1.67 KB )
/www/wwwroot/lvzhi/app/home/model/Plugad.php ( 1.80 KB )
/www/wwwroot/lvzhi/app/home/model/Menu.php ( 4.30 KB )
/www/wwwroot/lvzhi/addons/maintain/Maintain.php ( 3.74 KB )
/www/wwwroot/lvzhi/vendor/yfcmf/tp5-addons/src/Addons.php ( 5.63 KB )
/www/wwwroot/lvzhi/addons/info/Info.php ( 3.01 KB )
/www/wwwroot/lvzhi/addons/team/Team.php ( 1.38 KB )
/www/wwwroot/lvzhi/app/home/model/News.php ( 19.16 KB )
/www/wwwroot/lvzhi/app/home/model/Shop.php ( 14.53 KB )
/www/wwwroot/lvzhi/data/runtime/temp/73590614e68845b7260197184b12383c.php ( 32.89 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Url.php ( 12.72 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/Response.php ( 8.28 KB )
/www/wwwroot/lvzhi/app/admin/behavior/Cron.php ( 2.20 KB )
/www/wwwroot/lvzhi/data/runtime/~crons.php ( 0.11 KB )
/www/wwwroot/lvzhi/thinkphp/library/think/debug/Html.php ( 4.17 KB )

[ LANG ] /www/wwwroot/lvzhi/thinkphp/lang/zh-cn.php
[ LANG ] /www/wwwroot/lvzhi/app/lang/zh-cn.php
[ CACHE ] INIT File
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'home', 1 => 'News', 2 => 'newsinfo', ), 'convert' => false, )
[ HEADER ] array ( 'connection' => 'keep-alive', 'cache-control' => 'max-age=259200', 'x-forwarded-for' => '10.6.1.108', 'via' => '1.1 squid-proxy-5b5d847c96-fdpt8 (squid/6.10)', 'accept-encoding' => 'gzip, br, zstd, deflate', 'cookie' => 'PHPSESSID=pdn8q2qcfn61cjta4bvo8jpj9s', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', 'host' => 'www.yanzhiwang.cn', 'content-length' => '', 'content-type' => '', )
[ PARAM ] array ( 'id' => '53235', )
[ LANG ] /www/wwwroot/lvzhi/app/home/lang/zh-cn.php
[ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, )
[ DB ] INIT mysql
[ BEHAVIOR ] Run app\common\behavior\WebLog @module_init [ RunTime:0.027320s ]
[ DB ] INIT mysql
[ BEHAVIOR ] Run Closure @action_begin [ RunTime:0.028253s ]
[ RUN ] app\home\controller\News->newsinfo[ /www/wwwroot/lvzhi/app/home/controller/News.php ]
[ VIEW ] /www/wwwroot/lvzhi/app/home/view/default/news_info.html [ array ( 0 => 'lang', 1 => 'map_lat', 2 => 'map_lng', 3 => 'site_name', 4 => 'site_host', 5 => 'site_tpl', 6 => 'site_tpl_m', 7 => 'site_logo', 8 => 'site_icp', 9 => 'site_tongji', 10 => 'site_copyright', 11 => 'site_co_name', 12 => 'site_address', 13 => 'site_tel', 14 => 'site_admin_email', 15 => 'site_qq', 16 => 'site_seo_title', 17 => 'site_seo_keywords', 18 => 'site_seo_description', 19 => 'hosturl', 20 => 'yf_theme_path', 21 => 'userid', 22 => 'user_info', 23 => 'is_state', 24 => 'provinces', 25 => 'citys', 26 => 'towns', 27 => 'link', 28 => 'seo', 29 => 'messagecount', 30 => 'probleminfo', 31 => 'plugadlist', 32 => 'plugadlisttwo', 33 => 'plugadlistthree', 34 => 'plugadlistfour', 35 => 'nickname', 36 => 'menulist', 37 => 'newsinfo', 38 => 'newtj', 39 => 'newtjzb', 40 => 'newssyp', 41 => 'newsxyp', 42 => 'shopviplist', 43 => 'shopfooter', ) ]
[ BEHAVIOR ] Run app\admin\behavior\Cron @app_end [ RunTime:0.000477s ]

[ DB ] CONNECT:[ UseTime:0.000443s ] mysql:host=127.0.0.1;port=3306;dbname=lv;charset=utf8
[ SQL ] SHOW COLUMNS FROM `jm_web_log` [ RunTime:0.000650s ]
[ SQL ] INSERT INTO `jm_web_log` (`uid` , `ip` , `location` , `os` , `browser` , `url` , `module` , `controller` , `action` , `method` , `data` , `otime`) VALUES (0 , '10.6.1.108' , '局域网局域网 ' , '未知操作系统' , '未知浏览器()' , '/newsinfo/53235.html' , 'home' , 'News' , 'newsinfo' , 'GET' , 'a:1:{s:2:\"id\";s:5:\"53235\";}' , 1751956311) [ RunTime:0.003552s ]
[ SQL ] SHOW COLUMNS FROM `jm_member_list` [ RunTime:0.000824s ]
[ SQL ] SELECT * FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT `is_state` FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SHOW COLUMNS FROM `jm_message` [ RunTime:0.000588s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `jm_message` `m` INNER JOIN `jm_member_list` `u` ON `m`.`mid`=`u`.`id` WHERE `m`.`show` = 0 AND `m`.`status` = 0 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SHOW COLUMNS FROM `jm_problem` [ RunTime:0.000489s ]
[ SQL ] SELECT `p`.* FROM `jm_problem` `p` WHERE `p`.`id` = 2 AND `p`.`is_delete` = 1 AND `p`.`status` = 1 ORDER BY `p`.`listorder` ASC LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SHOW COLUMNS FROM `jm_plug_ad` [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1751956311>= a.plug_ad_starsttime and 1751956311<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 0,1 [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1751956311>= a.plug_ad_starsttime and 1751956311<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 1,1 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1751956311>= a.plug_ad_starsttime and 1751956311<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 2,1 [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1751956311>= a.plug_ad_starsttime and 1751956311<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 3,1 [ RunTime:0.000327s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008458s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008529s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008270s ]
[ SQL ] SHOW COLUMNS FROM `jm_news` [ RunTime:0.000766s ]
[ SQL ] SELECT `n`.`n_id`,`n`.`nmid`,`n`.`news_columnid`,`n`.`news_title`,`n`.`news_key`,`n`.`news_tag`,`n`.`news_flag`,`n`.`news_auto`,`n`.`news_source`,`n`.`news_hits`,`n`.`news_img`,`n`.`news_imgs`,`n`.`news_scontent`,`n`.`news_content`,`n`.`news_time`,`n`.`news_like`,`n`.`comment_count`,`m`.`id`,`m`.`menu_name`,`m`.`menu_seo_title`,`m`.`menu_seo_key`,`m`.`menu_seo_des`,`u`.`id`,`u`.`realname`,`u`.`nickname`,`u`.`avatar` FROM `jm_news` `n` INNER JOIN `jm_menu` `m` ON `n`.`news_columnid`=`m`.`id` INNER JOIN `jm_member_list` `u` ON `n`.`nmid`=`u`.`id` WHERE `n`.`n_id` = '53235' AND `u`.`status` = 2 AND `m`.`menu_open` = 1 AND `m`.`mnoshow` = 0 AND `n`.`news_open` = 1 AND `n`.`news_back` = 0 LIMIT 1 [ RunTime:0.000591s ]
[ SQL ] UPDATE `jm_news` SET `news_hits`=`news_hits`+1 WHERE `n_id` = 53235 [ RunTime:0.003233s ]
[ SQL ] SELECT `n`.`n_id`,`n`.`nmid`,`n`.`news_title`,`n`.`news_key`,`n`.`news_tag`,`n`.`news_flag`,`n`.`news_auto`,`n`.`news_source`,`n`.`news_hits`,`n`.`news_img`,`n`.`news_scontent`,`n`.`news_content`,`n`.`news_time`,`m`.`menu_name`,`m`.`menu_seo_title`,`m`.`menu_seo_key`,`m`.`menu_seo_des`,`u`.`id`,`u`.`realname`,`u`.`nickname`,`u`.`type`,`u`.`avatar` FROM `jm_news` `n` INNER JOIN `jm_menu` `m` ON `n`.`news_columnid`=`m`.`id` INNER JOIN `jm_member_list` `u` ON `n`.`nmid`=`u`.`id` WHERE `news_time` BETWEEN 1751351511 AND 1751956311 AND `u`.`status` = 2 AND `m`.`menu_open` = 1 AND `m`.`mnoshow` = 0 AND `n`.`news_open` = 1 AND `n`.`news_back` = 0 ORDER BY `n`.`news_hits` DESC LIMIT 9 [ RunTime:2.919640s ]
[ SQL ] SELECT `n_id`,`nmid`,`news_columnid`,`news_title`,`news_key`,`news_tag`,`news_flag`,`news_auto`,`news_source`,`news_time`,`news_imgs`,`news_img` FROM `jm_news` WHERE `news_open` = 1 AND `n_id` < 53235 AND `news_columnid` = 34 LIMIT 1 [ RunTime:0.000563s ]
[ SQL ] SELECT `n_id`,`nmid`,`news_columnid`,`news_title`,`news_key`,`news_tag`,`news_flag`,`news_auto`,`news_source`,`news_time` FROM `jm_news` WHERE `news_open` = 1 AND `n_id` > 53235 AND `news_columnid` = 34 LIMIT 1 [ RunTime:0.003354s ]

3.029259s

没弄清楚这些关键点，乱用磷酸二氢钾，算“白瞎”了！

店铺商品销售排行榜

绿植养护手册

免稀释植物营养液生根液盆栽富贵竹绿叶移栽扦插绿植营养发根肥料

玉翁仙人球仙人掌多肉植物桌面阳台庭院小盆栽带花苞开花仙人球植

碗莲荷花种子鱼缸水养植物室内水培莲花好养微莲盆栽花卉种子代发