[ DB ] CONNECT:[ UseTime:0.053828s ] mysql:host=rm-j6csc6vq961xarb29.mysql.rds.aliyuncs.com;port=3306;dbname=ludiyoule_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzt_option` [ RunTime:0.006902s ]
[ SQL ] SELECT `option_value` FROM `yzt_option` WHERE `option_name` = 'site_info' LIMIT 1 [ RunTime:0.000490s ]
[ SQL ] SHOW COLUMNS FROM `yzt_city` [ RunTime:0.000884s ]
[ 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.003726s ]
[ SQL ] SELECT `c`.`id`,`c`.`pinyin`,`d`.`describe`,`c`.`describe_id`,`c`.`name_en`,`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 43,200 [ RunTime:0.001990s ]
[ SQL ] SHOW COLUMNS FROM `yzt_link` [ RunTime:0.017632s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_category` [ RunTime:0.017844s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( `status` = 1 AND `status` = 1 ) AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.015757s ]
[ SQL ] SELECT `name` FROM `yzt_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.011592s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.013722s ]
[ SQL ] SELECT `name` FROM `yzt_portal_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.017634s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.019775s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.019784s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.015790s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.010614s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_post` [ RunTime:0.000853s ]
[ SQL ] SELECT `post`.* FROM `yzt_portal_post` `post` INNER JOIN `yzt_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '440' AND `relation`.`post_id` = '1220' LIMIT 1 [ RunTime:0.000659s ]
[ SQL ] SELECT `post`.* FROM `yzt_portal_post` `post` INNER JOIN `yzt_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` <> 2 AND ( `post`.`published_time` < '1571732397' AND `post`.`published_time` > '0' ) AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '440' AND `relation`.`post_id` < '1220' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000904s ]
[ SQL ] SELECT `post`.* FROM `yzt_portal_post` `post` INNER JOIN `yzt_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` <> 2 AND ( `post`.`published_time` < '1571732397' AND `post`.`published_time` > '0' ) AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '440' AND `relation`.`post_id` > '1220' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000906s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.001820s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE `id` = 440 AND `status` = 1 LIMIT 1 [ RunTime:0.000542s ]
[ SQL ] UPDATE `yzt_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 1220 [ RunTime:0.001177s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( id =440 ) LIMIT 1 [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( id =4 ) LIMIT 1 [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.001880s ]
[ SQL ] SHOW COLUMNS FROM `yzt_theme_file` [ RunTime:0.023444s ]
[ SQL ] SELECT `more` FROM `yzt_theme_file` WHERE `theme` = 'text10' AND ( `is_public` = 1 OR `file` = 'portal/article_product' ) [ 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.003149s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 [ RunTime:0.000584s ]
[ 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 (406,418,433,440,445,469,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.000734s ]
[ 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 (406,418,433,440,445,469,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 4,4 [ RunTime:0.000731s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.015022s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_keyword_post` [ RunTime:0.000767s ]
[ 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.019390s ]
[ 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 3288,8 [ RunTime:0.021755s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.021650s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.008792s ]
[ 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 1079,5 [ RunTime:0.003094s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.002015s ]
[ 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` = 2218 LIMIT 1 [ RunTime:0.000859s ]
[ 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` = 2219 LIMIT 1 [ RunTime:0.010920s ]
[ 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` = 2220 LIMIT 1 [ RunTime:0.014824s ]
[ 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` = 2221 LIMIT 1 [ RunTime:0.012262s ]
[ 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` = 2222 LIMIT 1 [ RunTime:0.015052s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 [ RunTime:0.011965s ]
[ 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 (406,418,433,440,445,469,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) LIMIT 1 [ RunTime:0.021637s ]
[ 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 (406,418,433,440,445,469,'4') AND `p`.`post_status` = 1 AND ( (p.post_type = 1 or p.post_type = 3) ) ORDER BY `p`.`id` DESC LIMIT 0,5 [ RunTime:0.021685s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.021649s ]
[ 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.000785s ]
扫码添加了解更多
全国咨询热线
撞撞球.jpg"/>
悠波球[2].jpg"/>
在线客服
