SHOW FULL COLUMNS FROM `zx_product` [ RunTime:0.003314s ]
SELECT `a`.`id` FROM `zx_product` `a` INNER JOIN `zx_product_category_related` `b` ON `a`.`id`=`b`.`product_id` INNER JOIN `zx_product_category` `c` ON `b`.`category_id`=`c`.`id` WHERE ( ( `b`.`category_id` = '47' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002210s ]
SHOW FULL COLUMNS FROM `zx_brand` [ RunTime:0.002353s ]
SELECT * FROM `zx_brand` WHERE ( `id` IS NULL ) [ RunTime:0.001862s ]
SHOW FULL COLUMNS FROM `zx_product_attr_key` [ RunTime:0.002359s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 81 ) [ RunTime:0.003239s ]
SHOW FULL COLUMNS FROM `zx_product_category` [ RunTime:0.002327s ]
SELECT * FROM `zx_product_category` WHERE ( `id` = 47 ) AND `zx_product_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001946s ]
SELECT a.*,group_concat(c.id) as category_ids,group_concat(c.name) as category_names FROM `zx_product` `a` INNER JOIN `zx_product_category_related` `b` ON `a`.`id`=`b`.`product_id` INNER JOIN `zx_product_category` `c` ON `b`.`category_id`=`c`.`id` WHERE ( ( `a`.`id` = '91' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` LIMIT 1 [ RunTime:0.002272s ]
SELECT * FROM `zx_brand` WHERE ( `id` = 0 ) [ RunTime:0.003245s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 91 ) [ RunTime:0.001859s ]
SELECT a.*,group_concat(c.name) as category_names FROM `zx_product` `a` INNER JOIN `zx_product_category_related` `b` ON `a`.`id`=`b`.`product_id` INNER JOIN `zx_product_category` `c` ON `b`.`category_id`=`c`.`id` WHERE ( ( `a`.`id` < '91' AND `b`.`category_id` = '47' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.002634s ]
SELECT a.*,group_concat(c.name) as category_names FROM `zx_product` `a` INNER JOIN `zx_product_category_related` `b` ON `a`.`id`=`b`.`product_id` INNER JOIN `zx_product_category` `c` ON `b`.`category_id`=`c`.`id` WHERE ( ( `a`.`id` > '91' AND `b`.`category_id` = '47' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.002523s ]
SELECT a.*,group_concat(c.name) as category_names FROM `zx_product` `a` INNER JOIN `zx_product_category_related` `b` ON `a`.`id`=`b`.`product_id` INNER JOIN `zx_product_category` `c` ON `b`.`category_id`=`c`.`id` WHERE ( ( `a`.`id` <> '91' AND `b`.`category_id` = '47' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`id` ASC LIMIT 100 [ RunTime:0.002957s ]
SHOW FULL COLUMNS FROM `zx_banner` [ RunTime:0.002369s ]
SELECT * FROM `zx_banner` WHERE `state` = 1 AND `type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001933s ]
SHOW FULL COLUMNS FROM `zx_config` [ RunTime:0.002354s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001971s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001933s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002070s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001953s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001949s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'email' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001925s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001973s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002000s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001967s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002013s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001995s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001985s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001958s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'ig' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001954s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001971s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002016s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_img_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001979s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'fax' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001940s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'line' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002007s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg1' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001954s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001954s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'index_banner_content' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002000s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'skype' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001951s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'qq' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001951s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'seo_key_desc' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002089s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'contact' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001999s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'scrolling_text' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002132s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'lineImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001957s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'facebookImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001967s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'igImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001981s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001988s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'whatsappImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001958s ]
SELECT * FROM `zx_product_category` WHERE `delete_time` IS NULL ORDER BY `weight` DESC,`id` DESC [ RunTime:0.001976s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002004s ]
SHOW FULL COLUMNS FROM `zx_system_notice` [ RunTime:0.002481s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.002016s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.002015s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 3 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001987s ]