基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-05-25 03:50:08 HTTP/1.1 GET : http://760.forgood.net/home/product/lists.html?page=3&pid=107&pin=137
- 运行时间 : 0.812500s [ 吞吐率：1.23req/s ] 内存消耗：10,392.57kb 文件加载：113
- 查询信息 : 67 queries 0 writes
- 缓存信息 : 0 reads,0 writes
- [8]未定义变量: nid
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: userview
- [8]未定义变量: protypes
- [8]未定义变量: protypes
- [8]未定义变量: protypes
- [8]未定义变量: userview
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `yb_website` [ RunTime:0.000000s ]
- [ SQL ] SELECT `id`,`name`,`title`,`keywords`,`description`,`copy`,`phone`,`contact`,`contel`,`conqq`,`email`,`address`,`icp`,`www`,`ishtml`,`isclose`,`created` FROM `yb_website` LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `yb_nav` [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_nav` WHERE ( pid=0 and isdel=0 and hide=1 ) ORDER BY `id` ASC,`sort` ASC LIMIT 0,4 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `yb_news` [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_news` WHERE ( pid=38 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_news` WHERE ( pid=40 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_news` WHERE ( pid=41 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_news` WHERE ( pid=44 and ispass=1 and isdel=0 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000000s ]
- [ SQL ] SHOW COLUMNS FROM `yb_slider` [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_slider` WHERE ( type=6 ) ORDER BY `sort` DESC,`id` DESC LIMIT 0,2 [ RunTime:0.000000s ]
- [ SQL ] SHOW COLUMNS FROM `yb_type` [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_type` WHERE ( hide=1 and pid=19 ) ORDER BY `sort` DESC,`id` DESC LIMIT 0,2 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `yb_goodsnav` [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=0 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=103 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=107 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=108 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=109 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=110 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=111 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=112 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=123 and isdel=0 and hide=1 and type=1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ SQL ] SHOW COLUMNS FROM `yb_cart` [ RunTime:0.000000s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `yb_cart` WHERE ( cus_id=0 and isbuy=0 and isdel=0 ) LIMIT 1 [ RunTime:0.000000s ]
- [ SQL ] SHOW COLUMNS FROM `yb_users` [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_users` WHERE ( id=0 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( id=137 and isdel=0 and hide=1 and type=2 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `yb_goods` [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_goods` `a` WHERE ( a.isdel=0 and a.ispass=1 and a.issale=1 and a.pinpid=137 ) GROUP BY `goodsid` [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( id=104 and isdel=0 and hide=1 and type=1 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( id=113 and isdel=0 and hide=1 and type=1 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( id=114 and isdel=0 and hide=1 and type=1 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( isdel=0 and hide=1 and type=1 and pid=0 and id=107 ) LIMIT 1 [ RunTime:0.000000s ]
- [ SQL ] SELECT
ID.LEVEL,
DATA.id
FROM
(
SELECT
@ids AS _ids,
( SELECT @ids := GROUP_CONCAT( id ) FROM yb_goodsnav WHERE FIND_IN_SET( pid, @ids ) ) AS cids,
@l := @l + 1 AS LEVEL
FROM
yb_goodsnav,
( SELECT @ids := 107, @l := 0 ) b
WHERE
@ids IS NOT NULL
) ID,
yb_goodsnav DATA
WHERE
FIND_IN_SET( DATA.id, ID._ids )
ORDER BY
LEVEL,
id [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goods` `a` WHERE ( a.isdel=0 and a.ispass=1 and a.issale=1 and a.pinpid=137 and a.goodsid in(107,107,113,114,129,130,131,133,135) ) GROUP BY `goodsid` [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( id=113 and isdel=0 and hide=1 and type=1 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( id=114 and isdel=0 and hide=1 and type=1 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goods` `a` WHERE ( a.isdel=0 and a.ispass=1 and a.issale=1 and a.pinpid=137 and a.goodsid in(107,107,113,114,129,130,131,133,135) ) GROUP BY `pinpid` [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( id=137 and isdel=0 and hide=1 and type=2 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000000s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `yb_goods` `a` WHERE ( a.isdel=0 and a.ispass=1 and a.issale=1 and a.pinpid=137 and a.goodsid in(107,107,113,114,129,130,131,133,135) ) LIMIT 1 [ RunTime:0.000000s ]
- [ SQL ] SELECT * FROM `yb_goods` `a` WHERE ( a.isdel=0 and a.ispass=1 and a.issale=1 and a.pinpid=137 and a.goodsid in(107,107,113,114,129,130,131,133,135) ) ORDER BY `a`.`issy` DESC,`a`.`isjp` DESC,`a`.`isnew` DESC,`a`.`isrm` DESC,`a`.`sort` DESC,`a`.`id` DESC LIMIT 64,32 [ RunTime:0.015625s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT * FROM `yb_goodsnav` WHERE ( pid=0 and type=1 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `id` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
- [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=zxzkj;charset=utf8
- [ SQL ] SELECT `title` FROM `yb_goodsnav` WHERE ( id=137 ) LIMIT 1 [ RunTime:0.000000s ]
0.812500s
