[ DB ] CONNECT:[ UseTime:0.000401s ] mysql:host=127.0.0.1;dbname=by_dj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `byyl_products` [ RunTime:0.000622s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `byyl_products` `a` LEFT JOIN `byyl_admin` `b` ON `a`.`uid`=`b`.`id` WHERE `a`.`flag` = 1 AND `a`.`toindex` = 1 LIMIT 1 [ RunTime:0.166420s ]
[ SQL ] SELECT `a`.*,`b`.`company`,`b`.`mobile`,`b`.`nickname`,`b`.`jf_score` FROM `byyl_products` `a` LEFT JOIN `byyl_admin` `b` ON `a`.`uid`=`b`.`id` WHERE `a`.`flag` = 1 AND `a`.`toindex` = 1 ORDER BY b.jf_score desc, a.id desc LIMIT 830,5 [ RunTime:0.057427s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `byyl_products` WHERE `flag` = 1 AND `toindex` = 1 LIMIT 1 [ RunTime:0.005462s ]
[ SQL ] SHOW COLUMNS FROM `byyl_cat` [ RunTime:0.001166s ]
[ SQL ] SELECT * FROM `byyl_cat` WHERE `pid` = 0 [ RunTime:0.001003s ]
