SHOW FULL COLUMNS FROM `zx_product` [ RunTime:0.002004s ]
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` = '49' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `id` ASC LIMIT 1 [ RunTime:0.004486s ]
SHOW FULL COLUMNS FROM `zx_brand` [ RunTime:0.001558s ]
SELECT * FROM `zx_brand` WHERE ( `id` IS NULL ) [ RunTime:0.001043s ]
SHOW FULL COLUMNS FROM `zx_product_attr_key` [ RunTime:0.001680s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 42 ) [ RunTime:0.001869s ]
SHOW FULL COLUMNS FROM `zx_product_category` [ RunTime:0.001409s ]
SELECT * FROM `zx_product_category` WHERE ( `id` = 49 ) AND `zx_product_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001033s ]
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` = '42' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` LIMIT 1 [ RunTime:0.001417s ]
SELECT * FROM `zx_brand` WHERE ( `id` = 0 ) [ RunTime:0.002086s ]
SELECT * FROM `zx_product_attr_key` WHERE ( `product_id` = 42 ) [ RunTime:0.000963s ]
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` < '42' AND `b`.`category_id` = '49' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.002060s ]
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` > '42' AND `b`.`category_id` = '49' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.004987s ]
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` <> '42' AND `b`.`category_id` = '49' ) ) AND `a`.`delete_time` IS NULL GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`id` ASC LIMIT 100 [ RunTime:0.002604s ]
SHOW FULL COLUMNS FROM `zx_banner` [ RunTime:0.001779s ]
SELECT * FROM `zx_banner` WHERE `state` = 1 AND `type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.002218s ]
SHOW FULL COLUMNS FROM `zx_config` [ RunTime:0.001961s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.003638s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001086s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001028s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000990s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001107s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'email' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001024s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001045s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001051s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_logo2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001080s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001119s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'face_book2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001008s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'address2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001021s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'phone2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000972s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'ig' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001007s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_domain2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001033s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_copyright2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001018s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_img_domain' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001069s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'fax' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000982s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'line' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001030s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg1' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001036s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg2' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001051s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'index_banner_content' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001005s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'skype' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001021s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'qq' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000952s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'seo_key_desc' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001180s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'contact' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000990s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'scrolling_text' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001024s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'lineImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001017s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'facebookImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001122s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'igImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001213s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'wechatImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001059s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'whatsappImg' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001055s ]
SELECT * FROM `zx_product_category` WHERE `delete_time` IS NULL ORDER BY `weight` DESC,`id` DESC [ RunTime:0.001036s ]
SELECT * FROM `zx_config` WHERE ( `type` = 'base' AND `name` = 'site_name' ) AND `zx_config`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001309s ]
SHOW FULL COLUMNS FROM `zx_system_notice` [ RunTime:0.001671s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.003636s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001126s ]
SELECT * FROM `zx_system_notice` WHERE `type` = 3 AND `page_type` = 3 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001054s ]