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 '%"46"%' ) ORDER BY orderby desc,ad_id LIMIT 1 [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zowo_pro_cat` [ RunTime:0.0008s ]
SELECT `id`,`parent`,`attrs`,`seo_title`,`name`,`seo_keywords`,`seo_description` FROM `zowo_pro_cat` WHERE ( id=46 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.0002s ]
SELECT `parent`,`id`,`name` FROM `zowo_pro_cat` WHERE ( status=1 and type=0 and parent = 46 ) ORDER BY recommended desc,listorder,id [ RunTime:0.0002s ]
SELECT `id`,`id`,`name`,`parent` FROM `zowo_pro_cat` WHERE ( parent=0 and status=1 and id in(46) ) ORDER BY recommended desc,listorder,id [ RunTime:0.0001s ]
SELECT `id`,`id`,parent as cid,`name`,`parent` FROM `zowo_pro_cat` WHERE ( parent in(46) and status=1 ) ORDER BY recommended desc,listorder,id [ RunTime:0.0001s ]
SHOW COLUMNS FROM `zowo_product` [ RunTime:0.0007s ]
SELECT p.id,r.cid,`pro_title`,`pro_image`,c.parent FROM zowo_product p left JOIN zowo_pro_relationships r on r.object_id=p.id left JOIN zowo_pro_cat c on c.id=r.cid WHERE ( pro_status=1 and r.cid in(47) and r.status=1 ) ORDER BY c.parent,pro_recommended desc,r.cid,r.listorder desc,p.id desc [ RunTime:0.0013s ]
SHOW COLUMNS FROM `zowo_pro_relation_attr` [ RunTime:0.0009s ]
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(296,295,294,291,288,338,293,292,290,289) ) ORDER BY orderby,id desc [ RunTime:0.0007s ]
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.0009s ]
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.0002s ]
SHOW COLUMNS FROM `zowo_pro_keyword` [ RunTime:0.0011s ]
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 ]
SELECT * FROM `zowo_pro_keyword` WHERE ( is_footer=1 ) ORDER BY listorder desc,id [ RunTime:0.0008s ]
