基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請(qǐng)求信息 : 2025-05-09 16:15:22 HTTP/1.1 GET : http://www.b2cshop.com.cn/?m2pageno=3
- 運(yùn)行時(shí)間 : 0.042403s [ 吞吐率：23.58req/s ] 內(nèi)存消耗：1,910.82kb 文件加載：149
- 查詢信息 : 0 queries
- 緩存信息 : 0 reads,0 writes
- 會(huì)話信息 : SESSION_ID=2220c7d9f76970cbfe05939cf96552f5
- CONNECT:[ UseTime:0.000385s ] mysql:host=127.0.0.1;port=3306;dbname=zhixue;charset=utf8
- SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000587s ]
- SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000311s ]
- SHOW FULL COLUMNS FROM `zx_article` [ RunTime:0.000472s ]
- SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000454s ]
- SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000396s ]
- 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.000579s ]
- SHOW FULL COLUMNS FROM `zx_banner` [ RunTime:0.000433s ]
- 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.000292s ]
- 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.000566s ]
- 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.000553s ]
- SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000430s ]
- 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.000558s ]
- 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.001332s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 1 [ RunTime:0.000328s ]
- 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.000341s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 92 [ RunTime:0.000293s ]
- 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.000387s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 41 [ RunTime:0.000354s ]
- 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.000346s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 3 [ RunTime:0.000314s ]
- 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.000386s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 149 [ RunTime:0.000291s ]
- 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.000314s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 122 [ RunTime:0.000282s ]
- 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.000383s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 135 [ RunTime:0.000293s ]
- 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.000357s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 15 [ RunTime:0.000285s ]
- 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.000370s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 114 [ RunTime:0.000311s ]
- 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.000340s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 52 [ RunTime:0.000290s ]
- 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.000334s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 64 [ RunTime:0.000302s ]
- 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.000394s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 79 [ RunTime:0.000306s ]
- 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.000352s ]
- SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 102 [ RunTime:0.000289s ]
- 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.000354s ]
- SHOW FULL COLUMNS FROM `zx_space` [ RunTime:0.000397s ]
- 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.000272s ]
推薦課程
