SHOW FULL COLUMNS FROM `zzw_config` [ RunTime:0.002515s ]
SELECT * FROM `zzw_config` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `zzw_common_cat` [ RunTime:0.001803s ]
SELECT * FROM `zzw_common_cat` WHERE `deltime` = '' AND `parent_id` = 0 ORDER BY `sort` ASC,`id` ASC LIMIT 0,4 [ RunTime:0.000629s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 15 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000596s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 16 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000544s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 14 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000445s ]
SELECT * FROM `zzw_common_cat` WHERE `parent_id` = 13 AND `deltime` = '' ORDER BY `sort` ASC LIMIT 0,8 [ RunTime:0.000472s ]
SELECT `url` FROM `zzw_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `zzw_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `zzw_bearing_brand` [ RunTime:0.001859s ]
SELECT `id`,`brandname`,`thumb` FROM `zzw_bearing_brand` WHERE `deltime` = '' AND `is_shop` = 1 ORDER BY `id` ASC [ RunTime:0.000970s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000468s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 15 ORDER BY `sort` ASC [ RunTime:0.000688s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 16 ORDER BY `sort` ASC [ RunTime:0.000487s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 14 ORDER BY `sort` ASC [ RunTime:0.000477s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000476s ]
SELECT `id`,`catname` FROM `zzw_common_cat` WHERE `deltime` = '' AND `is_show` = 1 AND `parent_id` = 62 ORDER BY `sort` ASC [ RunTime:0.000422s ]
SHOW FULL COLUMNS FROM `zzw_sell` [ RunTime:0.002186s ]
SELECT `chandi` FROM `zzw_sell` `g` WHERE `status` = 2 AND `deltime` = '' AND `is_on_sale` = 1 GROUP BY `chandi` [ RunTime:0.003639s ]
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.003571s ]
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 30,15 [ RunTime:0.004196s ]