SHOW FULL COLUMNS FROM `xzh_navigation` [ RunTime:0.001980s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xzh_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000558s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xzh_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` IN (56,57,59,60) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000460s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xzh_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000545s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xzh_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` IN (61,34,35,37) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `xzh_quick_nav` [ RunTime:0.001363s ]
SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `xzh_quick_nav` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000553s ]
SHOW FULL COLUMNS FROM `xzh_goods_category` [ RunTime:0.001323s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000578s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000552s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (2,8,15,19,37,41) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000771s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 43 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000459s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 44 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000584s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 71 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000347s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 72 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000355s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 77 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000404s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (78,82,105,110) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000600s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 112 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000532s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (113,116) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000388s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 118 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000406s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (119,122,128) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000378s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 137 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000353s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 138 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000391s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 141 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000380s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 142 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000408s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 145 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000357s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 146 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000432s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 149 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000408s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (150,152,154,156,158,160,162,164) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000545s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 172 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000608s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (173,175,180) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000591s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 182 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000594s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (183,185,191,193,198,203,205) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000777s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` = 207 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000731s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `is_enable` = 1 AND `pid` IN (208,918) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000778s ]
SHOW FULL COLUMNS FROM `xzh_slide` [ RunTime:0.001584s ]
SELECT `name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `xzh_slide` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000769s ]
SHOW FULL COLUMNS FROM `xzh_article` [ RunTime:0.001527s ]
SELECT `id`,`title`,`title_color`,`article_category_id` FROM `xzh_article` WHERE `is_enable` = 1 AND `is_home_recommended` = 1 ORDER BY `id` DESC LIMIT 0,9 [ RunTime:0.000776s ]
SHOW FULL COLUMNS FROM `xzh_article_category` [ RunTime:0.000974s ]
SELECT `name`,`id` FROM `xzh_article_category` WHERE `id` IN (25,24) [ RunTime:0.000560s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `pid` = 0 AND `is_home_recommended` = 1 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000658s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `id` IN (2,8,15,19) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000387s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `id` = 44 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000344s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `id` IN (78,82,105,110) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000397s ]
SELECT `id`,`code`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xzh_goods_category` WHERE `id` IN (183,185,193,198) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `xzh_goods` [ RunTime:0.001704s ]
SELECT * FROM `xzh_goods` WHERE `id` IN (311072,311068,311035,311021,310915,310948,310946,310762,310734,310514,310412,310315,309698,309638,309174,308840,40204,40068,311093,311086,310848,310826,310427,310416,41779,41555,41212,40664,310697,310624,310564,313682) AND `is_shelves` = 1 ORDER BY `id` DESC [ RunTime:0.001493s ]
SHOW FULL COLUMNS FROM `xzh_brand` [ RunTime:0.001152s ]
SELECT `name`,`id` FROM `xzh_brand` WHERE `id` IN (12704,4257,1065,3452,3708,3671,277,433,116,760,13816,1090,13810,3472) [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `xzh_region` [ RunTime:0.001124s ]
SELECT `name`,`id` FROM `xzh_region` WHERE `id` = 1 [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `xzh_goods_category_join` [ RunTime:0.000831s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 311086 LIMIT 1 [ RunTime:0.000561s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000587s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 105 LIMIT 1 [ RunTime:0.000599s ]
SHOW FULL COLUMNS FROM `xzh_plugins_jszcy_goods_cat_discount` [ RunTime:0.001062s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 77 LIMIT 1 [ RunTime:0.000624s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 311086 LIMIT 1 [ RunTime:0.000535s ]
SHOW FULL COLUMNS FROM `xzh_plugins` [ RunTime:0.001114s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000596s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000531s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000442s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 311035 LIMIT 1 [ RunTime:0.000629s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000590s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000622s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000389s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 311035 LIMIT 1 [ RunTime:0.000335s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000560s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000455s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000395s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 311021 LIMIT 1 [ RunTime:0.000364s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000346s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000202s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000355s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 311021 LIMIT 1 [ RunTime:0.000341s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000417s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000402s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000298s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310946 LIMIT 1 [ RunTime:0.000347s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000400s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000368s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000454s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310946 LIMIT 1 [ RunTime:0.000334s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000387s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000267s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000257s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310915 LIMIT 1 [ RunTime:0.000320s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000367s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000415s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000381s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310915 LIMIT 1 [ RunTime:0.000325s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000390s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000352s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000281s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310762 LIMIT 1 [ RunTime:0.000314s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000276s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000273s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000266s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310762 LIMIT 1 [ RunTime:0.000311s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000406s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000457s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000491s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310624 LIMIT 1 [ RunTime:0.000300s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000401s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000404s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000427s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310624 LIMIT 1 [ RunTime:0.000350s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000369s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000409s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000314s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310514 LIMIT 1 [ RunTime:0.000323s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 48 LIMIT 1 [ RunTime:0.000395s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000405s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000398s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310514 LIMIT 1 [ RunTime:0.000371s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000385s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000309s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000271s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310412 LIMIT 1 [ RunTime:0.000306s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 49 LIMIT 1 [ RunTime:0.000363s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000363s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000464s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310412 LIMIT 1 [ RunTime:0.000329s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000373s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000440s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000265s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310315 LIMIT 1 [ RunTime:0.000497s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 49 LIMIT 1 [ RunTime:0.000423s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000216s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000436s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310315 LIMIT 1 [ RunTime:0.000349s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000344s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000282s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000497s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 309638 LIMIT 1 [ RunTime:0.000459s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000421s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000371s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000253s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 309638 LIMIT 1 [ RunTime:0.000310s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000421s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000343s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000313s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 309174 LIMIT 1 [ RunTime:0.000330s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000431s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000224s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000230s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 309174 LIMIT 1 [ RunTime:0.000461s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000333s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000318s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000416s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 308840 LIMIT 1 [ RunTime:0.000279s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000452s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000424s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000408s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 308840 LIMIT 1 [ RunTime:0.000349s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000376s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000266s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000300s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 41779 LIMIT 1 [ RunTime:0.000499s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 195 LIMIT 1 [ RunTime:0.000366s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 193 LIMIT 1 [ RunTime:0.000259s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000230s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 41779 LIMIT 1 [ RunTime:0.000336s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000377s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000274s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000398s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 40664 LIMIT 1 [ RunTime:0.000314s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 186 LIMIT 1 [ RunTime:0.000408s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 185 LIMIT 1 [ RunTime:0.000405s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000395s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 40664 LIMIT 1 [ RunTime:0.000375s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000388s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000233s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000305s ]
SHOW FULL COLUMNS FROM `xzh_link` [ RunTime:0.001408s ]
SELECT * FROM `xzh_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `xzh_plugins_limited_time_discount_goods` [ RunTime:0.001163s ]
SELECT `plugins_discount`,`plugins_price`,`goods_id` FROM `xzh_plugins_limited_time_discount_goods` [ RunTime:0.000391s ]
SELECT `g`.`id`,`g`.`title`,`g`.`images`,`g`.`min_price`,`g`.`price`,`g`.`original_price`,`g`.`min_original_price` FROM `xzh_goods` `g` INNER JOIN `xzh_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`id` IN ('311072','310611','309466','42003','310492') GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,1000 [ RunTime:0.000752s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310611 LIMIT 1 [ RunTime:0.000470s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000410s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000407s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000382s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310611 LIMIT 1 [ RunTime:0.000367s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000389s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000261s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000302s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310492 LIMIT 1 [ RunTime:0.000373s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000382s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000423s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000337s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310492 LIMIT 1 [ RunTime:0.000365s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000402s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000263s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000303s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 309466 LIMIT 1 [ RunTime:0.000294s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 199 LIMIT 1 [ RunTime:0.000411s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000418s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000387s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 309466 LIMIT 1 [ RunTime:0.000332s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000414s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000267s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000277s ]
SHOW FULL COLUMNS FROM `xzh_order_detail` [ RunTime:0.001349s ]
SELECT `od`.`user_id`,`od`.`order_id`,`od`.`goods_id`,`od`.`title`,`od`.`images`,`od`.`buy_number`,`o`.`add_time` FROM `xzh_order_detail` `od` INNER JOIN `xzh_order` `o` ON `o`.`id`=`od`.`order_id` ORDER BY `o`.`id` DESC LIMIT 0,5 [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `xzh_user` [ RunTime:0.001463s ]
SELECT `username`,`nickname`,`mobile`,`email`,`avatar`,`province`,`city`,`id` FROM `xzh_user` WHERE `id` IN (8,84728) [ RunTime:0.000365s ]
SELECT `inventory_unit`,`id` FROM `xzh_goods` WHERE `id` IN (325794,331309,329657,329607) [ RunTime:0.000439s ]