公司動態-新聞動態湖北錦和興貿易有限公司/Hubei jinhexing Trade Co., Ltd

基本文件流程錯誤 SQL 調試

/www/wwwroot/jhx.net.cn/public/index.php ( 0.79 KB )
/www/wwwroot/jhx.net.cn/public/public.php ( 1.08 KB )
/www/wwwroot/jhx.net.cn/thinkphp/start.php ( 0.73 KB )
/www/wwwroot/jhx.net.cn/thinkphp/base.php ( 2.66 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Loader.php ( 19.47 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Error.php ( 3.59 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Config.php ( 6.03 KB )
/www/wwwroot/jhx.net.cn/thinkphp/convention.php ( 10.31 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/App.php ( 20.80 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Request.php ( 50.13 KB )
/www/wwwroot/jhx.net.cn/app/config.php ( 9.75 KB )
/www/wwwroot/jhx.net.cn/app/database.php ( 1.51 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Hook.php ( 4.76 KB )
/www/wwwroot/jhx.net.cn/app/tags.php ( 1.16 KB )
/www/wwwroot/jhx.net.cn/app/common/behavior/InitBase.php ( 7.51 KB )
/www/wwwroot/jhx.net.cn/app/common.php ( 35.57 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Env.php ( 1.25 KB )
/www/wwwroot/jhx.net.cn/thinkphp/helper.php ( 17.86 KB )
/www/wwwroot/jhx.net.cn/app/function.php ( 0.78 KB )
/www/wwwroot/jhx.net.cn/app/extend.php ( 8.18 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Debug.php ( 7.06 KB )
/www/wwwroot/jhx.net.cn/app/common/model/Config.php ( 0.78 KB )
/www/wwwroot/jhx.net.cn/app/common/model/ModelBase.php ( 10.81 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Model.php ( 66.84 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Db.php ( 6.54 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Log.php ( 5.84 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/db/connector/Mysql.php ( 3.94 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/db/Query.php ( 89.54 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/db/builder/Mysql.php ( 2.16 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/db/Builder.php ( 30.47 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Cache.php ( 6.17 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/cache/driver/File.php ( 6.98 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/cache/Driver.php ( 5.52 KB )
/www/wwwroot/jhx.net.cn/app/common/behavior/InitHook.php ( 1.25 KB )
/www/wwwroot/jhx.net.cn/app/common/model/Hook.php ( 0.77 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Route.php ( 59.82 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Lang.php ( 6.95 KB )
/www/wwwroot/jhx.net.cn/thinkphp/lang/zh-cn.php ( 3.85 KB )
/www/wwwroot/jhx.net.cn/app/route.php ( 0.95 KB )
/www/wwwroot/jhx.net.cn/app/index/config.php ( 0.99 KB )
/www/wwwroot/jhx.net.cn/app/index/common.php ( 1.36 KB )
/www/wwwroot/jhx.net.cn/app/index/controller/News.php ( 4.51 KB )
/www/wwwroot/jhx.net.cn/app/index/controller/IndexBase.php ( 18.85 KB )
/www/wwwroot/jhx.net.cn/app/common/controller/ControllerBase.php ( 4.75 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Controller.php ( 6.20 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/traits/controller/Jump.php ( 4.97 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/View.php ( 6.86 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/view/driver/Think.php ( 5.61 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Template.php ( 46.46 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Session.php ( 11.17 KB )
/www/wwwroot/jhx.net.cn/app/common/logic/Category.php ( 4.48 KB )
/www/wwwroot/jhx.net.cn/app/common/logic/LogicBase.php ( 0.83 KB )
/www/wwwroot/jhx.net.cn/app/common/model/Category.php ( 1.00 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/paginator/driver/Bootstrap.php ( 6.69 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Paginator.php ( 9.45 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Collection.php ( 8.63 KB )
/www/wwwroot/jhx.net.cn/app/common/logic/Ad.php ( 5.75 KB )
/www/wwwroot/jhx.net.cn/app/common/model/Ad.php ( 1.00 KB )
/www/wwwroot/jhx.net.cn/app/common/logic/Column.php ( 6.12 KB )
/www/wwwroot/jhx.net.cn/app/common/model/Column.php ( 1.00 KB )
/www/wwwroot/jhx.net.cn/app/common/logic/InfoCategory.php ( 5.62 KB )
/www/wwwroot/jhx.net.cn/app/common/model/InfoCategory.php ( 0.79 KB )
/www/wwwroot/jhx.net.cn/app/common/logic/Info.php ( 30.41 KB )
/www/wwwroot/jhx.net.cn/app/common/model/Info.php ( 1.00 KB )
/www/wwwroot/jhx.net.cn/runtime/temp/d1ca09fadaa55685d4f8a1e549d44687.php ( 16.94 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Url.php ( 12.97 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/Response.php ( 8.64 KB )
/www/wwwroot/jhx.net.cn/thinkphp/library/think/debug/Html.php ( 4.27 KB )

[ DB ] CONNECT:[ UseTime:0.000346s ] mysql:dbname=jhx_net_cn;host=localhost;port=3366;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ob_config` [ RunTime:0.000616s ]
[ SQL ] SELECT * FROM `ob_config` [ RunTime:0.000267s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_config', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 40, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_hook` [ RunTime:0.000501s ]
[ SQL ] SELECT `id`,`name`,`addon_list` FROM `ob_hook` [ RunTime:0.000175s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_hook', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] select * from ob_config where id=4 [ RunTime:0.000259s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_config', '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_category` [ RunTime:0.000683s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_category` WHERE `status` = 1 AND `identification` = 'friendlink' LIMIT 1 [ RunTime:0.000241s ]
[ 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' => 3, 'filtered' => 33.333335876464844, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_category` WHERE `status` = 1 AND `identification` = 'friendlink' ORDER BY sort asc,id desc LIMIT 0,120 [ RunTime:0.000404s ]
[ 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' => 3, 'filtered' => 33.333335876464844, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_ad` [ RunTime:0.000575s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_ad` WHERE `identification` = 'banner' AND `category_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000219s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_ad', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`object_name`,`cover_id`,`image`,`url` FROM `ob_ad` WHERE `identification` = 'banner' AND `category_id` = 1 AND `status` = 1 ORDER BY sort asc,create_user_time desc,id desc LIMIT 0,10 [ RunTime:0.000261s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_ad', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_column` [ RunTime:0.002861s ]
[ SQL ] SELECT `id`,`object_no`,`object_name`,`object_name1` FROM `ob_column` WHERE `highter_object_no` = 'm1521565261xytzg00010000000100' AND `status` = 1 ORDER BY sort asc,id desc [ RunTime:0.000375s ]
[ 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' => 12, 'filtered' => 8.333333969116211, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_info_category` [ RunTime:0.000700s ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`column_object_no` FROM `ob_info_category` WHERE `column_object_no` = 'm1521565261xytzg00010000000100' AND `status` = 1 ORDER BY sort asc,id desc [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 7.142856597900391, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`object_no`,`object_name`,`object_name1` FROM `ob_column` WHERE `highter_object_no` = 'm1521565261xytzg00010000000200' AND `status` = 1 ORDER BY sort asc,id desc [ RunTime:0.000328s ]
[ 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' => 12, 'filtered' => 8.333333969116211, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`column_object_no` FROM `ob_info_category` WHERE `column_object_no` = 'm1521565261xytzg00010000000200' AND `status` = 1 ORDER BY sort asc,id desc [ RunTime:0.000238s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 7.142856597900391, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`object_no`,`object_name`,`object_name1` FROM `ob_column` WHERE `highter_object_no` = 'm1521565261xytzg00010000000500' AND `status` = 1 ORDER BY sort asc,id desc [ RunTime:0.000337s ]
[ 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' => 12, 'filtered' => 8.333333969116211, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`column_object_no` FROM `ob_info_category` WHERE `column_object_no` = 'm1521565261xytzg00010000000500' AND `status` = 1 ORDER BY sort asc,id desc [ RunTime:0.000299s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 7.142856597900391, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_info_category` WHERE `column_object_no` = 'm1521565261xytzg00010000000500' AND `status` = 1 LIMIT 1 [ RunTime:0.000218s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 7.142856597900391, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`column_object_no` FROM `ob_info_category` WHERE `column_object_no` = 'm1521565261xytzg00010000000500' AND `status` = 1 ORDER BY sort asc,id desc LIMIT 0,12 [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 7.142856597900391, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`column_object_no`,`type`,`url` FROM `ob_info_category` WHERE `object_no` = 'c1607910334admin00000000000005' LIMIT 1 [ RunTime:0.000246s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 9.999999046325684, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`highter_object_no`,`type`,`is_create_user_time` FROM `ob_column` WHERE `object_no` = 'm1521565261xytzg00010000000200' LIMIT 1 [ RunTime:0.000258s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_column', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'object_no', 'key' => 'object_no', 'key_len' => '121', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`column_object_no` FROM `ob_info_category` WHERE `column_object_no` = 'm1521565261xytzg00010000000200' AND `status` = 1 ORDER BY sort asc,id desc [ RunTime:0.000255s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 7.142856597900391, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_info` [ RunTime:0.000959s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_info` WHERE `category_object_no` = 'c1607910334admin00000000000005' AND `status` <> -1 LIMIT 1 [ RunTime:0.000234s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'bb', 'key' => 'bb', 'key_len' => '91', 'ref' => 'const', 'rows' => 1, 'filtered' => 90.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_info` WHERE `category_object_no` = 'c1607910334admin00000000000005' AND `status` <> -1 ORDER BY sort asc,create_user_time desc,id desc LIMIT 0,20 [ RunTime:0.000501s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'bb', 'key' => 'bb', 'key_len' => '91', 'ref' => 'const', 'rows' => 1, 'filtered' => 90.0, 'extra' => 'Using index condition; Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`category_object_no`,`object_no`,`sub_title`,`object_name`,`object_name1`,`content`,`content1`,`column_object_no`,`url`,`click`,`department_id`,`is_sign`,`cover_id`,`is_red`,`file_id`,`header_title`,`document_number`,`img_ids` FROM `ob_info` WHERE `category_object_no` = 'c1607910334admin00000000000005' LIMIT 1 [ RunTime:0.000268s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_info', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'bb', 'key' => 'bb', 'key_len' => '91', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_column` WHERE `object_no` <> 'c1607910334admin00000000000005' AND `identification` = 'info' AND `status` <> -1 LIMIT 1 [ RunTime:0.000327s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_column', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'object_no', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 9.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `object_no`,`object_name`,`object_name1`,`id` FROM `ob_column` WHERE `object_no` <> 'c1607910334admin00000000000005' AND `identification` = 'info' AND `status` <> -1 ORDER BY sort asc,id desc LIMIT 0,7 [ RunTime:0.000377s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_column', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'object_no', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 9.0, 'extra' => 'Using where; Using filesort', ) ]

新聞動態

聯系我們