[ DB ] CONNECT:[ UseTime:0.030994s ] mysql:host=rm-j6csc6vq961xarb29.mysql.rds.aliyuncs.com;port=3306;dbname=cnsoftweb_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzt_option` [ RunTime:0.001435s ]
[ SQL ] SELECT `option_value` FROM `yzt_option` WHERE `option_name` = 'site_info' LIMIT 1 [ RunTime:0.000584s ]
[ SQL ] SHOW COLUMNS FROM `yzt_city` [ RunTime:0.000881s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `yzt_city` `c` INNER JOIN `yzt_city_keyword` `ck` ON `c`.`id`=`ck`.`city_id` WHERE ( c.status=1 ) AND ( c.level<3 ) GROUP BY `c`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.046851s ]
[ SQL ] SELECT `c`.`id`,`c`.`pinyin`,`d`.`describe`,`c`.`describe_id`,`c`.`name` FROM `yzt_city` `c` INNER JOIN `yzt_city_keyword` `ck` ON `c`.`id`=`ck`.`city_id` INNER JOIN `yzt_describe` `d` ON `c`.`describe_id`=`d`.`id` WHERE ( c.status=1 ) AND ( c.level<3 ) GROUP BY `c`.`id` LIMIT 71,200 [ RunTime:0.047381s ]
[ SQL ] SHOW COLUMNS FROM `yzt_link` [ RunTime:0.000949s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_category` [ RunTime:0.001014s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( `status` = 1 AND `status` = 1 ) AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000690s ]
[ SQL ] SELECT `name` FROM `yzt_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000462s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000442s ]
[ SQL ] SELECT `name` FROM `yzt_portal_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000447s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000447s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.017618s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003002s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.046020s ]
[ SQL ] SELECT `option_value` FROM `yzt_option` WHERE `option_name` = 'marketing_bool' LIMIT 1 [ RunTime:0.000506s ]
[ SQL ] SHOW COLUMNS FROM `yzt_theme_file` [ RunTime:0.000934s ]
[ SQL ] SELECT `more` FROM `yzt_theme_file` WHERE `theme` = 'text10' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.000589s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( `status` = 1 AND `status` = 1 ) AND `delete_time` = 0 AND `parent_id` = 0 ORDER BY `list_order` ASC LIMIT 0,6 [ RunTime:0.000666s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_keyword_post` [ RunTime:0.000789s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(p.keyword_id) FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` ) `_group_count_` LIMIT 1 [ RunTime:0.018988s ]
[ SQL ] SELECT `l`.`id`,`l`.`name`,`l`.`alias`,`p`.`keyword_id`,`l`.`name_city` FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` LIMIT 38,3 [ RunTime:0.002062s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.047005s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( `status` = 1 AND `status` = 1 ) AND `delete_time` = 0 AND `parent_id` = 4 LIMIT 0,18 [ RunTime:0.000969s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 [ RunTime:0.000526s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_post` [ RunTime:0.002835s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (408,409,410,414,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.043014s ]
[ SQL ] SELECT p.id as post_id,`p`.`published_time`,`p`.`thumbnail`,`p`.`post_title`,`p`.`post_excerpt`,`cp`.`category_id`,`p`.`post_title_city` FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (408,409,410,414,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 7,9 [ RunTime:0.000905s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.002993s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( `status` = 1 AND `status` = 1 ) AND `delete_time` = 0 AND `parent_id` = 4 LIMIT 0,18 [ RunTime:0.000721s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 408 [ RunTime:0.000479s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (408) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.015760s ]
[ SQL ] SELECT p.id as post_id,`p`.`published_time`,`p`.`thumbnail`,`p`.`post_title`,`p`.`post_excerpt`,`cp`.`category_id`,`p`.`post_title_city` FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (408) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 0,9 [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.002974s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 409 [ RunTime:0.000527s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (409) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.000631s ]
[ SQL ] SELECT p.id as post_id,`p`.`published_time`,`p`.`thumbnail`,`p`.`post_title`,`p`.`post_excerpt`,`cp`.`category_id`,`p`.`post_title_city` FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (409) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 0,9 [ RunTime:0.026579s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.002957s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 410 [ RunTime:0.078836s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (410) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.000728s ]
[ SQL ] SELECT p.id as post_id,`p`.`published_time`,`p`.`thumbnail`,`p`.`post_title`,`p`.`post_excerpt`,`cp`.`category_id`,`p`.`post_title_city` FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (410) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 0,9 [ RunTime:0.000785s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.001929s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 414 [ RunTime:0.000604s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (414) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.000662s ]
[ SQL ] SELECT p.id as post_id,`p`.`published_time`,`p`.`thumbnail`,`p`.`post_title`,`p`.`post_excerpt`,`cp`.`category_id`,`p`.`post_title_city` FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (414) AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 0,9 [ RunTime:0.028536s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003045s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 [ RunTime:0.000619s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (408,409,410,414,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.000807s ]
[ SQL ] SELECT p.id as post_id,`p`.`published_time`,`p`.`thumbnail`,`p`.`post_title`,`p`.`post_excerpt`,`cp`.`category_id`,`p`.`post_title_city` FROM `yzt_portal_post` `p` INNER JOIN `yzt_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`category_id` IN (408,409,410,414,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 3,4 [ RunTime:0.030683s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.007128s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.000628s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 12,5 [ RunTime:0.001359s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.030493s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 869 LIMIT 1 [ RunTime:0.000851s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 870 LIMIT 1 [ RunTime:0.002485s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 871 LIMIT 1 [ RunTime:0.044793s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 872 LIMIT 1 [ RunTime:0.000634s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 873 LIMIT 1 [ RunTime:0.000588s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(p.keyword_id) FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` ) `_group_count_` LIMIT 1 [ RunTime:0.001551s ]
[ SQL ] SELECT `l`.`id`,`l`.`name`,`l`.`alias`,`p`.`keyword_id`,`l`.`name_city` FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` LIMIT 30,4 [ RunTime:0.001750s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.044174s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.000634s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 14,9 [ RunTime:0.000821s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003524s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 871 LIMIT 1 [ RunTime:0.000583s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 872 LIMIT 1 [ RunTime:0.000554s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 873 LIMIT 1 [ RunTime:0.000524s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 874 LIMIT 1 [ RunTime:0.041334s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 875 LIMIT 1 [ RunTime:0.000747s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 876 LIMIT 1 [ RunTime:0.000509s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 877 LIMIT 1 [ RunTime:0.000506s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 878 LIMIT 1 [ RunTime:0.000921s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 879 LIMIT 1 [ RunTime:0.000641s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.001649s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 28,9 [ RunTime:0.043985s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003033s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 885 LIMIT 1 [ RunTime:0.000691s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 886 LIMIT 1 [ RunTime:0.001260s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 887 LIMIT 1 [ RunTime:0.000553s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 888 LIMIT 1 [ RunTime:0.043519s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 889 LIMIT 1 [ RunTime:0.001187s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 890 LIMIT 1 [ RunTime:0.000548s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 891 LIMIT 1 [ RunTime:0.001049s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 892 LIMIT 1 [ RunTime:0.000544s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 893 LIMIT 1 [ RunTime:0.000683s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.002683s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 53,9 [ RunTime:0.042231s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003090s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 910 LIMIT 1 [ RunTime:0.000455s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 911 LIMIT 1 [ RunTime:0.000538s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 912 LIMIT 1 [ RunTime:0.000509s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 913 LIMIT 1 [ RunTime:0.000499s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 914 LIMIT 1 [ RunTime:0.000498s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 915 LIMIT 1 [ RunTime:0.042726s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 916 LIMIT 1 [ RunTime:0.000533s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 917 LIMIT 1 [ RunTime:0.000500s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 918 LIMIT 1 [ RunTime:0.000519s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.000566s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 50,9 [ RunTime:0.000889s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.002982s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 907 LIMIT 1 [ RunTime:0.000523s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 908 LIMIT 1 [ RunTime:0.000522s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 909 LIMIT 1 [ RunTime:0.000478s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 910 LIMIT 1 [ RunTime:0.041030s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 911 LIMIT 1 [ RunTime:0.000593s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 912 LIMIT 1 [ RunTime:0.000536s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 913 LIMIT 1 [ RunTime:0.000517s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 914 LIMIT 1 [ RunTime:0.001923s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 915 LIMIT 1 [ RunTime:0.001554s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(p.keyword_id) FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` ) `_group_count_` LIMIT 1 [ RunTime:0.043640s ]
[ SQL ] SELECT `l`.`id`,`l`.`name`,`l`.`alias`,`p`.`keyword_id`,`l`.`name_city` FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` LIMIT 134,11 [ RunTime:0.001929s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003363s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(p.keyword_id) FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` ) `_group_count_` LIMIT 1 [ RunTime:0.001700s ]
[ SQL ] SELECT `l`.`id`,`l`.`name`,`l`.`alias`,`p`.`keyword_id`,`l`.`name_city` FROM `yzt_portal_keyword_post` `p` LEFT JOIN `yzt_keyword_list` `l` ON `p`.`keyword_id`=`l`.`id` WHERE `l`.`p_id` > 0 GROUP BY `p`.`keyword_id` LIMIT 66,4 [ RunTime:0.043644s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.004156s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.000740s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 28,9 [ RunTime:0.000748s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.044449s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 885 LIMIT 1 [ RunTime:0.000568s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 886 LIMIT 1 [ RunTime:0.000554s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 887 LIMIT 1 [ RunTime:0.000540s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 888 LIMIT 1 [ RunTime:0.000801s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 889 LIMIT 1 [ RunTime:0.000521s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 890 LIMIT 1 [ RunTime:0.000517s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 891 LIMIT 1 [ RunTime:0.000503s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 892 LIMIT 1 [ RunTime:0.042565s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 893 LIMIT 1 [ RunTime:0.000542s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.000591s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 17,9 [ RunTime:0.000715s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003004s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 874 LIMIT 1 [ RunTime:0.000571s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 875 LIMIT 1 [ RunTime:0.000688s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 876 LIMIT 1 [ RunTime:0.000536s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 877 LIMIT 1 [ RunTime:0.041775s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 878 LIMIT 1 [ RunTime:0.000579s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 879 LIMIT 1 [ RunTime:0.000679s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 880 LIMIT 1 [ RunTime:0.000547s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 881 LIMIT 1 [ RunTime:0.000673s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 882 LIMIT 1 [ RunTime:0.002633s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.000577s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 52,9 [ RunTime:0.043405s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.003078s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 909 LIMIT 1 [ RunTime:0.000671s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 910 LIMIT 1 [ RunTime:0.002707s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 911 LIMIT 1 [ RunTime:0.001226s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 912 LIMIT 1 [ RunTime:0.041280s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 913 LIMIT 1 [ RunTime:0.001329s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 914 LIMIT 1 [ RunTime:0.000509s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 915 LIMIT 1 [ RunTime:0.000510s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 916 LIMIT 1 [ RunTime:0.000507s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 917 LIMIT 1 [ RunTime:0.000512s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.000542s ]
[ SQL ] SELECT `id`,`published_time`,`thumbnail`,`post_title`,`post_excerpt`,`create_time`,`post_title_city` FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 25,9 [ RunTime:0.044604s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'cnsoftweb' LIMIT 1 [ RunTime:0.004266s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 882 LIMIT 1 [ RunTime:0.000751s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 883 LIMIT 1 [ RunTime:0.000614s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 884 LIMIT 1 [ RunTime:0.001014s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 885 LIMIT 1 [ RunTime:0.042467s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 886 LIMIT 1 [ RunTime:0.000544s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 887 LIMIT 1 [ RunTime:0.000462s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 888 LIMIT 1 [ RunTime:0.000538s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 889 LIMIT 1 [ RunTime:0.000488s ]
[ SQL ] SELECT `kl`.`id`,`kl`.`alias` FROM `yzt_portal_keyword_post` `kp` INNER JOIN `yzt_keyword_list` `kl` ON `kp`.`keyword_id`=`kl`.`id` WHERE `kp`.`post_id` = 890 LIMIT 1 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( `status` = 1 AND `status` = 1 ) AND `delete_time` = 0 AND `parent_id` = 0 ORDER BY `list_order` ASC LIMIT 0,6 [ RunTime:0.041856s ]
Scan QR code
Customer Hot Line
