SHOW FULL COLUMNS FROM `zx_product_category` [ RunTime:0.002880s ]
SELECT * FROM `zx_product_category` WHERE ( `id` = 32 ) AND `zx_product_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001310s ]
SHOW FULL COLUMNS FROM `zx_product` [ RunTime:0.003657s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count 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`.`state` = '1' AND `b`.`category_id` = '32' AND `b`.`category_id` = '32' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.002850s ]
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`.`state` = '1' AND `b`.`category_id` = '32' AND `b`.`category_id` = '32' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`id` DESC LIMIT 0,6 [ RunTime:0.002579s ]
SHOW FULL COLUMNS FROM `zx_config` [ RunTime:0.003225s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001298s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001132s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001113s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001071s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001056s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'email' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001067s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001166s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001191s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001336s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001191s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001012s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001123s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001168s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'ig' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001146s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001228s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001255s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_img_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001205s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'fax' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001212s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'line' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001297s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg1' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001152s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001136s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'index_banner_content' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001142s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'skype' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001131s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'qq' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001104s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'seo_key_desc' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001267s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'contact' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001110s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'scrolling_text' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001136s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'lineImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001142s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'facebookImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001079s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'igImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001146s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001167s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'whatsappImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001337s ]
SELECT * FROM `zx_product_category` WHERE `delete_time` IS NULL ORDER BY `weight` DESC,`id` DESC [ RunTime:0.001215s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001227s ]
SHOW FULL COLUMNS FROM `zx_system_notice` [ RunTime:0.002654s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001251s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001151s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 3 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001238s ]