乐山职业技术学院财经管理系

基本文件流程错误 SQL 调试

D:\IIS_WebSite\think_cjx\public\index.php ( 1.27 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\base.php ( 2.60 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Loader.php ( 21.07 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\composer\autoload_static.php ( 14.44 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\abs.php ( 0.81 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\acos.php ( 1.04 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\acosh.php ( 0.90 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\acot.php ( 0.74 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\acoth.php ( 0.76 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\acsc.php ( 0.83 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\acsch.php ( 0.86 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\argument.php ( 0.81 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\asec.php ( 0.83 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\asech.php ( 0.85 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\asin.php ( 1.01 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\asinh.php ( 0.91 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\atan.php ( 1.34 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\atanh.php ( 1.08 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\conjugate.php ( 0.74 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\cos.php ( 0.92 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\cosh.php ( 0.90 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\cot.php ( 0.83 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\coth.php ( 0.74 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\csc.php ( 0.82 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\csch.php ( 0.84 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\exp.php ( 0.92 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\inverse.php ( 0.87 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\ln.php ( 0.94 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\log2.php ( 1.06 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\log10.php ( 1.08 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\negative.php ( 0.76 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\pow.php ( 1.27 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\rho.php ( 0.84 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\sec.php ( 0.71 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\sech.php ( 0.74 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\sin.php ( 0.87 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\sinh.php ( 0.90 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\sqrt.php ( 0.81 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\tan.php ( 1.21 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\tanh.php ( 1.11 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\functions\theta.php ( 1.25 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\operations\add.php ( 1.26 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\operations\subtract.php ( 1.28 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\operations\multiply.php ( 1.41 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\operations\divideby.php ( 1.75 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\complex\classes\src\operations\divideinto.php ( 1.75 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\topthink\think-helper\src\helper.php ( 2.88 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\adjoint.php ( 0.66 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\antidiagonal.php ( 0.68 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\cofactors.php ( 0.67 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\determinant.php ( 0.68 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\diagonal.php ( 0.66 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\identity.php ( 0.67 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\inverse.php ( 0.66 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\minors.php ( 0.66 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\trace.php ( 0.66 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\functions\transpose.php ( 0.67 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\operations\add.php ( 0.85 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\operations\directsum.php ( 0.86 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\operations\subtract.php ( 0.87 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\operations\multiply.php ( 0.88 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\operations\divideby.php ( 0.85 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\markbaker\matrix\classes\src\operations\divideinto.php ( 0.93 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\topthink\think-captcha\src\helper.php ( 1.59 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Route.php ( 60.23 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Config.php ( 6.38 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Validate.php ( 41.63 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\ezyang\htmlpurifier\library\HTMLPurifier.composer.php ( 0.10 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\qiniu\php-sdk\src\Qiniu\functions.php ( 7.67 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\qiniu\php-sdk\src\Qiniu\Config.php ( 3.37 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\topthink\think-queue\src\common.php ( 1.19 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Console.php ( 23.13 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Error.php ( 3.75 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\convention.php ( 10.37 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\App.php ( 21.54 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Request.php ( 49.78 KB )
D:\IIS_WebSite\think_cjx\app\config.php ( 9.58 KB )
D:\IIS_WebSite\think_cjx\app\database.php ( 0.74 KB )
D:\IIS_WebSite\think_cjx\data\conf\database.php ( 0.50 KB )
D:\IIS_WebSite\think_cjx\app\debug.php ( 0.69 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Hook.php ( 4.71 KB )
D:\IIS_WebSite\think_cjx\app\tags.php ( 1.33 KB )
D:\IIS_WebSite\think_cjx\app\common.php ( 4.28 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Env.php ( 1.21 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\common.php ( 56.53 KB )
D:\IIS_WebSite\think_cjx\simplewind\extend\think\facade\Route.php ( 0.74 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\helper.php ( 17.30 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Debug.php ( 7.13 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\behavior\InitHookBehavior.php ( 1.71 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Cache.php ( 6.10 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Log.php ( 6.05 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\cache\driver\File.php ( 7.27 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\cache\Driver.php ( 5.98 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Collection.php ( 10.91 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Lang.php ( 7.23 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\lang\zh-cn.php ( 11.81 KB )
D:\IIS_WebSite\think_cjx\app\route.php ( 0.76 KB )
D:\IIS_WebSite\think_cjx\data\conf\route.php ( 13.45 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\behavior\LangBehavior.php ( 1.20 KB )
D:\IIS_WebSite\think_cjx\simplewind\extend\think\facade\Lang.php ( 0.73 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\lang\zh-cn.php ( 3.08 KB )
D:\IIS_WebSite\think_cjx\app\admin\lang\zh-cn\common.php ( 0.60 KB )
D:\IIS_WebSite\think_cjx\app\portal\lang\zh-cn\common.php ( 0.76 KB )
D:\IIS_WebSite\think_cjx\app\portal\lang\zh-cn.php ( 0.93 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\behavior\InitAppHookBehavior.php ( 1.64 KB )
D:\IIS_WebSite\think_cjx\app\portal\controller\ListController.php ( 1.61 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\controller\HomeBaseController.php ( 7.83 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\controller\BaseController.php ( 2.50 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Controller.php ( 6.07 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\traits\controller\Jump.php ( 4.90 KB )
D:\IIS_WebSite\think_cjx\simplewind\extend\think\facade\Hook.php ( 1.46 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Cookie.php ( 7.54 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\View.php ( 6.77 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\view\driver\Think.php ( 5.64 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Template.php ( 44.90 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\template\driver\File.php ( 2.24 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\behavior\HomeLangBehavior.php ( 1.09 KB )
D:\IIS_WebSite\think_cjx\app\portal\lang\zh-cn\home.php ( 0.62 KB )
D:\IIS_WebSite\think_cjx\app\portal\model\PortalCategoryModel.php ( 9.74 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Model.php ( 69.14 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Db.php ( 6.67 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\db\connector\Mysql.php ( 3.89 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\db\Connection.php ( 29.97 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\db\Query.php ( 93.74 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\db\builder\Mysql.php ( 4.53 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\db\Builder.php ( 31.55 KB )
D:\IIS_WebSite\think_cjx\app\admin\model\ThemeModel.php ( 8.12 KB )
D:\IIS_WebSite\think_cjx\app\portal\taglib\Portal.php ( 9.41 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\template\TagLib.php ( 12.30 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\lib\taglib\Cmf.php ( 11.63 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\template\taglib\Cx.php ( 23.82 KB )
D:\IIS_WebSite\think_cjx\data\runtime\temp\1cbaa6307c7e5726d7b6c436a3fa88e2.php ( 18.59 KB )
D:\IIS_WebSite\think_cjx\app\admin\model\NavMenuModel.php ( 6.40 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\model\Collection.php ( 2.27 KB )
D:\IIS_WebSite\think_cjx\simplewind\extend\tree\Tree.php ( 13.84 KB )
D:\IIS_WebSite\think_cjx\app\admin\model\RouteModel.php ( 6.39 KB )
D:\IIS_WebSite\think_cjx\app\portal\url.php ( 1.55 KB )
D:\IIS_WebSite\think_cjx\app\user\url.php ( 0.98 KB )
D:\IIS_WebSite\think_cjx\simplewind\extend\think\facade\Url.php ( 0.73 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Url.php ( 12.72 KB )
D:\IIS_WebSite\think_cjx\app\portal\service\ApiService.php ( 16.40 KB )
D:\IIS_WebSite\think_cjx\app\portal\model\PortalPostModel.php ( 11.49 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\db\Expression.php ( 1.11 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\paginator\Bootstrap.php ( 7.37 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Paginator.php ( 9.75 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\lib\Storage.php ( 3.89 KB )
D:\IIS_WebSite\think_cjx\simplewind\cmf\lib\storage\Local.php ( 2.86 KB )
D:\IIS_WebSite\think_cjx\app\portal\service\PostService.php ( 9.61 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery.php ( 41.76 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\DOMEvent.php ( 2.25 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\DOMDocumentWrapper.php ( 22.46 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\phpQueryEvents.php ( 4.85 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\Callback.php ( 4.02 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\phpQueryObject.php ( 87.75 KB )
D:\IIS_WebSite\think_cjx\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\compat\mbstring.php ( 1.51 KB )
D:\IIS_WebSite\think_cjx\app\admin\service\ApiService.php ( 1.33 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\Response.php ( 8.28 KB )
D:\IIS_WebSite\think_cjx\simplewind\thinkphp\library\think\debug\Html.php ( 4.17 KB )

[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=10.0.10.105;port=3306;dbname=thinkcmf5;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 26 AND `status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.000000s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'zhiyuan' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8, 'filtered' => 12.5, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.000000s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 42, 'filtered' => 2.3809523582458496, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `post`.`create_time` >= 0 AND ( `category_post`.`category_id` = '26' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1652818681 ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'PRIMARY', 'table' => '<derived2>', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `post`.`create_time` >= 0 AND ( `category_post`.`category_id` = '26' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1652818681 ) GROUP BY `post`.`id` ORDER BY `category_post`.`list_order`,`post`.`create_time` DESC LIMIT 0,10 [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category_post', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => 'const', 'rows' => 5, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.000000s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.015625s ]
[ 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 `cmf_portal_category` WHERE `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.031250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 54, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `b`.`category_id` IN ('41','42','43') AND `a`.`post_type` = 1 ) LIMIT 1 [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => NULL, 'rows' => 53, 'filtered' => 100.0, 'extra' => 'Using index condition', ) ]
[ SQL ] SELECT `a`.*,b.id AS post_category_id,`b`.`list_order`,`b`.`category_id`,`u`.`user_login`,`u`.`user_nickname`,`u`.`user_email` FROM `cmf_portal_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `b`.`category_id` IN ('41','42','43') AND `a`.`post_type` = 1 ) ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.031250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'b', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => NULL, 'rows' => 53, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 22 LIMIT 1 [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-21-22-%' [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 54, 'filtered' => 1.8518518209457397, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( post.is_top=1 ) AND ( `category_post`.`category_id` = '22' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1652818681 ) GROUP BY `post`.`id` ORDER BY `category_post`.`list_order`,`post`.`published_time` DESC LIMIT 1 [ RunTime:0.031250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category_post', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => 'const', 'rows' => 60, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '22' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1652818681 ) GROUP BY `post`.`id` ORDER BY `post`.`recommended`,`post`.`is_top`,`category_post`.`list_order`,`post`.`published_time` DESC LIMIT 5 [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category_post', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => 'const', 'rows' => 60, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 44 LIMIT 1 [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-8-44-%' [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 54, 'filtered' => 1.8518518209457397, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( post.is_top=1 ) AND ( `category_post`.`category_id` = '44' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1652818681 ) GROUP BY `post`.`id` ORDER BY `category_post`.`list_order`,`post`.`published_time` DESC LIMIT 1 [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category_post', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => 'const', 'rows' => 1785, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `post`.*,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( post.id != 3372 ) AND ( `category_post`.`category_id` = '44' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1652818681 ) GROUP BY `post`.`id` ORDER BY `post`.`recommended`,`post`.`is_top`,`category_post`.`list_order`,`post`.`published_time` DESC LIMIT 5 [ RunTime:0.031250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category_post', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => 'const', 'rows' => 1785, 'filtered' => 100.0, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000000s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 42, 'filtered' => 2.3809523582458496, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.015625s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_link', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'status', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9, 'filtered' => 100.0, 'extra' => 'Using where; Using filesort', ) ]

科研与产学合作News

校企育人匠心筑梦 ——乐山职业技术学院开展第二届麦当劳现代学徒制班毕业典礼暨新

财经管理系开展第十届大学生素质教育创新系部分论坛交流活动

财经管理系教师杨鸿应邀参加京东商家学习中心讲师认证评审工作

财经管理系开展“互联网+”大学生创新创业大赛与创新创业教育讲座

财经管理系开展“信息化教学国赛经验分享”讲座

科研与产学合作News

校企育人 匠心筑梦 ——乐山职业技术学院开展第二届麦当劳现代学徒制班毕业典礼暨新

财经管理系开展第十届大学生素质教育创新系部分论坛交流活动

财经管理系教师杨鸿应邀参加京东商家学习中心讲师认证评审工作

财经管理系开展“互联网+”大学生创新创业大赛与创新创业教育讲座

财经管理系开展“信息化教学国赛经验分享”讲座

校企育人匠心筑梦 ——乐山职业技术学院开展第二届麦当劳现代学徒制班毕业典礼暨新