2008年8月3日，黄冈市国土资源局有关领导为黄冈分公司员工授课-湖北永业行评估咨询有限公司

基本文件流程错误 SQL 调试

/www/wwwroot/yyhang.com/index.php ( 1.04 KB )
/www/wwwroot/yyhang.com/system/start.php ( 0.71 KB )
/www/wwwroot/yyhang.com/system/base.php ( 2.60 KB )
/www/wwwroot/yyhang.com/system/library/think/Loader.php ( 18.78 KB )
/www/wwwroot/yyhang.com/vendor/composer/autoload_namespaces.php ( 0.15 KB )
/www/wwwroot/yyhang.com/vendor/composer/autoload_psr4.php ( 0.47 KB )
/www/wwwroot/yyhang.com/vendor/composer/autoload_classmap.php ( 0.79 KB )
/www/wwwroot/yyhang.com/vendor/composer/autoload_files.php ( 0.33 KB )
/www/wwwroot/yyhang.com/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/www/wwwroot/yyhang.com/system/library/think/Route.php ( 58.59 KB )
/www/wwwroot/yyhang.com/system/library/think/Config.php ( 6.16 KB )
/www/wwwroot/yyhang.com/system/library/think/Validate.php ( 39.43 KB )
/www/wwwroot/yyhang.com/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/www/wwwroot/yyhang.com/system/library/think/Error.php ( 3.61 KB )
/www/wwwroot/yyhang.com/system/convention.php ( 10.10 KB )
/www/wwwroot/yyhang.com/system/library/think/App.php ( 20.27 KB )
/www/wwwroot/yyhang.com/system/library/think/Request.php ( 48.58 KB )
/www/wwwroot/yyhang.com/config/config.php ( 8.70 KB )
/www/wwwroot/yyhang.com/config/database.php ( 2.08 KB )
/www/wwwroot/yyhang.com/config/extra/wx.php ( 0.02 KB )
/www/wwwroot/yyhang.com/system/library/think/Hook.php ( 4.63 KB )
/www/wwwroot/yyhang.com/config/tags.php ( 1.03 KB )
/www/wwwroot/yyhang.com/app/common.php ( 2.64 KB )
/www/wwwroot/yyhang.com/system/library/think/Env.php ( 1.21 KB )
/www/wwwroot/yyhang.com/system/helper.php ( 17.30 KB )
/www/wwwroot/yyhang.com/system/library/think/Lang.php ( 6.91 KB )
/www/wwwroot/yyhang.com/system/library/think/Log.php ( 5.63 KB )
/www/wwwroot/yyhang.com/system/lang/zh-cn.php ( 11.58 KB )
/www/wwwroot/yyhang.com/config/route.php ( 0.50 KB )
/www/wwwroot/yyhang.com/system/library/think/Session.php ( 10.86 KB )
/www/wwwroot/yyhang.com/system/library/think/Debug.php ( 6.85 KB )
/www/wwwroot/yyhang.com/app/common/behavior/HostParse.php ( 2.33 KB )
/www/wwwroot/yyhang.com/app/common/model/Site.php ( 1.73 KB )
/www/wwwroot/yyhang.com/app/common/model/Base.php ( 6.46 KB )
/www/wwwroot/yyhang.com/system/library/think/Model.php ( 67.04 KB )
/www/wwwroot/yyhang.com/system/library/think/Cache.php ( 5.96 KB )
/www/wwwroot/yyhang.com/system/library/think/cache/driver/File.php ( 6.81 KB )
/www/wwwroot/yyhang.com/system/library/think/cache/Driver.php ( 5.98 KB )
/www/wwwroot/yyhang.com/system/library/think/Db.php ( 6.45 KB )
/www/wwwroot/yyhang.com/system/library/think/db/connector/Mysql.php ( 3.89 KB )
/www/wwwroot/yyhang.com/system/library/think/db/Connection.php ( 29.13 KB )
/www/wwwroot/yyhang.com/system/library/think/db/Query.php ( 88.30 KB )
/www/wwwroot/yyhang.com/system/library/think/db/builder/Mysql.php ( 2.09 KB )
/www/wwwroot/yyhang.com/system/library/think/db/Builder.php ( 30.30 KB )
/www/wwwroot/yyhang.com/system/library/think/Collection.php ( 8.70 KB )
/www/wwwroot/yyhang.com/extend/enum/SiteStatusEnum.php ( 0.13 KB )
/www/wwwroot/yyhang.com/theme/info.php ( 0.41 KB )
/www/wwwroot/yyhang.com/config/index/config.php ( 1.67 KB )
/www/wwwroot/yyhang.com/app/index/common.php ( 0.01 KB )
/www/wwwroot/yyhang.com/app/index/controller/Index.php ( 9.45 KB )
/www/wwwroot/yyhang.com/app/index/controller/Frontend.php ( 0.12 KB )
/www/wwwroot/yyhang.com/app/common/controller/Common.php ( 6.86 KB )
/www/wwwroot/yyhang.com/system/library/think/Controller.php ( 5.99 KB )
/www/wwwroot/yyhang.com/system/library/traits/controller/Jump.php ( 4.65 KB )
/www/wwwroot/yyhang.com/system/library/think/View.php ( 6.75 KB )
/www/wwwroot/yyhang.com/system/library/think/view/driver/Think.php ( 5.45 KB )
/www/wwwroot/yyhang.com/system/library/think/Template.php ( 45.23 KB )
/www/wwwroot/yyhang.com/system/library/think/template/driver/File.php ( 2.17 KB )
/www/wwwroot/yyhang.com/app/common/validate/IDMustBePositiveInt.php ( 0.17 KB )
/www/wwwroot/yyhang.com/app/common/validate/BaseValidate.php ( 0.87 KB )
/www/wwwroot/yyhang.com/app/common/model/Article.php ( 3.54 KB )
/www/wwwroot/yyhang.com/system/library/traits/model/SoftDelete.php ( 4.47 KB )
/www/wwwroot/yyhang.com/system/library/think/model/relation/BelongsTo.php ( 7.03 KB )
/www/wwwroot/yyhang.com/system/library/think/model/relation/OneToOne.php ( 9.70 KB )
/www/wwwroot/yyhang.com/system/library/think/model/Relation.php ( 3.11 KB )
/www/wwwroot/yyhang.com/app/common/model/Arctype.php ( 7.50 KB )
/www/wwwroot/yyhang.com/app/common/model/Model.php ( 6.57 KB )
/www/wwwroot/yyhang.com/system/library/think/Url.php ( 12.71 KB )
/www/wwwroot/yyhang.com/extend/tool/Tree.php ( 5.76 KB )
/www/wwwroot/yyhang.com/app/common/taglib/JL.php ( 10.94 KB )
/www/wwwroot/yyhang.com/system/library/think/template/TagLib.php ( 12.31 KB )
/www/wwwroot/yyhang.com/system/library/think/template/taglib/Cx.php ( 23.85 KB )
/www/wwwroot/yyhang.com/runtime/temp/index_e769e74829c238e910645cf688ca5a62.php ( 11.99 KB )
/www/wwwroot/yyhang.com/system/library/think/model/Collection.php ( 2.67 KB )
/www/wwwroot/yyhang.com/app/common/model/Advert.php ( 1.76 KB )
/www/wwwroot/yyhang.com/app/common/model/Link.php ( 1.99 KB )
/www/wwwroot/yyhang.com/system/library/think/Response.php ( 8.33 KB )
/www/wwwroot/yyhang.com/system/library/think/debug/Html.php ( 4.16 KB )

