SHOW FULL COLUMNS FROM `zzw_config` [ RunTime:0.002265s ]
SELECT * FROM `zzw_config` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `zzw_common_cat` [ RunTime:0.001353s ]
SELECT * FROM `zzw_common_cat` WHERE `deltime` = '' AND `parent_id` = 0 ORDER BY `sort` ASC,`id` ASC LIMIT 0,4 [ RunTime:0.000598s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 15 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000644s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 16 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000492s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 14 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000469s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 13 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000847s ]
SELECT `url` FROM `zzw_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000502s ]
SELECT * FROM `zzw_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `zzw_bearing_brand` [ RunTime:0.002188s ]
SELECT `id`,`brandname`,`thumb` FROM `zzw_bearing_brand` WHERE `deltime` = '' AND `is_shop` = 1 ORDER BY `id` ASC [ RunTime:0.001073s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000577s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 15 ORDER BY `sort` ASC [ RunTime:0.000594s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 16 ORDER BY `sort` ASC [ RunTime:0.000504s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 14 ORDER BY `sort` ASC [ RunTime:0.000455s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000460s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 62 ORDER BY `sort` ASC [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `zzw_sell` [ RunTime:0.001939s ]
SELECT `chandi` FROM `zzw_sell` `g` WHERE `status` = 2 AND `deltime` = '' AND `is_on_sale` = 1 GROUP BY `chandi` [ RunTime:0.003068s ]
SELECT COUNT(*) AS think_count FROM `zzw_sell` `s` LEFT JOIN `zzw_common_cat` `cc` ON `s`.`catid`=`cc`.`id` LEFT JOIN `zzw_bearing_brand` `bb` ON `s`.`brandid`=`bb`.`id` LEFT JOIN `zzw_supplier` `su` ON `s`.`supplier_id`=`su`.`id` WHERE `s`.`deltime` = '' AND `s`.`is_on_sale` = '1' AND `s`.`status` = '2' AND `s`.`typeid` = '14' AND ( 1=1 AND s.typeid=14 ) [ RunTime:0.003359s ]
SELECT `s`.`id`,`s`.`title`,`s`.`image`,`s`.`catid`,`s`.`count`,`s`.`brandid`,`s`.`supplier_id`,`s`.`addtime`,`s`.`size`,`s`.`unit`,`s`.`chandi`,`s`.`baozhuang`,`cc`.`catname`,`bb`.`brandname`,`su`.`xingming`,`su`.`corpname`,su.id as supid,su.type as corptype,`su`.`account` FROM `zzw_sell` `s` LEFT JOIN `zzw_common_cat` `cc` ON `s`.`catid`=`cc`.`id` LEFT JOIN `zzw_bearing_brand` `bb` ON `s`.`brandid`=`bb`.`id` LEFT JOIN `zzw_supplier` `su` ON `s`.`supplier_id`=`su`.`id` WHERE `s`.`deltime` = '' AND `s`.`is_on_sale` = '1' AND `s`.`status` = '2' AND `s`.`typeid` = '14' AND ( 1=1 AND s.typeid=14 ) ORDER BY `s`.`id` DESC LIMIT 45,15 [ RunTime:0.003694s ]