Solutions

　/　Solutions

Contact US: Jiangsu Skyflon Composites Co.,Ltd.; No.2,Taixing Sci-Tech Industrial Park,Taixing,Jiangsu,China; Tel: +86 523 82960128; Fax: +86 523 82768689; Email: info@skyflon.com

基本文件流程错误 SQL 调试

/www/users/H10079785/index.php ( 0.80 KB )
/www/users/H10079785/thinkphp/start.php ( 0.71 KB )
/www/users/H10079785/thinkphp/base.php ( 2.60 KB )
/www/users/H10079785/thinkphp/library/think/Loader.php ( 18.92 KB )
/www/users/H10079785/thinkphp/library/think/Error.php ( 3.47 KB )
/www/users/H10079785/thinkphp/library/think/Config.php ( 5.86 KB )
/www/users/H10079785/thinkphp/convention.php ( 9.97 KB )
/www/users/H10079785/thinkphp/library/think/App.php ( 20.06 KB )
/www/users/H10079785/thinkphp/library/think/Request.php ( 48.00 KB )
/www/users/H10079785/application/config.php ( 9.75 KB )
/www/users/H10079785/application/database.php ( 1.89 KB )
/www/users/H10079785/thinkphp/library/think/Hook.php ( 4.63 KB )
/www/users/H10079785/application/tags.php ( 0.96 KB )
/www/users/H10079785/application/common.php ( 9.33 KB )
/www/users/H10079785/thinkphp/library/think/Env.php ( 1.21 KB )
/www/users/H10079785/thinkphp/helper.php ( 17.29 KB )
/www/users/H10079785/thinkphp/library/think/Route.php ( 58.04 KB )
/www/users/H10079785/thinkphp/library/think/Lang.php ( 6.74 KB )
/www/users/H10079785/thinkphp/library/think/Log.php ( 5.63 KB )
/www/users/H10079785/thinkphp/lang/zh-cn.php ( 3.78 KB )
/www/users/H10079785/application/route.php ( 1.38 KB )
/www/users/H10079785/application/website/controller/Plan.php ( 3.82 KB )
/www/users/H10079785/application/common/controller/Common.php ( 13.58 KB )
/www/users/H10079785/thinkphp/library/think/Controller.php ( 5.99 KB )
/www/users/H10079785/thinkphp/library/traits/controller/Jump.php ( 4.82 KB )
/www/users/H10079785/application/common/model/Common.php ( 8.41 KB )
/www/users/H10079785/thinkphp/library/think/Model.php ( 64.03 KB )
/www/users/H10079785/thinkphp/library/think/Db.php ( 6.39 KB )
/www/users/H10079785/thinkphp/library/think/db/connector/Mysql.php ( 3.82 KB )
/www/users/H10079785/thinkphp/library/think/db/Connection.php ( 28.97 KB )
/www/users/H10079785/thinkphp/library/think/db/Query.php ( 86.77 KB )
/www/users/H10079785/thinkphp/library/think/db/builder/Mysql.php ( 2.09 KB )
/www/users/H10079785/thinkphp/library/think/db/Builder.php ( 29.48 KB )
/www/users/H10079785/thinkphp/library/think/Debug.php ( 6.85 KB )
/www/users/H10079785/thinkphp/library/think/Cookie.php ( 7.04 KB )
/www/users/H10079785/thinkphp/library/think/View.php ( 6.63 KB )
/www/users/H10079785/thinkphp/library/think/view/driver/Think.php ( 5.45 KB )
/www/users/H10079785/thinkphp/library/think/Template.php ( 45.34 KB )
/www/users/H10079785/thinkphp/library/think/template/driver/File.php ( 2.17 KB )
/www/users/H10079785/application/common/model/Navigation.php ( 0.57 KB )
/www/users/H10079785/thinkphp/library/think/Url.php ( 12.65 KB )
/www/users/H10079785/application/common/model/Category.php ( 1.21 KB )
/www/users/H10079785/application/common/model/Plan.php ( 0.54 KB )
/www/users/H10079785/application/common/model/PlanPic.php ( 0.58 KB )
/www/users/H10079785/application/common/library/Page.php ( 15.82 KB )
/www/users/H10079785/runtime/temp/f34b264db8bd01e806bf90e6c3a284f6.php ( 8.72 KB )
/www/users/H10079785/thinkphp/library/think/Response.php ( 8.24 KB )
/www/users/H10079785/thinkphp/library/think/debug/Html.php ( 4.16 KB )
/www/users/H10079785/thinkphp/library/think/Cache.php ( 5.96 KB )

