[ DB ] CONNECT:[ UseTime:0.000834s ] mysql:host=101.201.70.13;port=3306;dbname=yizhayan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzyarticleclass` [ RunTime:0.001318s ]
[ SQL ] SELECT * FROM `yzyarticleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.000568s ]
[ SQL ] SHOW COLUMNS FROM `yzyarticle` [ RunTime:0.001279s ]
[ SQL ] SELECT `article`.`article_id`,`article`.`ac_id`,`article`.`article_url`,`article`.`article_title`,`article`.`article_time`,`article_class`.`ac_name`,`article_class`.`ac_parent_id` FROM `yzyarticle` `article` LEFT JOIN `yzyarticleclass` `article_class` ON `article`.`ac_id`=`article_class`.`ac_id` WHERE ( article.article_show = '1' and (article_class.ac_id <= 7 or (article_class.ac_parent_id > 0 and article_class.ac_parent_id <= 7)) ) ORDER BY `article_sort` ASC,`article_time` DESC LIMIT 300 [ RunTime:0.000700s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuypricerange` [ RunTime:0.001127s ]
[ SQL ] SELECT * FROM `yzygroupbuypricerange` ORDER BY `gprange_start` [ RunTime:0.000495s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuyclass` [ RunTime:0.001116s ]
[ SQL ] SELECT * FROM `yzygroupbuyclass` ORDER BY `gclass_sort` ASC [ RunTime:0.000519s ]
[ SQL ] SHOW COLUMNS FROM `yzyvrgroupbuyclass` [ RunTime:0.001102s ]
[ SQL ] SELECT * FROM `yzyvrgroupbuyclass` ORDER BY `vrgclass_sort` ASC [ RunTime:0.000487s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuy` [ RunTime:0.001255s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 0 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591418740 AND `groupbuy_endtime` > 1591418740 LIMIT 1 [ RunTime:0.000657s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 0 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591418740 AND `groupbuy_endtime` > 1591418740 ORDER BY `groupbuy_state` ASC LIMIT 0,9 [ RunTime:0.001176s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 1 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591418740 AND `groupbuy_endtime` > 1591418740 LIMIT 1 [ RunTime:0.000598s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 1 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591418740 AND `groupbuy_endtime` > 1591418740 ORDER BY `groupbuy_state` ASC LIMIT 0,9 [ RunTime:0.000793s ]
