襄阳市生态环境科学学会

您当前的位置：首页 - 学术交流

学术交流

咨询电话

0710-3598556

河北学会 2019年中国环科会秘书长交流会材料（李云凯）

发布时间：2019-09-06 09:16:39 | 【打印】

河北学会 2019年中国环科会秘书长交流会材料.ppt

地址：襄阳市高新区春园路15号火炬大厦4楼　电话：0710-3598556 　邮箱：1943627105@qq.com

基本文件流程错误 SQL 调试

/www/wwwroot/xyssthjkxxh.com/public/index.php ( 1.06 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/start.php ( 0.71 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/base.php ( 2.60 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Loader.php ( 18.92 KB )
/www/wwwroot/xyssthjkxxh.com/vendor/composer/autoload_namespaces.php ( 0.21 KB )
/www/wwwroot/xyssthjkxxh.com/vendor/composer/autoload_psr4.php ( 0.59 KB )
/www/wwwroot/xyssthjkxxh.com/vendor/composer/autoload_classmap.php ( 0.14 KB )
/www/wwwroot/xyssthjkxxh.com/vendor/composer/autoload_files.php ( 0.33 KB )
/www/wwwroot/xyssthjkxxh.com/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Route.php ( 58.26 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Config.php ( 5.86 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Validate.php ( 39.02 KB )
/www/wwwroot/xyssthjkxxh.com/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 7.10 KB )
/www/wwwroot/xyssthjkxxh.com/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 0.70 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Error.php ( 3.47 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/convention.php ( 10.03 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/App.php ( 20.22 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Request.php ( 48.44 KB )
/www/wwwroot/xyssthjkxxh.com/app/config.php ( 9.75 KB )
/www/wwwroot/xyssthjkxxh.com/app/database.php ( 1.42 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Hook.php ( 4.63 KB )
/www/wwwroot/xyssthjkxxh.com/app/tags.php ( 1.23 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/behavior/InitBase.php ( 6.45 KB )
/www/wwwroot/xyssthjkxxh.com/app/common.php ( 31.18 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Env.php ( 1.21 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/helper.php ( 17.29 KB )
/www/wwwroot/xyssthjkxxh.com/app/function.php ( 0.77 KB )
/www/wwwroot/xyssthjkxxh.com/app/extend.php ( 7.93 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Debug.php ( 6.85 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/model/Config.php ( 0.76 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/model/ModelBase.php ( 7.53 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Model.php ( 64.69 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Db.php ( 6.39 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Log.php ( 5.63 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/db/connector/Mysql.php ( 3.82 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/db/Connection.php ( 28.96 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/db/Query.php ( 86.80 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/db/builder/Mysql.php ( 2.09 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/db/Builder.php ( 29.64 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Cache.php ( 5.96 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/cache/driver/File.php ( 6.73 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/cache/Driver.php ( 5.31 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/behavior/InitHook.php ( 1.21 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/model/Hook.php ( 0.75 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Lang.php ( 6.74 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/lang/zh-cn.php ( 3.78 KB )
/www/wwwroot/xyssthjkxxh.com/app/route.php ( 0.89 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/behavior/AppBegin.php ( 0.85 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/config.php ( 0.96 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/common.php ( 1.24 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/controller/News.php ( 7.56 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/controller/IndexBase.php ( 3.73 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/controller/ControllerBase.php ( 4.60 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Controller.php ( 5.99 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/traits/controller/Jump.php ( 4.82 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/View.php ( 6.63 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/view/driver/Think.php ( 5.45 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Template.php ( 45.34 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/template/driver/File.php ( 2.17 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/logic/Category.php ( 1.13 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/logic/LogicBase.php ( 0.80 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/model/Category.php ( 0.76 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.23 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Paginator.php ( 9.07 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Collection.php ( 8.26 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/logic/Seo.php ( 1.55 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/logic/IndexBase.php ( 0.79 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/logic/Info.php ( 1.36 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/model/Info.php ( 0.75 KB )
/www/wwwroot/xyssthjkxxh.com/app/index/logic/Column.php ( 11.64 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/model/Column.php ( 1.13 KB )
/www/wwwroot/xyssthjkxxh.com/runtime/temp/d472cb05d94dfd1b5a70e4c9b350ea2c.php ( 6.63 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Url.php ( 12.65 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/Response.php ( 8.32 KB )
/www/wwwroot/xyssthjkxxh.com/app/common/behavior/AppEnd.php ( 0.90 KB )
/www/wwwroot/xyssthjkxxh.com/thinkphp/library/think/debug/Html.php ( 4.16 KB )

[ DB ] CONNECT:[ UseTime:0.000288s ] mysql:dbname=xyssthjkxxh_com;host=localhost;port=3366;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ob_category` [ RunTime:0.000621s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_category` WHERE `column_object_no` = 'm1526440271xytzg00010000000003' AND `status` <> -1 LIMIT 1 [ RunTime:0.000251s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 9.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`object_no`,`object_name`,`fid`,`highter_object_no`,`column_id`,`column_object_no`,`table_name`,`identification`,`url`,`level`,`sort`,`icon`,`cover_id`,`image`,`images`,`radio`,`summary`,`content`,`create_user_id`,`create_user_object_no`,`create_user_time`,`create_user_ip`,`update_user_id`,`update_user_object_no`,`update_user_time`,`update_user_ip`,`own_user_id`,`own_user_object_no`,`is_check`,`check_user_id`,`check_user_object_no`,`check_user_time`,`check_user_ip`,`object_name1`,`object_name2`,`object_name3`,`object_name4`,`object_name5`,`radio1`,`radio2`,`radio3`,`radio4`,`radio5`,`image1`,`image2`,`image3`,`image4`,`image5`,`summary1`,`summary2`,`summary3`,`summary4`,`summary5`,`content1`,`content2`,`content3`,`content4`,`content5`,`status`,`is_copy`,`type` FROM `ob_category` WHERE `column_object_no` = 'm1526440271xytzg00010000000003' AND `status` <> -1 LIMIT 0,10 [ RunTime:0.000357s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 9.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000004' ) ORDER BY id,sort [ RunTime:0.000287s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000003' ) ORDER BY id,sort [ RunTime:0.000279s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000005' ) ORDER BY id,sort [ RunTime:0.000258s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000002' ) ORDER BY id,sort [ RunTime:0.000257s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000007' ) ORDER BY id,sort [ RunTime:0.000257s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000024' ) ORDER BY id,sort [ RunTime:0.000255s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000025' ) ORDER BY id,sort [ RunTime:0.000237s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000026' ) ORDER BY id,sort [ RunTime:0.000246s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( column_object_no='m1521565261xytzg00010000000021' ) ORDER BY id,sort [ RunTime:0.000237s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_info` [ RunTime:0.000563s ]
[ SQL ] SELECT * FROM `ob_info` WHERE ( category_id=47 ) ORDER BY is_recommend desc,id desc LIMIT 1 [ RunTime:0.026979s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 482, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_info` WHERE `column_object_no` <> 'm1521565261xytzg00010000000014' AND `status` <> -1 LIMIT 1 [ RunTime:0.026348s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 482, 'filtered' => 80.99999237060547, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_info` WHERE `column_object_no` <> 'm1521565261xytzg00010000000014' AND `status` <> -1 ORDER BY id desc LIMIT 0,8 [ RunTime:0.024307s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => NULL, 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => NULL, 'rows' => 8, 'filtered' => 80.99999237060547, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_info` WHERE `id` = 230 LIMIT 1 [ RunTime:0.000424s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_column` [ RunTime:0.001689s ]
[ SQL ] SELECT `object_name` FROM `ob_column` WHERE `object_no` = 'm1521565261xytzg00010000000004' LIMIT 1 [ RunTime:0.000213s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_column', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 19, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE ( id=0 ) LIMIT 1 [ RunTime:0.000243s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] select * from ob_category where column_object_no='m1521565261xytzg00010000000004' order by sort,id desc [ RunTime:0.000259s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]

0.126354s