[ DB ] CONNECT:[ UseTime:0.000880s ] mysql:host=101.201.70.13;port=3306;dbname=yizhayan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzyarticleclass` [ RunTime:0.001444s ]
[ SQL ] SELECT * FROM `yzyarticleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.000558s ]
[ SQL ] SHOW COLUMNS FROM `yzyarticle` [ RunTime:0.001335s ]
[ 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.000712s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuypricerange` [ RunTime:0.001311s ]
[ SQL ] SELECT * FROM `yzygroupbuypricerange` ORDER BY `gprange_start` [ RunTime:0.000460s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuyclass` [ RunTime:0.001552s ]
[ SQL ] SELECT * FROM `yzygroupbuyclass` ORDER BY `gclass_sort` ASC [ RunTime:0.000889s ]
[ SQL ] SHOW COLUMNS FROM `yzyvrgroupbuyclass` [ RunTime:0.001184s ]
[ SQL ] SELECT * FROM `yzyvrgroupbuyclass` ORDER BY `vrgclass_sort` ASC [ RunTime:0.000456s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuy` [ RunTime:0.001217s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 0 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1610920724 AND `groupbuy_endtime` > 1610920724 LIMIT 1 [ RunTime:0.000955s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 0 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1610920724 AND `groupbuy_endtime` > 1610920724 ORDER BY `groupbuy_state` ASC LIMIT 0,9 [ RunTime:0.000868s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 1 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1610920724 AND `groupbuy_endtime` > 1610920724 LIMIT 1 [ RunTime:0.000917s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_recommended` = 1 AND `groupbuy_is_vr` = 1 AND `groupbuy_state` = 20 AND `groupbuy_starttime` < 1610920724 AND `groupbuy_endtime` > 1610920724 ORDER BY `groupbuy_state` ASC LIMIT 0,9 [ RunTime:0.000800s ]