您好,欢迎来到
皇家易购-深圳市皇家国际电商服务有限公司
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-02-05 21:52:50 HTTP/1.1 GET : http://huangjiayigou.com/?cid=841&page=0
- 运行时间 : 0.314628s [ 吞吐率:3.18req/s ] 内存消耗:1,796.48kb 文件加载:168
- 查询信息 : 72 queries
- 缓存信息 : 57 reads,9 writes
- 会话信息 : SESSION_ID=0540e5b18f96f76afc32a90219045a8d
- CONNECT:[ UseTime:0.015108s ] mysql:host=127.0.0.1;port=3306;dbname=huangjiayigou1;charset=utf8mb4
- SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.002092s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000270s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` IN (61,54,56,57,58,59,64,62,63,60) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000213s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000224s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` IN (34,35,36,37,55) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000259s ]
- SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.002379s ]
- SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `sxo_quick_nav` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000304s ]
- SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.002144s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000269s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 804 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000235s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (806,825,826,827,828,829,830,831,908,906) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000201s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000190s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (60,836,837,839,904,905) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000192s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 885 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000280s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (888,889,890,891,892,893,902,903) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000187s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 823 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000185s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (833,841,842,843) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000182s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 886 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000193s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (894,895,896,897,898,899) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000190s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 808 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000207s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (844,845,846,847) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000195s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 810 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000193s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (849,848,850,851) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000182s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 809 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000178s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (852,853,854,855,856,857) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000184s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 824 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000223s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (834,859,860,861,862,863,864,865) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000218s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 821 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000257s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (835,866,867,868,869,870,871,872,873,874) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000209s ]
- SHOW FULL COLUMNS FROM `sxo_slide` [ RunTime:0.002301s ]
- SELECT `name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `sxo_slide` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002616s ]
- SHOW FULL COLUMNS FROM `sxo_article` [ RunTime:0.002047s ]
- SELECT `id`,`title`,`title_color`,`article_category_id` FROM `sxo_article` WHERE `is_enable` = 1 AND `is_home_recommended` = 1 ORDER BY `id` DESC LIMIT 0,9 [ RunTime:0.000602s ]
- SHOW FULL COLUMNS FROM `sxo_article_category` [ RunTime:0.001680s ]
- SELECT `name`,`id` FROM `sxo_article_category` WHERE `id` IN (17,25,24,10) [ RunTime:0.000375s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `pid` = 0 AND `is_home_recommended` = 1 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000931s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 804 AND `is_enable` = 1 [ RunTime:0.000253s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (806,825,826,827,828,829,830,831,906,908) AND `is_enable` = 1 [ RunTime:0.000165s ]
- SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.002212s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('804','806','825','826','827','828','829','830','831','906','908') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.002550s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (806,825,826,827,828,829,830,831,908,906) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000964s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 1 AND `is_enable` = 1 [ RunTime:0.000181s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (60,836,837,839,904,905) AND `is_enable` = 1 [ RunTime:0.000170s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('1','60','836','837','839','904','905') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.001283s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (60,836,837,839,904,905) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000695s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 886 AND `is_enable` = 1 [ RunTime:0.000189s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (894,895,896,897,898,899) AND `is_enable` = 1 [ RunTime:0.000178s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('886','894','895','896','897','898','899') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.000905s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (894,895,896,897,898,899) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000611s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 808 AND `is_enable` = 1 [ RunTime:0.000229s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (844,845,846,847) AND `is_enable` = 1 [ RunTime:0.000201s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('808','844','845','846','847') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.001116s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (844,845,846,847) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000586s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 809 AND `is_enable` = 1 [ RunTime:0.000210s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (852,853,854,855,856,857) AND `is_enable` = 1 [ RunTime:0.000188s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('809','852','853','854','855','856','857') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.001296s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (852,853,854,855,856,857) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000611s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 824 AND `is_enable` = 1 [ RunTime:0.000392s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (834,859,860,861,862,863,864,865) AND `is_enable` = 1 [ RunTime:0.000350s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('824','834','859','860','861','862','863','864','865') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.001034s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (834,859,860,861,862,863,864,865) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000593s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 821 AND `is_enable` = 1 [ RunTime:0.000436s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (835,866,867,868,869,870,871,872,873,874) AND `is_enable` = 1 [ RunTime:0.000520s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('821','835','866','867','868','869','870','871','872','873','874') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.001245s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (835,866,867,868,869,870,871,872,873,874) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000473s ]
- SELECT * FROM `sxo_goods` WHERE `id` IN (473,472,471,470,469,468,467,466,465,464,463,462,461,460,459,458,435,434,433,432,480,479,478,477,476,475,474,300,265,264,263,262,261,260,259,258,257,256,255,254,493,492,491,490,489,488,487,486,283,282,281,280,279,278,277,276,275,274,273,272,319,301,287,286,285,284,131,130,129,128,127,126,125,124,103,102,101,53,52,51,533,532,531,530,529,528,527,526,525,422,421,420,419,351,350,349,348,347,346,345,524,523,522,521,520,519,518,517,516,515,514,418,417,416,353,352,339,338,337,336,513,512,511,510,509,508,507,506,505,504,503,502,501,500,499,498,497,496,495,494) AND `is_shelves` = 1 ORDER BY `id` DESC [ RunTime:0.005398s ]
- SHOW FULL COLUMNS FROM `sxo_brand` [ RunTime:0.001773s ]
- SELECT `name`,`id` FROM `sxo_brand` WHERE `id` IN (3,1,2,4) [ RunTime:0.000653s ]
- SHOW FULL COLUMNS FROM `sxo_region` [ RunTime:0.001018s ]
- SELECT `name`,`id` FROM `sxo_region` WHERE `id` IN (23,19,3,17,35,9,15,7,16,12,1,10,14,28,11,2,5,33,13,24,31,8) [ RunTime:0.000745s ]
- SHOW FULL COLUMNS FROM `sxo_link` [ RunTime:0.002023s ]
- SELECT * FROM `sxo_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.002716s ]
0.323216s