您好，欢迎来到
佳诚办公用品在线采购管理平台
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-04-17 06:57:05 HTTP/1.1 GET : http://www.jc598.cn/
- 运行时间 : 0.076482s [ 吞吐率：13.07req/s ] 内存消耗：7,809.05kb 文件加载：224
- 查询信息 : 53 queries
- 缓存信息 : 51 reads,9 writes
- 会话信息 : SESSION_ID=2acb3ac0bdbb62c60aa97bed5060b99f
- CONNECT:[ UseTime:0.000320s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8mb4
- SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.000524s ]
- 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.000305s ]
- 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 (59,57,58) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000197s ]
- 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.000184s ]
- 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.000254s ]
- SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.000327s ]
- 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.000186s ]
- SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.000380s ]
- 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.000206s ]
- 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.000158s ]
- 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,62,61,932,916) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000522s ]
- 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` = 910 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` IN (911,985,986,996,1098) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000408s ]
- 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` = 915 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000166s ]
- 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 (944,945,1001) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000170s ]
- 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` = 933 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000149s ]
- 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 (1074,1125,1010,1011) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000244s ]
- 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` = 969 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000147s ]
- 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 (1091,1092,1093) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000133s ]
- 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` = 975 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000150s ]
- 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 (1004,1005,1006,1007) 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` = 1110 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000147s ]
- 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 (1111,1112,1113,1116) 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` = 1141 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000141s ]
- 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 (1144,1145) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000131s ]
- 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` = 898 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000136s ]
- 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` = 1142 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000151s ]
- SHOW FULL COLUMNS FROM `sxo_slide` [ RunTime:0.000330s ]
- 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.000157s ]
- SHOW FULL COLUMNS FROM `sxo_article` [ RunTime:0.000335s ]
- 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.000132s ]
- SHOW FULL COLUMNS FROM `sxo_article_category` [ RunTime:0.000307s ]
- SELECT `name`,`id` FROM `sxo_article_category` WHERE `id` = 24 [ RunTime:0.000109s ]
- 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.000188s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 1 AND `is_enable` = 1 [ RunTime:0.000113s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (60,61,62,916,932) AND `is_enable` = 1 [ RunTime:0.000288s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (85,86,114,117,893,897,904,917,918,924,925,934,935,936,938,939,950,952,953,958,959,967,968,1020,1026,1027,1028,1029,1030,1031,1032,1034,1035,1036,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1081,1082,1102,1105,1106,1109,1118,1123,1135,1136,1148,1149) AND `is_enable` = 1 [ RunTime:0.000310s ]
- SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.000435s ]
- 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','61','62','916','932','85','86','114','117','893','897','904','917','918','924','925','934','935','936','938','939','950','952','953','958','959','967','968','1020','1026','1027','1028','1029','1030','1031','1032','1034','1035','1036','1040','1041','1042','1043','1044','1045','1046','1047','1048','1049','1050','1051','1052','1053','1054','1081','1082','1102','1105','1106','1109','1118','1123','1135','1136','1148','1149') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000575s ]
- 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,62,61,932,916) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000173s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 910 AND `is_enable` = 1 [ RunTime:0.000125s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (911,985,986,996,1098) AND `is_enable` = 1 [ RunTime:0.000274s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (940,941,942,943,987,988,990,991,992,994,995,998,999,1000,1057,1058,1083,1084,1088,1089,1096,1099,1100,1107,1108,1119,1120,1121,1122,1130,1131,1132,1134,1146,1154,1156,1162) AND `is_enable` = 1 [ RunTime:0.000292s ]
- 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 ('910','911','985','986','996','1098','940','941','942','943','987','988','990','991','992','994','995','998','999','1000','1057','1058','1083','1084','1088','1089','1096','1099','1100','1107','1108','1119','1120','1121','1122','1130','1131','1132','1134','1146','1154','1156','1162') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000437s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 933 AND `is_enable` = 1 [ RunTime:0.000118s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (1010,1011,1074,1125) AND `is_enable` = 1 [ RunTime:0.000147s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (1064,1065,1066,1067,1068,1069,1155,1071,1072,1073,1076,1077,1078,1126,1127,1128,1129,1133,1147) AND `is_enable` = 1 [ RunTime:0.000254s ]
- 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 ('933','1010','1011','1074','1125','1064','1065','1066','1067','1068','1069','1155','1071','1072','1073','1076','1077','1078','1126','1127','1128','1129','1133','1147') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000246s ]
- SELECT * FROM `sxo_goods` WHERE `id` IN (273,269,268,267,261,260,259,258,274,272,271,270,264,263,262,256,237,236,235,234,229,228,227,226) AND `is_shelves` = 1 ORDER BY `id` DESC [ RunTime:0.000478s ]
- SHOW FULL COLUMNS FROM `sxo_brand` [ RunTime:0.000391s ]
- SELECT `name`,`id` FROM `sxo_brand` WHERE `id` IN (1,8,43,44) [ RunTime:0.000129s ]
- SHOW FULL COLUMNS FROM `sxo_link` [ RunTime:0.000304s ]
- SELECT * FROM `sxo_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000154s ]
0.077311s
