mysql1479_艺课-少儿艺术课程之中国画基础教程(免费)

最新推荐文章于 2021-11-23 12:59:45 发布
最新推荐文章于 2021-11-23 12:59:45 发布
阅读量100 收藏
点赞数
文章标签： mysql1479
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_31094177/article/details/113557635
版权

[ DB ] CONNECT:[ UseTime:0.000384s ] mysql:host=127.0.0.1;port=3306;dbname=zhmw;charset=utf8

[ SQL ] SHOW COLUMNS FROM `mt_auxiliar_website` [ RunTime:0.000799s ]

[ SQL ] SELECT * FROM `mt_auxiliar_website` LIMIT 1 [ RunTime:0.000284s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_auxiliar_website',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_auction_setup` [ RunTime:0.000750s ]

[ SQL ] SELECT * FROM `mt_auction_setup` LIMIT 1 [ RunTime:0.000245s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_auction_setup',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_auction_order` [ RunTime:0.000878s ]

[ SQL ] SELECT `money` FROM `mt_auction_order` WHERE `is_pay` = 2 [ RunTime:0.000260s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_auction_order',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 52,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_hands_order` [ RunTime:0.000802s ]

[ SQL ] SELECT `price` FROM `mt_hands_order` [ RunTime:0.000288s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_hands_order',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 2,

'extra' => '',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_admin_menu` [ RunTime:0.000857s ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 211 AND `status` = 1 LIMIT 3 [ RunTime:0.000261s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 2,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 201 AND `status` = 1 [ RunTime:0.000292s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 1,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 196 AND `status` = 1 [ RunTime:0.000352s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 1,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 191 AND `status` = 1 [ RunTime:0.000323s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 1,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 184 AND `status` = 1 [ RunTime:0.000301s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 2,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 177 AND `status` = 1 [ RunTime:0.000315s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 2,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 172 AND `status` = 1 [ RunTime:0.000394s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 2,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 167 AND `status` = 1 AND `type` = 1 LIMIT 3 [ RunTime:0.000277s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 2,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_examination_type` [ RunTime:0.000857s ]

[ SQL ] SELECT * FROM `mt_examination_type` WHERE `status` = 0 [ RunTime:0.000302s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 5,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_juvenile_type` [ RunTime:0.000752s ]

[ SQL ] SELECT * FROM `mt_juvenile_type` WHERE `status` = 0 [ RunTime:0.000248s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 8,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_celebrity_type` [ RunTime:0.000808s ]

[ SQL ] SELECT * FROM `mt_celebrity_type` WHERE `status` = 0 [ RunTime:0.001579s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 4,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_class_examination` [ RunTime:0.001819s ]

[ SQL ] SELECT * FROM `mt_class_examination` WHERE `status` = 0 ORDER BY `c_time` DESC LIMIT 8 [ RunTime:0.000687s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_class_examination',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 9,

'extra' => 'Using where; Using filesort',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_class_juvenile` [ RunTime:0.001272s ]

[ SQL ] SELECT * FROM `mt_class_juvenile` WHERE `status` = 0 ORDER BY `c_time` DESC LIMIT 8 [ RunTime:0.000450s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_class_juvenile',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 14,

'extra' => 'Using where; Using filesort',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_class_celebrity` [ RunTime:0.001257s ]

[ SQL ] SELECT * FROM `mt_class_celebrity` WHERE `status` = 0 ORDER BY `c_time` DESC LIMIT 8 [ RunTime:0.000533s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_class_celebrity',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 16,

'extra' => 'Using where; Using filesort',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000373s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000346s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000350s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000371s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 4 AND `status` = 0 LIMIT 1 [ RunTime:0.000254s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 4 AND `status` = 0 LIMIT 1 [ RunTime:0.000361s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 4 AND `status` = 0 LIMIT 1 [ RunTime:0.000283s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_examination_type` WHERE `id` = 4 AND `status` = 0 LIMIT 1 [ RunTime:0.000268s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 8 AND `status` = 0 LIMIT 1 [ RunTime:0.000280s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 2 AND `status` = 0 LIMIT 1 [ RunTime:0.000254s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 2 AND `status` = 0 LIMIT 1 [ RunTime:0.000253s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 8 AND `status` = 0 LIMIT 1 [ RunTime:0.000290s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 6 AND `status` = 0 LIMIT 1 [ RunTime:0.000277s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 6 AND `status` = 0 LIMIT 1 [ RunTime:0.000248s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 8 AND `status` = 0 LIMIT 1 [ RunTime:0.000257s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_juvenile_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000287s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000276s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000261s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000250s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000285s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000263s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000280s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000253s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT `title` FROM `mt_celebrity_type` WHERE `id` = 1 AND `status` = 0 LIMIT 1 [ RunTime:0.000277s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] SELECT * FROM `mt_admin_menu` WHERE `parent_id` = 211 LIMIT 3 [ RunTime:0.000424s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'ref',

'possible_keys' => 'parent_id',

'key' => 'parent_id',

'key_len' => '4',

'ref' => 'const',

'rows' => 5,

'extra' => '',

) ]

[ SQL ] SELECT `id`,`parent_id`,`name` FROM `mt_admin_menu` WHERE `parent_id` = 211 AND `status` = 1 AND `type` = 1 [ RunTime:0.000488s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_admin_menu',

'type' => 'index_merge',

'possible_keys' => 'status,parent_id',

'key' => 'parent_id,status',

'key_len' => '4,1',

'ref' => NULL,

'rows' => 2,

'extra' => 'Using intersect(parent_id,status); Using where',

) ]

[ SQL ] SELECT * FROM `mt_examination_type` WHERE `status` = 0 [ RunTime:0.000271s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_examination_type',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 5,

'extra' => 'Using where',

) ]

[ SQL ] SELECT * FROM `mt_juvenile_type` WHERE `status` = 0 [ RunTime:0.000278s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_juvenile_type',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 8,

'extra' => 'Using where',

) ]

[ SQL ] SELECT * FROM `mt_celebrity_type` WHERE `status` = 0 [ RunTime:0.000285s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_celebrity_type',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 4,

'extra' => 'Using where',

) ]

[ SQL ] SELECT * FROM `mt_class_juvenile` WHERE `class_type` = 1 AND `status` = 0 AND `id` = 19 LIMIT 1 [ RunTime:0.000485s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_class_juvenile',

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => 1,

'extra' => '',

) ]

[ SQL ] UPDATE `mt_class_juvenile` SET `clicks` = `clicks` + 1 WHERE `class_type` = 1 AND `status` = 0 AND `id` = 19 [ RunTime:0.008719s ]

[ SQL ] SELECT `cj`.*,juvenile_type.title as lx_name FROM `mt_class_juvenile` `cj` INNER JOIN `mt_juvenile_type` `juvenile_type` ON `cj`.`lx_id`=`juvenile_type`.`id` WHERE `cj`.`class_type` = '1' AND `cj`.`status` = '0' AND `cj`.`set_meal` = '1' AND `cj`.`id` <> '19' [ RunTime:0.000978s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'cj',

'type' => 'range',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => NULL,

'rows' => 8,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_all_comment` [ RunTime:0.001637s ]

[ SQL ] SELECT * FROM `mt_all_comment` WHERE `article_id` = 19 AND `type` = 21 AND `status` = 0 ORDER BY `parent_id` ASC,`comm_time` DESC LIMIT 0,10 [ RunTime:0.000747s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_all_comment',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 55,

'extra' => 'Using where; Using filesort',

) ]

[ SQL ] SELECT COUNT(*) AS tp_count FROM `mt_all_comment` WHERE `article_id` = 19 AND `type` = 21 AND `status` = 0 [ RunTime:0.000590s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_all_comment',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 55,

'extra' => 'Using where',

) ]

[ SQL ] SELECT `id`,`lx_id`,`class_type`,`fm_img`,`title`,`curriculum` FROM `mt_class_juvenile` WHERE `class_type` = 1 AND `status` = 0 AND `id` <> 19 [ RunTime:0.000776s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_class_juvenile',

'type' => 'range',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => NULL,

'rows' => 8,

'extra' => 'Using where',

) ]

[ SQL ] SELECT * FROM `mt_juvenile_type` WHERE `status` = 0 AND `id` = 0 LIMIT 1 [ RunTime:0.000327s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => NULL,

'type' => NULL,

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => NULL,

'extra' => 'Impossible WHERE noticed after reading const tables',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_theme_file` [ RunTime:0.000888s ]

[ SQL ] SELECT * FROM `mt_theme_file` WHERE `theme` = 'default' [ RunTime:0.000282s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_theme_file',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 1,

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `mt_theme` [ RunTime:0.000853s ]

[ SQL ] UPDATE `mt_theme` SET `name` = 'default' , `version` = '1.0.0' , `demo_url` = 'http://demo.thinkcmf.com' , `author` = 'ThinkCMF' , `lang` = 'zh-cn' , `author_url` = 'http://www.thinkcmf.com' , `keywords` = 'ThinkCMF默认模板' , `description` = 'ThinkCMF默认模板' WHERE `theme` = 'default' [ RunTime:0.000365s ]

[ SQL ] SELECT `more` FROM `mt_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'api/Yike/yikao_detail' ) [ RunTime:0.000640s ]

[ EXPLAIN : array (

'id' => 1,

'select_type' => 'SIMPLE',

'table' => 'mt_theme_file',

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => 1,

'extra' => 'Using where',

) ]

许多的小兵器
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql的使用25
Jack_Li
09-17 1587
mysql> create table listPart(     -> a int,b int)engine=innodb     -> partition p0values in (1,3,5,7,9),     -> partition p0values in (0,2,4,6,8)); ERROR 1064 (42000): You have an error in your SQ
mysql1479_1479. Sales by Day of the Week
weixin_35433930的博客
02-02 266
Table: Orders+---------------+---------+| Column Name | Type |+---------------+---------+| order_id | int || customer_id | int || order_date | date || item_id | varchar...
LeetCode MySQL 1479. 周内每天的销售情况（dayname星期几）
Michael是个半路程序员
07-30 1635
文章目录1. 题目2. 解题 1. 题目 表：Orders +---------------+---------+ | Column Name | Type | +---------------+---------+ | order_id | int | | customer_id | int | | order_date | date | | item_id | varchar | | quantity | int | +
LeetCode：Database 103.周内每天的销售情况
Xiao Miao的博客
06-19 355
要求：写一个SQL语句，报告 周内每天 每个商品类别下订购了多少单位，返回结果表单 按商品类别排序 。
mysql本人常遇到的错误码及解决办法(33种)
热门推荐
风华浪浪的博客
05-06 1万+
1406 pymysql.err.DataError: (1406, '') 传入的数据不正确（长度，类型有误） 1054 pymysql.err.InternalError: (1054, 'Unknown error 1054')
PHP_MySQL教程-第二天while循环与数据库操作第1/2页
10-30
通过这个标题我们可以了解到本课程的主要内容将集中在两个方面：如何利用PHP语言中的`while`循环结构进行数据库的操作，以及如何有效地从MySQL数据库中获取数据并在网页上展示出来。 #### 二、知识点详细解析 ####...
MySQL_python-1.2.5-cp27-none-win_amd64.whl
05-25
作者是by Christoph Gohlke, Laboratory for Fluorescence Dynamics, University ...安装mysql-python报下列错误“Python error: Microsoft Visual C++ 9.0 is required. Get it from”时可以使用，内含32位的和64位的
动力节点MySQL基础入门教程课程笔记-02
12-14
动力节点的杜老师讲述的mysql教程，详细讲解了MySQL的相关知识，包括MySQL概述，MySQL应用环境，MySQL系统特性，MySQL初学基础，MySQL管理工具，如何安装MySQL及MySQL新特性，通过观看可掌握MySQL全套知识。
动力节点MySQL基础入门教程课程笔记-01
12-14
动力节点的杜老师讲述的mysql教程，详细讲解了MySQL的相关知识，包括MySQL概述，MySQL应用环境，MySQL系统特性，MySQL初学基础，MySQL管理工具，如何安装MySQL及MySQL新特性，通过观看可掌握MySQL全套知识。
动力节点MySQL基础入门教程课程笔记-04
12-14
动力节点的杜老师讲述的mysql教程，详细讲解了MySQL的相关知识，包括MySQL概述，MySQL应用环境，MySQL系统特性，MySQL初学基础，MySQL管理工具，如何安装MySQL及MySQL新特性，通过观看可掌握MySQL全套知识。
mysql错误1451_mysql错误代号-J(1451~1494)
weixin_34857730的博客
01-19 2726
错误：1451 SQLSTATE: 23000(ER_ROW_IS_REFERENCED_2)消息：不能删除或更新父行，外键约束失败(%s)。·错误：1452 SQLSTATE: 23000(ER_NO_REFERENCED_ROW_2)消息：不能添加或更新子行，外键约束失败(%s)。·错误：1453 SQLSTATE: 42000(ER_SP_BAD_VAR_SHADOW)消息：必须用`...`...
mysql四种隔离级别与实现方式
liang9338的博客
12-17 3156
目录 一.自己的理解 二.网上的总结   一.自己的理解 READ UNCOMMITTED(RU) ： 对于修改的项加排它锁，直到事务结束释放；没有快照读，只能读最新版本的数据。 READ COMMITTED(RC) ：对于修改的项加排它锁，直到事务结束释放；有快照读，快照的粒度是语句级。 REPEATABLE READ(RR) ：对于修改的项加排它锁，直到事务结束释放；有快照读，快...
Python mysql-SQL概要
aitie1479的博客
09-06 91
2017-09-05 20:10:58 一、SQL语句及其种类 SQL使用关键字，表名，列名等组合成一条语句来描述操作的内容。关键字是指那些含义或者使用方法是先已经定义好的英语单词。根据RDBMS赋予的指令种类的不同，SQL语句可以分为以下三类： 数据定义语言DDL（data definition language）用来创建或者删除数据库以及数据库中的表等对象。DDL包含以下几...
mysql分区错误代码1486_mysql8 参考手册--错误代码1469-1493
weixin_42321075的博客
01-19 963
错误号1469; 符号： ER_HOSTNAME; SQLSTATE： HY000消息：主机名错误号1470; 符号： ER_WRONG_STRING_LENGTH; SQLSTATE： HY000消息：字符串'％s'对于％s来说太长(不应超过％d)错误号1471; 符号： ER_NON_INSERTABLE_TABLE; SQLSTATE： HY000消息：％s的目标表％s不可插入错误号1472...
mysql的error code含义
统哥哥的博客
11-23 2021
mysql error code(备忘) 转1005：创建表失败 1006：创建数据库失败 1007：数据库已存在，创建数据库失败 1008：数据库不存在，删除数据库失败 1009：不能删除数据库文件导致删除数据库失败 1010：不能删除数据目录导致删除数据库失败 1011：删除数据库文件失败 1012：不能读取系统表中的记录 1020：记录已被其他用户修改 1021：硬盘剩余空间不足，请加大硬盘可用空间 1022：关键字重复，更改记录失败 1023：关闭时发生错误 1024：读文件错误 1025：更改名字
Mysql 远程连接
aitie1479的博客
04-12 88
2018-04-12 20:23:48 Mysql数据库安装完成后通常不仅仅只在本地进行连接，同一局域网的其他用户也要能够访问的话，就需要对mysql数据库进行相关的配置，以下分别讨论了在安装了navicat后以及没有安装navicat的情况下，配置远程连接mysql的方法。 已安装navicat 如果安装了navicat，那么直接在navicat里进入数据库点击用户添加一...
mysql sycho_课程概述
weixin_39622123的博客
01-19 460
[ DB ] CONNECT:[ UseTime:0.010964s ] mysql:host=127.0.0.1;port=3306;dbname=sifc_cn;charset=utf8mb4[ SQL ] SHOW COLUMNS FROM `sifc_portal_post` [ RunTime:0.001279s ][ SQL ] SELECT * FROM `sifc_portal_p...
pillow_heif-0.17.0-pp39-pypy39_pp73-macosx_14_0_arm64.whl
07-27
基本介绍 名称与起源：Pillow，原名为PIL（Python Imaging Library），但PIL只支持Python 2版本。随着Python 3的普及，Pillow作为PIL的一个分支出现，兼容Python 3并提供更多的功能和改进。 主要功能：Pillow支持多种图像格式的打开、保存、显示以及基本的图像操作和处理，如裁剪、缩放、旋转、翻转、滤镜应用等。 跨平台性：Pillow库可以在不同的操作系统上运行，包括Windows、Linux和MacOS等。 主要功能模块 Pillow库包含多个功能模块，每个模块都提供了特定的图像处理功能。以下是一些常用的模块： Image：用于处理图像文件，提供打开、保存、调整大小、旋转、裁剪、滤镜等功能。 ImageDraw：提供在图像上绘制各种形状（如线条、矩形、圆形）和文本的功能。 ImageFont：用于加载和使用TrueType字体文件，以便在图像上绘制文本时设置字体样式、大小和颜色。 ImageFilter：提供各种滤镜效果，如模糊、锐化、边缘增强等，用于图像增强、特效处理和图像识别等应用。 ImageEnhance：用于调整图像的亮度、对比度、颜色饱和度等参数，使图像更加清晰、明亮或具有特定的调色效果。 高级功能 除了基本的图像处理功能外，Pillow还支持一些高级功能，如色彩空间转换、直方图均衡化等。这些功能可以帮助用户进行更复杂的图像处理和分析。
cykooz.resizer-3.0.0-cp310-cp310-macosx_11_0_arm64.whl
最新发布
07-27
python库，可以直接安装使用，再也不怕自己pip下载，出现等待超时的现象。欢迎下载使用，使用过程中如有使用问题，请及时与我沟通交流，帮你解决！ python库，可以直接安装使用，再也不怕自己pip下载，出现等待超时的现象。欢迎下载使用，使用过程中如有使用问题，请及时与我沟通交流，帮你解决！ python库，可以直接安装使用，再也不怕自己pip下载，出现等待超时的现象。欢迎下载使用，使用过程中如有使用问题，请及时与我沟通交流，帮你解决！ python库，可以直接安装使用，再也不怕自己pip下载，出现等待超时的现象。欢迎下载使用，使用过程中如有使用问题，请及时与我沟通交流，帮你解决！ python库，可以直接安装使用，再也不怕自己pip下载，出现等待超时的现象。欢迎下载使用，使用过程中如有使用问题，请及时与我沟通交流，帮你解决！
MySQL基础教程：轻松入门指南
"MySql_基础教程_非常基础_适合初学者.pdf" 是一本针对MySQL初学者的详实教程，由大漠孤烟版于2008年6月13日编译，内容覆盖了从基础到进阶的多个章节，包括但不限于SQL语言的基础概念、主要组成部分以及实际操作。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值