SHOW COLUMNS FROM `zowo_product` [ RunTime:0.0010s ]
SELECT * FROM `zowo_product` WHERE ( id = 119 and pro_status=1 ) LIMIT 1 [ RunTime:0.0007s ]
SHOW COLUMNS FROM `zowo_pro_relation_attr` [ RunTime:0.0012s ]
SELECT ra.id,ra.aid,a.name,ra.pid,ra.max,ra.min,a.unit FROM zowo_pro_relation_attr ra LEFT JOIN zowo_pro_attr a on a.id=ra.aid WHERE ( a.status=1 and ra.status=1 and ra.pid in(119) ) ORDER BY orderby,id [ RunTime:0.0007s ]
SHOW COLUMNS FROM `zowo_pro_relationships` [ RunTime:0.0007s ]
SELECT `cid` FROM `zowo_pro_relationships` WHERE ( object_id=119 and status=1 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT p.id,r.cid,`pro_title` FROM zowo_product p left JOIN zowo_pro_relationships r on r.object_id=p.id WHERE ( pro_status=1 and r.cid in(31) and r.status=1 and id<>119 ) ORDER BY pro_recommended desc,r.listorder desc,p.id desc [ RunTime:0.0013s ]
SHOW COLUMNS FROM `zowo_pro_cat` [ RunTime:0.0007s ]
SELECT `id`,`parent`,`attrs`,`seo_title`,`name`,`seo_keywords`,`seo_description` FROM `zowo_pro_cat` WHERE ( id=31 and status = 1 ) ORDER BY recommended desc,listorder,id LIMIT 1 [ RunTime:0.0002s ]
SELECT `id`,`name` FROM `zowo_pro_cat` WHERE ( parent=0 and status=1 and type=0 ) ORDER BY recommended desc,listorder,id [ RunTime:0.0003s ]
SELECT `parent`,`id`,`name` FROM `zowo_pro_cat` WHERE ( status=1 and type=0 and parent = 8 ) ORDER BY recommended desc,listorder,id [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zowo_pro_attr` [ RunTime:0.0004s ]
SELECT `id`,`id`,`name`,`range`,`unit` FROM `zowo_pro_attr` WHERE ( id in(2) ) ORDER BY orderby,id [ RunTime:0.0002s ]
SELECT `id`,r.cid,`pro_title`,`pro_image` FROM zowo_product p left JOIN zowo_pro_relationships r on r.object_id=p.id WHERE ( id in(92,93,95,102,106,109,111,113,118,120) and pro_status=1 ) ORDER BY pro_recommended desc,r.listorder desc,p.id desc [ RunTime:0.0012s ]
SELECT ra.id,ra.aid,a.name,ra.pid,ra.max,ra.min,a.unit FROM zowo_pro_relation_attr ra LEFT JOIN zowo_pro_attr a on a.id=ra.aid WHERE ( a.status=1 and ra.status=1 and ra.pid in(106,95,93,102,120,118,113,111,109,92) ) ORDER BY orderby,id desc [ RunTime:0.0004s ]
UPDATE `zowo_product` SET `pro_hits`=pro_hits+1 WHERE ( id=119 ) [ RunTime:0.0003s ]
SELECT `path` FROM `zowo_pro_cat` WHERE `id` = '31' LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `zowo_pro_cat` WHERE `id` IN ('0','8','31') ORDER BY path ASC [ RunTime:0.0002s ]
SHOW COLUMNS FROM `zowo_ad` [ RunTime:0.0007s ]
SELECT `ad_id`,`ad_img`,`ad_url`,length(ad_content) as content_len FROM `zowo_ad` WHERE ( status=1 and length(ad_img) and ad_img is not null and cat_ids like '%"31"%' ) ORDER BY orderby desc,ad_id LIMIT 1 [ RunTime:0.0002s ]
SHOW COLUMNS FROM `zowo_options` [ RunTime:0.0006s ]
SELECT `option_value` FROM `zowo_options` WHERE `option_name` = 'cdn_settings' LIMIT 1 [ RunTime:0.0002s ]
SELECT `id`,`id`,`name` FROM `zowo_pro_cat` WHERE ( status=1 and parent=0 and type = 0 ) ORDER BY recommended desc,listorder,id [ RunTime:0.0006s ]
SELECT `id`,`id`,`parent`,`name` FROM `zowo_pro_cat` WHERE ( parent in(4,5,6,7,8,11,40,42,44,46) and status=1 ) ORDER BY recommended desc,listorder,id [ RunTime:0.0005s ]
SHOW COLUMNS FROM `zowo_pro_keyword` [ RunTime:0.0013s ]
SELECT if(r.kid is null,0,count(r.kid)) as number,r.kid as id,k.name FROM zowo_pro_keyword k LEFT JOIN zowo_pro_relation_key r on k.id= r.kid and r.status=1 LEFT JOIN zowo_product p on p.id= r.pid WHERE ( k.type=1 and (p.id is null or p.pro_status = 1) ) GROUP BY k.id ORDER BY k.listorder desc,r.kid [ RunTime:0.0039s ]
SHOW COLUMNS FROM `zowo_links` [ RunTime:0.0006s ]
SELECT * FROM `zowo_links` WHERE ( link_status=1 ) ORDER BY listorder ASC [ RunTime:0.0003s ]
SELECT * FROM `zowo_pro_keyword` WHERE ( is_footer=1 ) ORDER BY listorder desc,id [ RunTime:0.0006s ]
