[ DB ] CONNECT:[ UseTime:0.000339s ] mysql:host=127.0.0.1;port=3306;dbname=the1sneaker;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_picture` [ RunTime:0.001776s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `yzn_picture` `a` LEFT JOIN `yzn_attachment` `b` ON `a`.`imageurl`=`b`.`id` LEFT JOIN `yzn_specs` `c` ON `a`.`id`=`c`.`goodsid` WHERE `a`.`status` = '1' AND `a`.`catid` IN ('34','98','49','37','51','118','38','99','69') GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.175929s ]
[ SQL ] SELECT a.id,a.catid,a.title,b.path,a.itemnumber, MAX(c.price) as max_price FROM `yzn_picture` `a` LEFT JOIN `yzn_attachment` `b` ON `a`.`imageurl`=`b`.`id` LEFT JOIN `yzn_specs` `c` ON `a`.`id`=`c`.`goodsid` WHERE `a`.`status` = '1' AND `a`.`catid` IN ('34','98','49','37','51','118','38','99','69') GROUP BY `a`.`id` ORDER BY `a`.`listorder` ASC,`a`.`id` ASC LIMIT 216,12 [ RunTime:0.275862s ]
[ SQL ] SHOW COLUMNS FROM `yzn_addons` [ RunTime:0.001175s ]
[ SQL ] SELECT `config` FROM `yzn_addons` WHERE `name` = 'returntop' AND `status` = 1 LIMIT 1 [ RunTime:0.000239s ]
