[ DB ] CONNECT:[ UseTime:0.043452s ] mysql:host=rm-j6csc6vq961xarb29.mysql.rds.aliyuncs.com;port=3306;dbname=ludiyoule_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzt_option` [ RunTime:0.021982s ]
[ SQL ] SELECT `option_value` FROM `yzt_option` WHERE `option_name` = 'site_info' LIMIT 1 [ RunTime:0.021816s ]
[ SQL ] SHOW COLUMNS FROM `yzt_city` [ RunTime:0.037068s ]
[ 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.015911s ]
[ 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 81,200 [ RunTime:0.018470s ]
[ SQL ] SHOW COLUMNS FROM `yzt_link` [ RunTime:0.021830s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_category` [ RunTime:0.018450s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( `status` = 1 AND `status` = 1 ) AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000841s ]
[ SQL ] SELECT `name` FROM `yzt_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000464s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000461s ]
[ SQL ] SELECT `name` FROM `yzt_portal_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000420s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000460s ]
[ SQL ] SELECT `alias` FROM `yzt_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.021549s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.021761s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_post` [ RunTime:0.017874s ]
[ 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` = '471' AND `relation`.`post_id` = '1312' LIMIT 1 [ RunTime:0.021571s ]
[ 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` < '1571735788' AND `post`.`published_time` > '0' ) AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '471' AND `relation`.`post_id` < '1312' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000984s ]
[ 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` < '1571735788' AND `post`.`published_time` > '0' ) AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '471' AND `relation`.`post_id` > '1312' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000845s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.001897s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE `id` = 471 AND `status` = 1 LIMIT 1 [ RunTime:0.000537s ]
[ SQL ] UPDATE `yzt_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 1312 [ RunTime:0.001241s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( id =471 ) LIMIT 1 [ RunTime:0.000553s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( id =469 ) LIMIT 1 [ RunTime:0.026227s ]
[ SQL ] SELECT * FROM `yzt_portal_category` WHERE ( id =4 ) LIMIT 1 [ RunTime:0.021795s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.018161s ]
[ SQL ] SHOW COLUMNS FROM `yzt_theme_file` [ RunTime:0.000724s ]
[ SQL ] SELECT `more` FROM `yzt_theme_file` WHERE `theme` = 'text10' AND ( `is_public` = 1 OR `file` = 'portal/article_product' ) [ RunTime:0.000474s ]
[ 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.011126s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 [ RunTime:0.000600s ]
[ 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.000788s ]
[ 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 0,4 [ RunTime:0.000716s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.001923s ]
[ SQL ] SHOW COLUMNS FROM `yzt_portal_keyword_post` [ RunTime:0.000727s ]
[ 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.016187s ]
[ 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 7400,8 [ RunTime:0.012993s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.001955s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzt_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 LIMIT 1 [ RunTime:0.001282s ]
[ 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 79,5 [ RunTime:0.000933s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.001985s ]
[ 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.000607s ]
[ 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.000603s ]
[ 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.000935s ]
[ 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.001838s ]
[ 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.000521s ]
[ SQL ] SELECT `id` FROM `yzt_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 [ RunTime:0.004239s ]
[ 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.000744s ]
[ 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.002568s ]
[ SQL ] SELECT * FROM `yzt_city` WHERE `pinyin` = 'ludiyoule' LIMIT 1 [ RunTime:0.001859s ]
[ 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.012894s ]
扫码添加了解更多
全国咨询热线
碰碰车5.jpg"/>
碰碰车9.jpg"/>
在线客服
