[ 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 ]