[ DB ] CONNECT:[ UseTime:0.000467s ] mysql:host=127.0.0.1;port=3306;dbname=yyhang_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `hbyyh_site` [ RunTime:0.001041s ]
[ SQL ] SELECT `id`,`host`,`title`,`seo_title`,`seo_keyword`,`seo_description`,`logo`,`banner`,`theme`,`style`,`icp`,`copyright`,`code`,`company`,`config`,`upload`,`mail`,`status`,`create_time`,`update_time`,`rank` FROM `hbyyh_site` ORDER BY rank,id [ RunTime:0.000395s ]
[ SQL ] SHOW COLUMNS FROM `hbyyh_article` [ RunTime:0.000627s ]
[ SQL ] UPDATE `hbyyh_article` SET `views`=views+1 WHERE ( `id` = 257 ) AND `hbyyh_article`.`delete_time` IS NULL [ RunTime:0.002682s ]
[ SQL ] SELECT * FROM `hbyyh_article` WHERE ( `id` = 257 ) AND `hbyyh_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SHOW COLUMNS FROM `hbyyh_arctype` [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `id` = 44 ) AND `hbyyh_arctype`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SHOW COLUMNS FROM `hbyyh_model` [ RunTime:0.000585s ]
[ SQL ] SELECT * FROM `hbyyh_model` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000291s ]
[ SQL ] SHOW COLUMNS FROM `hbyyh_news` [ RunTime:0.000430s ]
[ SQL ] SELECT * FROM `hbyyh_news` WHERE `id` = 257 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `hbyyh_article` WHERE ( `id` <> 257 AND `url` = '' AND `status` = 99 AND `type_id` = 44 AND `pubdate` <= 1723715610 AND `rank` <= 1110 ) AND `hbyyh_article`.`delete_time` IS NULL ORDER BY rank desc,id desc LIMIT 1 [ RunTime:0.014326s ]
[ SQL ] SELECT * FROM `hbyyh_article` WHERE ( `id` <> 257 AND `url` = '' AND `status` = 99 AND `type_id` = 44 AND `pubdate` <= 1723715610 AND `rank` >= 1110 ) AND `hbyyh_article`.`delete_time` IS NULL ORDER BY rank asc,id asc LIMIT 1 [ RunTime:0.015668s ]
[ SQL ] SELECT `id`,`pid`,`title` FROM `hbyyh_arctype` WHERE ( `site_id` = 1 AND `status` = 1 ) AND `hbyyh_arctype`.`delete_time` IS NULL [ RunTime:0.000545s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `id` = 16 ) AND `hbyyh_arctype`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000464s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 16 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `id` = 44 ) AND `hbyyh_arctype`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT * FROM `hbyyh_article` WHERE ( `id` = 257 ) AND `hbyyh_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000529s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `id` = 44 ) AND `hbyyh_arctype`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `id` = 44 ) AND `hbyyh_arctype`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `status` = 1 AND `site_id` = 1 AND `pid` = 0 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id [ RunTime:0.000405s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 1 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 7 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 16 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 17 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000386s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 20 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 24 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `pid` = 29 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id LIMIT 1 [ RunTime:0.000337s ]
[ SQL ] SHOW COLUMNS FROM `hbyyh_advert` [ RunTime:0.000526s ]
[ SQL ] SELECT * FROM `hbyyh_advert` WHERE ( `status` = 1 AND `site_id` = 1 AND `type_id` IN (11) ) AND `hbyyh_advert`.`delete_time` IS NULL ORDER BY rank,id [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `hbyyh_article` WHERE ( `id` = 257 ) AND `hbyyh_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000276s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `id` = 44 ) AND `hbyyh_arctype`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `id` = 16 ) AND `hbyyh_arctype`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `hbyyh_arctype` WHERE ( `status` = 1 AND `site_id` = 1 AND `pid` = 16 ) AND `hbyyh_arctype`.`delete_time` IS NULL ORDER BY rank,id [ RunTime:0.000322s ]
[ SQL ] SHOW COLUMNS FROM `hbyyh_link` [ RunTime:0.000501s ]
[ SQL ] SELECT * FROM `hbyyh_link` WHERE ( `status` = 1 AND `site_id` = 1 AND `type_id` IN (12) ) AND `hbyyh_link`.`delete_time` IS NULL ORDER BY rank,id [ RunTime:0.000370s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hbyyh_advert` WHERE `type_id` = 14 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000251s ]
[ SQL ] SELECT * FROM `hbyyh_advert` WHERE ( `status` = 1 AND `site_id` = 1 AND `type_id` IN (14) ) AND `hbyyh_advert`.`delete_time` IS NULL ORDER BY rank,id LIMIT 2 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `hbyyh_advert` WHERE ( `status` = 1 AND `site_id` = 1 AND `type_id` IN (14) ) AND `hbyyh_advert`.`delete_time` IS NULL ORDER BY rank,id LIMIT 2,2 [ RunTime:0.000331s ]