[ DB ] CONNECT:[ UseTime:0.000880s ] mysql:dbname=skyflon;host=192.69.199.123;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `system` [ RunTime:0.001305s ]
[ SQL ] SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000368s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'system', 'type' => 'system', 'possible_keys' => 'PRIMARY', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1, 'extra' => '', ) ]
[ SQL ] SHOW COLUMNS FROM `navigation` [ RunTime:0.001083s ]
[ SQL ] SELECT `id`,`name`,`code`,`subcode`,`subname`,`url`,`flag_open`,`flag_drop` FROM `navigation` WHERE `flag_pos` = 1 ORDER BY order_value,id LIMIT 0,5 [ RunTime:0.000336s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'navigation', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `navigation` WHERE `flag_pos` = 1 LIMIT 1 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'navigation', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `category` [ RunTime:0.000911s ]
[ SQL ] SELECT `id`,`name` FROM `category` WHERE `cat_type` = 2 AND `flag_status` = 1 AND `parent_id` = 0 ORDER BY order_value,id LIMIT 0,100 [ RunTime:0.000248s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `category` WHERE `cat_type` = 2 AND `flag_status` = 1 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000200s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`name` FROM `category` WHERE `cat_type` = 3 AND `flag_status` = 1 AND `parent_id` = 0 ORDER BY order_value,id LIMIT 0,100 [ RunTime:0.000208s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `category` WHERE `cat_type` = 3 AND `flag_status` = 1 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000186s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `plan` [ RunTime:0.000908s ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 24 LIMIT 1 [ RunTime:0.000323s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 25 LIMIT 1 [ RunTime:0.000244s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 26 LIMIT 1 [ RunTime:0.000241s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 27 LIMIT 1 [ RunTime:0.000232s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 28 LIMIT 1 [ RunTime:0.000236s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 29 LIMIT 1 [ RunTime:0.000222s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 30 LIMIT 1 [ RunTime:0.000222s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 31 LIMIT 1 [ RunTime:0.000227s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`name`,`code`,`subcode`,`subname`,`url`,`flag_open`,`flag_drop` FROM `navigation` WHERE `flag_pos` = 2 ORDER BY order_value,id LIMIT 0,3 [ RunTime:0.000203s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'navigation', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `navigation` WHERE `flag_pos` = 2 LIMIT 1 [ RunTime:0.000160s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'navigation', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`name` FROM `category` WHERE `cat_type` = 2 AND `flag_status` = 1 AND `parent_id` = 0 ORDER BY order_value,id LIMIT 0,100 [ RunTime:0.000210s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `category` WHERE `cat_type` = 2 AND `flag_status` = 1 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000197s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`name` FROM `category` WHERE `cat_type` = 1 AND `flag_status` = 1 AND `parent_id` = 0 ORDER BY order_value,id LIMIT 0,100 [ RunTime:0.000204s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `category` WHERE `cat_type` = 1 AND `flag_status` = 1 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000185s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` ORDER BY order_value,publish_time DESC LIMIT 0,9 [ RunTime:0.000330s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `plan` LIMIT 1 [ RunTime:0.000148s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'index', 'possible_keys' => NULL, 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => NULL, 'rows' => 8, 'extra' => 'Using index', ) ]
[ SQL ] SELECT * FROM `category` WHERE `cat_type` = 3 AND `parent_id` = 0 AND `flag_status` = 1 ORDER BY order_value,id LIMIT 0,100 [ RunTime:0.000281s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `category` WHERE `cat_type` = 3 AND `parent_id` = 0 AND `flag_status` = 1 LIMIT 1 [ RunTime:0.000187s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 18, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 24 LIMIT 1 [ RunTime:0.000240s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 25 LIMIT 1 [ RunTime:0.000327s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 26 LIMIT 1 [ RunTime:0.000231s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 27 LIMIT 1 [ RunTime:0.000230s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 28 LIMIT 1 [ RunTime:0.000226s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 29 LIMIT 1 [ RunTime:0.000226s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 30 LIMIT 1 [ RunTime:0.000228s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `plan` WHERE `cat_id` = 31 LIMIT 1 [ RunTime:0.000218s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'plan', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'extra' => 'Using where', ) ]

0.074627s