php吉他介绍网源代码,php线上制作源码,设计代码定制-热门-【网畅】-阀门网

该博客记录了管理员9323对多个数据库表的操作,包括查询psl_media、psl_news_89_2021_03、psl_material_paragraph_24、psl_user、psl_site_info和psl_news_log_2021_04的数据,涉及内容筛选、用户角色关联及网站信息获取。
摘要由CSDN通过智能技术生成

[ DB ] CONNECT:[ UseTime:0.001183s ] mysql:host=172.31.22.73;port=3306;dbname=wanci;charset=utf8

[ SQL ] SHOW COLUMNS FROM `psl_media` [ slave|RunTime:0.001179s ]

[ SQL ] SELECT * FROM `psl_media` WHERE `id` = 89 LIMIT 1 [ slave|RunTime:0.000648s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_media',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `psl_news_89_2021_03` [ slave|RunTime:0.000973s ]

[ SQL ] SELECT `id`,`admin_id`,`category_id`,`industry_code`,`industry_value`,`title`,`title_suffix`,`url`,`url_index`,`template_name`,`content_header_footer`,`content`,`images`,`image_preview_url`,`status`,`publish_time`,`baidu_spider`,`is_pushed`,`create_time`,`update_time` FROM `psl_news_89_2021_03` WHERE `status` = 1 AND `id` = 3937764 LIMIT 1 [ slave|RunTime:0.001635s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_news_89_2021_03',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `psl_material_paragraph_24` [ slave|RunTime:0.000869s ]

[ SQL ] SELECT `content` FROM `psl_material_paragraph_24` WHERE `id` IN (546851,546340,546596,546852,546341,546597,546853,546342) [ slave|RunTime:0.000631s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_material_paragraph_24',

'partitions' => NULL,

'type' => 'range',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => NULL,

'rows' => '8',

'filtered' => '100.00',

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `psl_user` [ slave|RunTime:0.001172s ]

[ SQL ] SELECT `u`.*,ru.role_id as role_id FROM `psl_user` `u` LEFT JOIN `psl_role_user` `ru` ON `u`.`id`=`ru`.`user_id` WHERE `u`.`id` = '9323' LIMIT 1 [ slave|RunTime:0.000994s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'u',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '8',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `psl_site_info` [ slave|RunTime:0.001001s ]

[ SQL ] SELECT `id`,`admin_id`,`site_title`,`site_title_suffix`,`seo_keywords`,`seo_description`,`logo`,`pc_site`,`mobile_site`,`share_link`,`share_link_type`,`company_name`,`contact_name`,`mobile`,`mobile_tel`,`fax`,`wximg`,`wechat`,`qq`,`email`,`address`,`lng_lat`,`statistical_code`,`site_template_id`,`site_template_name`,`about_us_image`,`about_us_content`,`is_service_open`,`create_time`,`update_time`,`identification`,`nav_color`,`is_show_push` FROM `psl_site_info` WHERE `admin_id` = 9323 LIMIT 1 [ slave|RunTime:0.000679s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_site_info',

'partitions' => NULL,

'type' => 'ref',

'possible_keys' => 'admin_id',

'key' => 'admin_id',

'key_len' => '4',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SELECT * FROM `psl_media` WHERE `id` = 89 LIMIT 1 [ slave|RunTime:0.000710s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_media',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SELECT `id`,`admin_id`,`category_id`,`industry_code`,`industry_value`,`title`,`title_suffix`,`url`,`url_index`,`template_name`,`content_header_footer`,`content`,`images`,`image_preview_url`,`status`,`publish_time`,`baidu_spider`,`is_pushed`,`create_time`,`update_time` FROM `psl_news_89_2021_03` WHERE `status` = 1 AND `id` = 3937764 LIMIT 1 [ slave|RunTime:0.000793s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_news_89_2021_03',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SELECT `content` FROM `psl_material_paragraph_24` WHERE `id` IN (546851,546340,546596,546852,546341,546597,546853,546342) [ slave|RunTime:0.000738s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_material_paragraph_24',

'partitions' => NULL,

'type' => 'range',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => NULL,

'rows' => '8',

'filtered' => '100.00',

'extra' => 'Using where',

) ]

[ SQL ] SHOW COLUMNS FROM `psl_material_category` [ slave|RunTime:0.001052s ]

[ SQL ] SELECT * FROM `psl_material_category` WHERE `id` = 6662 LIMIT 1 [ slave|RunTime:0.000634s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_material_category',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '4',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SELECT `u`.*,ru.role_id as role_id FROM `psl_user` `u` LEFT JOIN `psl_role_user` `ru` ON `u`.`id`=`ru`.`user_id` WHERE `u`.`id` = '9323' LIMIT 1 [ slave|RunTime:0.001066s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'u',

'partitions' => NULL,

'type' => 'const',

'possible_keys' => 'PRIMARY',

'key' => 'PRIMARY',

'key_len' => '8',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `psl_site_banner` [ slave|RunTime:0.000872s ]

[ SQL ] SELECT `id`,`admin_id`,`position`,`title`,`image`,`url`,`status`,`list_order`,`create_time`,`update_time` FROM `psl_site_banner` WHERE `status` = 1 AND `admin_id` = 9323 [ slave|RunTime:0.003761s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_site_banner',

'partitions' => NULL,

'type' => 'ALL',

'possible_keys' => NULL,

'key' => NULL,

'key_len' => NULL,

'ref' => NULL,

'rows' => '2931',

'filtered' => '1.00',

'extra' => 'Using where',

) ]

[ SQL ] SELECT `id`,`admin_id`,`site_title`,`site_title_suffix`,`seo_keywords`,`seo_description`,`logo`,`pc_site`,`mobile_site`,`share_link`,`share_link_type`,`company_name`,`contact_name`,`mobile`,`mobile_tel`,`fax`,`wximg`,`wechat`,`qq`,`email`,`address`,`lng_lat`,`statistical_code`,`site_template_id`,`site_template_name`,`about_us_image`,`about_us_content`,`is_service_open`,`create_time`,`update_time`,`identification`,`nav_color`,`is_show_push` FROM `psl_site_info` WHERE `admin_id` = 9323 LIMIT 1 [ slave|RunTime:0.000855s ]

[ EXPLAIN : array (

'id' => '1',

'select_type' => 'SIMPLE',

'table' => 'psl_site_info',

'partitions' => NULL,

'type' => 'ref',

'possible_keys' => 'admin_id',

'key' => 'admin_id',

'key_len' => '4',

'ref' => 'const',

'rows' => '1',

'filtered' => '100.00',

'extra' => NULL,

) ]

[ SQL ] SHOW COLUMNS FROM `psl_news_log_2021_04` [ slave|RunTime:0.000782s ]

[ DB ] CONNECT:[ UseTime:0.000470s ] mysql:host=172.31.22.71;port=3306;dbname=wanci;charset=utf8

[ SQL ] INSERT INTO `psl_news_log_2021_04` (`mid` , `ip` , `url` , `create_time` , `url_index` , `is_spider` , `template_id`) VALUES (89 , '114.230.124.93' , '/lctfchf-3937764.html' , 1617253311 , 2 , 0 , 13) [ master|RunTime:0.000590s ]

[ SQL ] SHOW COLUMNS FROM `psl_weblog_24` [ slave|RunTime:0.001001s ]

[ SQL ] INSERT INTO `psl_weblog_24` (`admin_id` , `ip` , `location` , `os` , `browser` , `otime` , `title` , `url`) VALUES (9323 , '114.230.124.93' , '中国 江苏 扬州市' , 'Macintosh' , 'Chrome' , 1617253311 , 'php线上制作源码,设计代码定制' , 'http://www.famens.com/qyhy/lctfchf-3937764.html') [ master|RunTime:0.000574s ]

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值