基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請求信息 : 2025-05-08 00:59:51 HTTP/1.1 GET : http://m.b2cshop.com.cn/
- 運(yùn)行時(shí)間 : 0.042501s [ 吞吐率：23.53req/s ] 內(nèi)存消耗：1,910.46kb 文件加載：149
- 查詢信息 : 0 queries
- 緩存信息 : 0 reads,0 writes
- 會(huì)話信息 : SESSION_ID=96409ed4ecc2054cc858aaec514ecb1d
- CONNECT:[ UseTime:0.000398s ] mysql:host=127.0.0.1;port=3306;dbname=zhixue;charset=utf8
- SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000562s ]
- SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000311s ]
- SHOW FULL COLUMNS FROM `zx_article` [ RunTime:0.000452s ]
- SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000447s ]
- SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000391s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 ORDER BY CASE WHEN sort = 0 THEN 1 ELSE 0 END,`sort` ASC,`create_time` DESC [ RunTime:0.000598s ]
- SHOW FULL COLUMNS FROM `zx_banner` [ RunTime:0.000486s ]
- SELECT * FROM `zx_banner` WHERE `status` = 1 ORDER BY CASE WHEN sort = 0 THEN 1 ELSE 0 END,`sort` ASC,`create_time` DESC [ RunTime:0.000317s ]
- SELECT * FROM `zx_school` `a` WHERE `a`.`status` = '1' ORDER BY CASE WHEN a.sort = 0 THEN 1 ELSE 0 END,`a`.`sort` ASC,`a`.`create_time` DESC LIMIT 12 [ RunTime:0.000551s ]
- SELECT * FROM `zx_article` `a` WHERE `a`.`status` = '1' AND `a`.`rec_index` > '0' ORDER BY CASE WHEN a.sort = 0 THEN 1 ELSE 0 END,`a`.`sort` ASC,`a`.`create_time` DESC LIMIT 10 [ RunTime:0.000595s ]
- SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000461s ]
- SELECT `a`.*,b.id as school_id,b.title as school_title FROM `zx_course` `a` LEFT JOIN `zx_school` `b` ON `a`.`school_id`=`b`.`id` WHERE `a`.`status` = '1' AND `b`.`status` = '1' ORDER BY CASE WHEN a.sort = 0 THEN 1 ELSE 0 END,`a`.`sort` ASC,`a`.`create_time` DESC LIMIT 11 [ RunTime:0.000567s ]
- SELECT `a`.*,b.id as school_id,b.title as school_title FROM `zx_article` `a` LEFT JOIN `zx_school` `b` ON `a`.`school_id`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`rec_index` > '0' ORDER BY `a`.`create_time` DESC LIMIT 36 [ RunTime:0.001308s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 1 [ RunTime:0.000381s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(4, cate_id) OR FIND_IN_SET(5, cate_id) OR FIND_IN_SET(6, cate_id) OR FIND_IN_SET(7, cate_id) OR FIND_IN_SET(8, cate_id) OR FIND_IN_SET(13, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000359s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 92 [ RunTime:0.000291s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(93, cate_id) OR FIND_IN_SET(94, cate_id) OR FIND_IN_SET(95, cate_id) OR FIND_IN_SET(96, cate_id) OR FIND_IN_SET(97, cate_id) OR FIND_IN_SET(98, cate_id) OR FIND_IN_SET(99, cate_id) OR FIND_IN_SET(100, cate_id) OR FIND_IN_SET(101, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000404s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 41 [ RunTime:0.000298s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(42, cate_id) OR FIND_IN_SET(43, cate_id) OR FIND_IN_SET(44, cate_id) OR FIND_IN_SET(45, cate_id) OR FIND_IN_SET(46, cate_id) OR FIND_IN_SET(47, cate_id) OR FIND_IN_SET(48, cate_id) OR FIND_IN_SET(49, cate_id) OR FIND_IN_SET(50, cate_id) OR FIND_IN_SET(51, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000344s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 3 [ RunTime:0.000288s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(29, cate_id) OR FIND_IN_SET(30, cate_id) OR FIND_IN_SET(31, cate_id) OR FIND_IN_SET(32, cate_id) OR FIND_IN_SET(33, cate_id) OR FIND_IN_SET(34, cate_id) OR FIND_IN_SET(35, cate_id) OR FIND_IN_SET(36, cate_id) OR FIND_IN_SET(37, cate_id) OR FIND_IN_SET(38, cate_id) OR FIND_IN_SET(39, cate_id) OR FIND_IN_SET(40, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000361s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 149 [ RunTime:0.000298s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(150, cate_id) OR FIND_IN_SET(151, cate_id) OR FIND_IN_SET(152, cate_id) OR FIND_IN_SET(153, cate_id) OR FIND_IN_SET(154, cate_id) OR FIND_IN_SET(155, cate_id) OR FIND_IN_SET(156, cate_id) OR FIND_IN_SET(157, cate_id) OR FIND_IN_SET(158, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000365s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 122 [ RunTime:0.000299s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(123, cate_id) OR FIND_IN_SET(124, cate_id) OR FIND_IN_SET(125, cate_id) OR FIND_IN_SET(126, cate_id) OR FIND_IN_SET(127, cate_id) OR FIND_IN_SET(128, cate_id) OR FIND_IN_SET(129, cate_id) OR FIND_IN_SET(130, cate_id) OR FIND_IN_SET(131, cate_id) OR FIND_IN_SET(132, cate_id) OR FIND_IN_SET(133, cate_id) OR FIND_IN_SET(134, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000355s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 135 [ RunTime:0.000306s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(136, cate_id) OR FIND_IN_SET(137, cate_id) OR FIND_IN_SET(138, cate_id) OR FIND_IN_SET(139, cate_id) OR FIND_IN_SET(140, cate_id) OR FIND_IN_SET(141, cate_id) OR FIND_IN_SET(142, cate_id) OR FIND_IN_SET(143, cate_id) OR FIND_IN_SET(144, cate_id) OR FIND_IN_SET(145, cate_id) OR FIND_IN_SET(146, cate_id) OR FIND_IN_SET(147, cate_id) OR FIND_IN_SET(148, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000324s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 15 [ RunTime:0.000300s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(17, cate_id) OR FIND_IN_SET(18, cate_id) OR FIND_IN_SET(19, cate_id) OR FIND_IN_SET(20, cate_id) OR FIND_IN_SET(21, cate_id) OR FIND_IN_SET(22, cate_id) OR FIND_IN_SET(23, cate_id) OR FIND_IN_SET(24, cate_id) OR FIND_IN_SET(25, cate_id) OR FIND_IN_SET(26, cate_id) OR FIND_IN_SET(27, cate_id) OR FIND_IN_SET(28, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000380s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 114 [ RunTime:0.000294s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(115, cate_id) OR FIND_IN_SET(116, cate_id) OR FIND_IN_SET(117, cate_id) OR FIND_IN_SET(118, cate_id) OR FIND_IN_SET(119, cate_id) OR FIND_IN_SET(120, cate_id) OR FIND_IN_SET(121, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000350s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 52 [ RunTime:0.000325s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(53, cate_id) OR FIND_IN_SET(54, cate_id) OR FIND_IN_SET(55, cate_id) OR FIND_IN_SET(56, cate_id) OR FIND_IN_SET(57, cate_id) OR FIND_IN_SET(58, cate_id) OR FIND_IN_SET(59, cate_id) OR FIND_IN_SET(60, cate_id) OR FIND_IN_SET(61, cate_id) OR FIND_IN_SET(62, cate_id) OR FIND_IN_SET(63, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000359s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 64 [ RunTime:0.000295s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(65, cate_id) OR FIND_IN_SET(66, cate_id) OR FIND_IN_SET(67, cate_id) OR FIND_IN_SET(68, cate_id) OR FIND_IN_SET(69, cate_id) OR FIND_IN_SET(70, cate_id) OR FIND_IN_SET(71, cate_id) OR FIND_IN_SET(72, cate_id) OR FIND_IN_SET(73, cate_id) OR FIND_IN_SET(74, cate_id) OR FIND_IN_SET(75, cate_id) OR FIND_IN_SET(76, cate_id) OR FIND_IN_SET(77, cate_id) OR FIND_IN_SET(78, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000403s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 79 [ RunTime:0.000315s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(80, cate_id) OR FIND_IN_SET(81, cate_id) OR FIND_IN_SET(83, cate_id) OR FIND_IN_SET(84, cate_id) OR FIND_IN_SET(85, cate_id) OR FIND_IN_SET(86, cate_id) OR FIND_IN_SET(87, cate_id) OR FIND_IN_SET(88, cate_id) OR FIND_IN_SET(89, cate_id) OR FIND_IN_SET(90, cate_id) OR FIND_IN_SET(91, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000345s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 102 [ RunTime:0.000304s ]
- SELECT * FROM zx_school WHERE status = 1 and (FIND_IN_SET(103, cate_id) OR FIND_IN_SET(104, cate_id) OR FIND_IN_SET(105, cate_id) OR FIND_IN_SET(106, cate_id) OR FIND_IN_SET(107, cate_id) OR FIND_IN_SET(108, cate_id) OR FIND_IN_SET(109, cate_id) OR FIND_IN_SET(110, cate_id) OR FIND_IN_SET(111, cate_id) OR FIND_IN_SET(112, cate_id) OR FIND_IN_SET(113, cate_id)) order by CASE WHEN sort = 0 THEN 1 ELSE 0 END, sort asc,create_time desc limit 6 [ RunTime:0.000320s ]
- SHOW FULL COLUMNS FROM `zx_space` [ RunTime:0.000434s ]
- SELECT * FROM `zx_space` WHERE `status` = 1 ORDER BY CASE WHEN sort = 0 THEN 1 ELSE 0 END,`sort` ASC,`create_time` DESC [ RunTime:0.000278s ]
推薦課程
