[ DB ] CONNECT:[ UseTime:0.000326s ] mysql:host=127.0.0.1;port=3306;dbname=the1sneaker;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_picture` [ RunTime:0.001505s ]
[ 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 ('20','21','27','28','29','30','55') GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.084447s ]
[ 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 ('20','21','27','28','29','30','55') GROUP BY `a`.`id` ORDER BY `a`.`listorder` ASC,`a`.`id` ASC LIMIT 72,12 [ RunTime:0.207320s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.001511s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( status=1 AND parentid = 0 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.001260s ]
[ SQL ] SHOW COLUMNS FROM `yzn_attachment` [ RunTime:0.001187s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000206s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000313s ]
[ SQL ] SELECT `path`,`driver`,`thumb` FROM `yzn_attachment` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000236s ]
[ SQL ] SHOW COLUMNS FROM `yzn_addons` [ RunTime:0.001192s ]
[ SQL ] SELECT `config` FROM `yzn_addons` WHERE `name` = 'returntop' AND `status` = 1 LIMIT 1 [ RunTime:0.000886s ]