SHOW FULL COLUMNS FROM `zx_product` [ RunTime:0.002059s ]
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` = '39' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001248s ]
SHOW FULL COLUMNS FROM `zx_brand` [ RunTime:0.002346s ]
SELECT * FROM `zx_brand` WHERE ( `id` IS NULL ) [ RunTime:0.000935s ]
SHOW FULL COLUMNS FROM `zx_product_attr_key` [ RunTime:0.002338s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 243 ) [ RunTime:0.002061s ]
SHOW FULL COLUMNS FROM `zx_product_category` [ RunTime:0.001483s ]
SELECT * FROM `zx_product_category` WHERE ( `id` = 39 ) AND `zx_product_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001016s ]
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` = '243' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` LIMIT 1 [ RunTime:0.001366s ]
SELECT * FROM `zx_brand` WHERE ( `id` = 0 ) [ RunTime:0.002110s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 243 ) [ RunTime:0.000915s ]
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` < '243' AND `b`.`category_id` = '39' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` DESC LIMIT 1 [ RunTime:0.001668s ]
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` > '243' AND `b`.`category_id` = '39' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.001647s ]
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` <> '243' AND `b`.`category_id` = '39' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`id` ASC LIMIT 50 [ RunTime:0.002160s ]
SHOW FULL COLUMNS FROM `zx_banner` [ RunTime:0.001513s ]
SELECT * FROM `zx_banner` WHERE `state` = 1 AND `type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001047s ]
SHOW FULL COLUMNS FROM `zx_config` [ RunTime:0.001589s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001122s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001059s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001001s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001017s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001097s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'email' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001046s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001032s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001048s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001076s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001012s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001003s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001040s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001000s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'ig' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000978s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000991s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001034s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_img_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001004s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'fax' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000992s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'line' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000968s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg1' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001039s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001047s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'index_banner_content' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001053s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'skype' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001006s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'qq' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000972s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'seo_key_desc' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001317s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'contact' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001308s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'scrolling_text' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001112s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'lineImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001150s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'facebookImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001142s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'igImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001046s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001053s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'whatsappImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001019s ]
SELECT * FROM `zx_product_category` WHERE `delete_time` IS NULL ORDER BY `weight` DESC,`id` DESC [ RunTime:0.001092s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001085s ]
SHOW FULL COLUMNS FROM `zx_system_notice` [ RunTime:0.001631s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001066s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001019s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 3 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001052s ]
园林小品
