您好,欢迎来到
皇家易购-深圳市皇家国际电商服务有限公司
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-02-05 19:46:45 HTTP/1.1 GET : http://huangjiayigou.com/?cid=902&page=0
- 运行时间 : 0.216271s [ 吞吐率:4.62req/s ] 内存消耗:1,867.17kb 文件加载:168
- 查询信息 : 72 queries
- 缓存信息 : 57 reads,9 writes
- 会话信息 : SESSION_ID=1c89585111178673c0338a70555f9b64
- CONNECT:[ UseTime:0.006883s ] mysql:host=127.0.0.1;port=3306;dbname=huangjiayigou1;charset=utf8mb4
- SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.001289s ]
- 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.000205s ]
- 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.000196s ]
- 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.000188s ]
- 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.000217s ]
- SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.000921s ]
- 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.000217s ]
- SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.001019s ]
- 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.000213s ]
- 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.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` IN (806,825,826,827,828,829,830,831,908,906) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000194s ]
- 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.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` = 885 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000188s ]
- 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.000277s ]
- 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.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` IN (833,841,842,843) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000199s ]
- 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.000194s ]
- 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.000305s ]
- 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.000177s ]
- 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.000286s ]
- 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.000176s ]
- 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.000189s ]
- 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.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` IN (852,853,854,855,856,857) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000199s ]
- 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.000198s ]
- 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.000191s ]
- 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.000204s ]
- 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.000200s ]
- SHOW FULL COLUMNS FROM `sxo_slide` [ RunTime:0.001056s ]
- 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.000215s ]
- SHOW FULL COLUMNS FROM `sxo_article` [ RunTime:0.000931s ]
- 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.000221s ]
- SHOW FULL COLUMNS FROM `sxo_article_category` [ RunTime:0.000729s ]
- SELECT `name`,`id` FROM `sxo_article_category` WHERE `id` IN (17,25,24,10) [ RunTime:0.000214s ]
- 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.000228s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 804 AND `is_enable` = 1 [ RunTime:0.000188s ]
- 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.000240s ]
- SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.000977s ]
- 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.000215s ]
- 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.000181s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 1 AND `is_enable` = 1 [ RunTime:0.000158s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (60,836,837,839,904,905) AND `is_enable` = 1 [ RunTime:0.000160s ]
- 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.000155s ]
- 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.000162s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 886 AND `is_enable` = 1 [ RunTime:0.000159s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (894,895,896,897,898,899) AND `is_enable` = 1 [ RunTime:0.000150s ]
- 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.000153s ]
- 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.000150s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 808 AND `is_enable` = 1 [ RunTime:0.000154s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (844,845,846,847) AND `is_enable` = 1 [ RunTime:0.000158s ]
- 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.000221s ]
- 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.000209s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 809 AND `is_enable` = 1 [ RunTime:0.000173s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (852,853,854,855,856,857) AND `is_enable` = 1 [ RunTime:0.000150s ]
- 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.000165s ]
- 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.000161s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 824 AND `is_enable` = 1 [ RunTime:0.000155s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (834,859,860,861,862,863,864,865) AND `is_enable` = 1 [ RunTime:0.000148s ]
- 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.000163s ]
- 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.000175s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 821 AND `is_enable` = 1 [ RunTime:0.000157s ]
- 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.000167s ]
- 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.000172s ]
- 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.000173s ]
- 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.000947s ]
- SHOW FULL COLUMNS FROM `sxo_brand` [ RunTime:0.000998s ]
- SELECT `name`,`id` FROM `sxo_brand` WHERE `id` IN (3,1,2,4) [ RunTime:0.000165s ]
- SHOW FULL COLUMNS FROM `sxo_region` [ RunTime:0.000543s ]
- 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.000214s ]
- SHOW FULL COLUMNS FROM `sxo_link` [ RunTime:0.001037s ]
- SELECT * FROM `sxo_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000220s ]
0.223977s