SHOW FULL COLUMNS FROM `xzh_navigation` [ RunTime:0.002007s ]
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.000550s ]
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.000369s ]
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.000370s ]
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.000440s ]
SHOW FULL COLUMNS FROM `xzh_quick_nav` [ RunTime:0.001192s ]
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.000372s ]
SHOW FULL COLUMNS FROM `xzh_goods_category` [ RunTime:0.001199s ]
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.000415s ]
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.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 `is_enable` = 1 AND `pid` IN (2,8,15,19,37,41) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000483s ]
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.000335s ]
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.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` = 71 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000290s ]
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.000315s ]
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.000312s ]
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.000427s ]
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.000295s ]
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.000280s ]
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.000306s ]
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.000335s ]
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.000283s ]
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.000297s ]
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.000258s ]
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.000275s ]
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.000295s ]
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.000282s ]
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.000322s ]
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.000367s ]
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.000272s ]
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.000356s ]
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.000284s ]
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.000390s ]
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.000292s ]
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.000615s ]
SHOW FULL COLUMNS FROM `xzh_slide` [ RunTime:0.001340s ]
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.000533s ]
SHOW FULL COLUMNS FROM `xzh_article` [ RunTime:0.001076s ]
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.000344s ]
SHOW FULL COLUMNS FROM `xzh_article_category` [ RunTime:0.000801s ]
SELECT `name`,`id` FROM `xzh_article_category` WHERE `id` IN (25,24) [ RunTime:0.000276s ]
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.000362s ]
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.000326s ]
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.000276s ]
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.000337s ]
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.000320s ]
SHOW FULL COLUMNS FROM `xzh_goods` [ RunTime:0.001443s ]
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.000873s ]
SHOW FULL COLUMNS FROM `xzh_brand` [ RunTime:0.000940s ]
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.000334s ]
SHOW FULL COLUMNS FROM `xzh_region` [ RunTime:0.000889s ]
SELECT `name`,`id` FROM `xzh_region` WHERE `id` = 1 [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `xzh_goods_category_join` [ RunTime:0.000978s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 311086 LIMIT 1 [ RunTime:0.000557s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000432s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 105 LIMIT 1 [ RunTime:0.000445s ]
SHOW FULL COLUMNS FROM `xzh_plugins_jszcy_goods_cat_discount` [ RunTime:0.000861s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 77 LIMIT 1 [ RunTime:0.000276s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 311086 LIMIT 1 [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `xzh_plugins` [ RunTime:0.001412s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000330s ]
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.000309s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 311035 LIMIT 1 [ RunTime:0.000374s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000272s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000264s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000279s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 311035 LIMIT 1 [ RunTime:0.000353s ]
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.000253s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000268s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 311021 LIMIT 1 [ RunTime:0.000316s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000261s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000445s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000285s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 311021 LIMIT 1 [ RunTime:0.000296s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000272s ]
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.000252s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310946 LIMIT 1 [ RunTime:0.000305s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000251s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000349s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000316s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310946 LIMIT 1 [ RunTime:0.000288s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000292s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000301s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000278s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310915 LIMIT 1 [ RunTime:0.000353s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000245s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000290s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000271s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310915 LIMIT 1 [ RunTime:0.000339s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000302s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000314s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000354s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310762 LIMIT 1 [ RunTime:0.000311s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000221s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000206s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 1 LIMIT 1 [ RunTime:0.000221s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310762 LIMIT 1 [ RunTime:0.000241s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000250s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000245s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000233s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310624 LIMIT 1 [ RunTime:0.000280s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000213s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000214s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000240s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310624 LIMIT 1 [ RunTime:0.000229s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000286s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000227s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000230s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310514 LIMIT 1 [ RunTime:0.000365s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 48 LIMIT 1 [ RunTime:0.000340s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000561s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000522s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310514 LIMIT 1 [ RunTime:0.000445s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000429s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000224s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000236s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310412 LIMIT 1 [ RunTime:0.000455s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 49 LIMIT 1 [ RunTime:0.000448s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000421s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000509s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310412 LIMIT 1 [ RunTime:0.000215s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000219s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000247s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000214s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310315 LIMIT 1 [ RunTime:0.000272s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 49 LIMIT 1 [ RunTime:0.000238s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000192s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000228s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310315 LIMIT 1 [ RunTime:0.000254s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000236s ]
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.000213s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 309638 LIMIT 1 [ RunTime:0.000274s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000204s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000218s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000246s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 309638 LIMIT 1 [ RunTime:0.000201s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000210s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000210s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000219s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 309174 LIMIT 1 [ RunTime:0.000370s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000493s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000321s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000314s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 309174 LIMIT 1 [ RunTime:0.000256s ]
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.000243s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000264s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 308840 LIMIT 1 [ RunTime:0.000482s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000263s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000249s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 43 LIMIT 1 [ RunTime:0.000245s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 308840 LIMIT 1 [ RunTime:0.000219s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000229s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000248s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000200s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 41779 LIMIT 1 [ RunTime:0.000247s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 195 LIMIT 1 [ RunTime:0.000245s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 193 LIMIT 1 [ RunTime:0.000237s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000240s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 41779 LIMIT 1 [ RunTime:0.000201s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000252s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000437s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000234s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 40664 LIMIT 1 [ RunTime:0.000247s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 186 LIMIT 1 [ RunTime:0.000255s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 185 LIMIT 1 [ RunTime:0.000258s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000234s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 40664 LIMIT 1 [ RunTime:0.000249s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000231s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000201s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `xzh_link` [ RunTime:0.001179s ]
SELECT * FROM `xzh_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `xzh_plugins_limited_time_discount_goods` [ RunTime:0.000938s ]
SELECT `plugins_discount`,`plugins_price`,`goods_id` FROM `xzh_plugins_limited_time_discount_goods` [ RunTime:0.000259s ]
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.000477s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310611 LIMIT 1 [ RunTime:0.000354s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000263s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000242s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000220s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310611 LIMIT 1 [ RunTime:0.000231s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000223s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000232s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000215s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 310492 LIMIT 1 [ RunTime:0.000284s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000221s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000215s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000201s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 310492 LIMIT 1 [ RunTime:0.000243s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000234s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000208s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000208s ]
SELECT `category_id` FROM `xzh_goods_category_join` WHERE `goods_id` = 309466 LIMIT 1 [ RunTime:0.000240s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 199 LIMIT 1 [ RunTime:0.000242s ]
SELECT `pid` FROM `xzh_goods_category` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000214s ]
SELECT `discount` FROM `xzh_plugins_jszcy_goods_cat_discount` WHERE `goods_category_id` = 182 LIMIT 1 [ RunTime:0.000213s ]
SELECT `price`,`min_price`,`max_price` FROM `xzh_goods` WHERE `id` = 309466 LIMIT 1 [ RunTime:0.000251s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000245s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000202s ]
SELECT `data` FROM `xzh_plugins` WHERE `plugins` = 'oss_1jian' LIMIT 1 [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `xzh_order_detail` [ RunTime:0.001418s ]
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.000502s ]
SHOW FULL COLUMNS FROM `xzh_user` [ RunTime:0.001565s ]
SELECT `username`,`nickname`,`mobile`,`email`,`avatar`,`province`,`city`,`id` FROM `xzh_user` WHERE `id` IN (8,84728) [ RunTime:0.000359s ]
SELECT `inventory_unit`,`id` FROM `xzh_goods` WHERE `id` IN (325794,331309,329657,329607) [ RunTime:0.000291s ]