[ DB ] CONNECT:[ UseTime:0.000990s ] mysql:host=172.31.22.73;port=3306;dbname=wanci;charset=utf8
[ SQL ] SHOW COLUMNS FROM `psl_media` [ slave|RunTime:0.001049s ]
[ SQL ] SELECT * FROM `psl_media` WHERE `id` = 99 LIMIT 1 [ slave|RunTime:0.000666s ]
[ 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_99_2021_03` [ slave|RunTime:0.000971s ]
[ 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_99_2021_03` WHERE `status` = 1 AND `id` = 2676284 LIMIT 1 [ slave|RunTime:0.001750s ]
[ EXPLAIN : array (
'id' => '1',
'select_type' => 'SIMPLE',
'table' => 'psl_news_99_2021_03',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => 'const',
'rows' => '1',
'filtered' => '100.00',
'extra' => NULL,
) ]
[ DB ] CONNECT:[ UseTime:0.000361s ] mysql:host=172.31.22.71;port=3306;dbname=wanci;charset=utf8
[ SQL ] UPDATE `psl_news_99_2021_03` SET `is_pushed` = 1 WHERE `id` = 2676284 [ master|RunTime:0.002403s ]
[ SQL ] SHOW COLUMNS FROM `psl_material_paragraph_24` [ slave|RunTime:0.000960s ]
[ SQL ] SELECT `content` FROM `psl_material_paragraph_24` WHERE `id` IN (567046,566535,566791,567047,566536,566792,567048,566537) [ slave|RunTime:0.003021s ]
[ 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.001190s ]
[ 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.001005s ]
[ 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.000946s ]
[ 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.000704s ]
[ 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` = 99 LIMIT 1 [ slave|RunTime:0.000712s ]
[ 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_99_2021_03` WHERE `status` = 1 AND `id` = 2676284 LIMIT 1 [ master|RunTime:0.000546s ]
[ EXPLAIN : array (
'id' => '1',
'select_type' => 'SIMPLE',
'table' => 'psl_news_99_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 (567046,566535,566791,567047,566536,566792,567048,566537) [ slave|RunTime:0.000722s ]
[ 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.000883s ]
[ SQL ] SELECT * FROM `psl_material_category` WHERE `id` = 6660 LIMIT 1 [ slave|RunTime:0.000669s ]
[ 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.001059s ]
[ 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.000916s ]
[ 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.003715s ]
[ 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.000731s ]
[ 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.000842s ]
[ SQL ] INSERT INTO `psl_news_log_2021_04` (`mid` , `ip` , `url` , `create_time` , `url_index` , `is_spider` , `template_id`) VALUES (99 , '114.229.52.148' , '/hy/kfrvbgg-916-2676284.html' , 1617328384 , 5 , 0 , 8) [ master|RunTime:0.000431s ]
[ SQL ] SHOW COLUMNS FROM `psl_weblog_24` [ slave|RunTime:0.000875s ]
[ SQL ] INSERT INTO `psl_weblog_24` (`admin_id` , `ip` , `location` , `os` , `browser` , `otime` , `title` , `url`) VALUES (9323 , '114.229.52.148' , '中国 江苏 镇江市' , 'Macintosh' , 'Chrome' , 1617328384 , '北京o2ophp建设,网站管理' , 'http://www.coatingol.com/hyzx/hy/kfrvbgg-916-2676284.html') [ master|RunTime:0.000455s ]