[ DB ] CONNECT:[ UseTime:0.000381s ] mysql:host=127.0.0.1;dbname=by_dj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `byyl_products` [ RunTime:0.000589s ]
[ 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.008236s ]
[ 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 80,5 [ RunTime:0.044661s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `byyl_products` WHERE `flag` = 1 AND `toindex` = 1 LIMIT 1 [ RunTime:0.005323s ]
[ SQL ] SHOW COLUMNS FROM `byyl_cat` [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `byyl_cat` WHERE `pid` = 0 [ RunTime:0.000247s ]
