SHOW FULL COLUMNS FROM `zx_product` [ RunTime:0.002685s ]
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.005225s ]
SHOW FULL COLUMNS FROM `zx_brand` [ RunTime:0.001850s ]
SELECT * FROM `zx_brand` WHERE ( `id` IS NULL ) [ RunTime:0.001379s ]
SHOW FULL COLUMNS FROM `zx_product_attr_key` [ RunTime:0.001950s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 81 ) [ RunTime:0.002334s ]
SHOW FULL COLUMNS FROM `zx_product_category` [ RunTime:0.001778s ]
SELECT * FROM `zx_product_category` WHERE ( `id` = 47 ) AND `zx_product_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001393s ]
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` = '89' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` LIMIT 1 [ RunTime:0.001742s ]
SELECT * FROM `zx_brand` WHERE ( `id` = 0 ) [ RunTime:0.002440s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 89 ) [ RunTime:0.001330s ]
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` < '89' AND `b`.`category_id` = '47' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.002612s ]
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` > '89' AND `b`.`category_id` = '47' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.003520s ]
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` <> '89' 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.002512s ]
SHOW FULL COLUMNS FROM `zx_banner` [ RunTime:0.001848s ]
SELECT * FROM `zx_banner` WHERE `state` = 1 AND `type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.002314s ]
SHOW FULL COLUMNS FROM `zx_config` [ RunTime:0.002050s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004086s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001455s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001426s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001387s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001416s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'email' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001373s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001375s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001419s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001423s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001481s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001420s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001432s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001469s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'ig' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001438s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001470s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001407s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_img_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001407s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'fax' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001382s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'line' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001405s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg1' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001417s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001494s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'index_banner_content' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001389s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'skype' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001441s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'qq' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001394s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'seo_key_desc' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001564s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'contact' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001430s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'scrolling_text' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001418s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'lineImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001419s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'facebookImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001390s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'igImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001433s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001428s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'whatsappImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001469s ]
SELECT * FROM `zx_product_category` WHERE `delete_time` IS NULL ORDER BY `weight` DESC,`id` DESC [ RunTime:0.001444s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001474s ]
SHOW FULL COLUMNS FROM `zx_system_notice` [ RunTime:0.001978s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.004538s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001574s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 3 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001493s ]