Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia iste laborum ad impedit pariatur esse optio tempora sint ullam autem deleniti nam in quos qui nemo ipsum numquam, reiciendis maiores quidem aperiam, rerum vel recusandae
size
color
Share this product
基本文件流程错误SQL调试
请求信息 : 2021-01-27 20:59:45 HTTP/1.1 GET : https://ikeyan.cn/index/goods/goodstypelist/id/85.html
[ DB ] CONNECT:[ UseTime:0.005061s ] mysql:host=localhost;port=3306;dbname=www_ikeyan_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `category` [ RunTime:0.000724s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 0 AND `isindex` = 1 [ RunTime:0.000243s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 34 AND `isindex` = 1 [ RunTime:0.000232s ]
[ SQL ] SHOW COLUMNS FROM `ad` [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 34 LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SHOW COLUMNS FROM `goods_img` [ RunTime:0.001170s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 47 AND `isindex` = 1 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 50 AND `isindex` = 1 [ RunTime:0.003467s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 40 AND `isindex` = 1 [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 40 LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` = 6 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 41 AND `isindex` = 1 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 43 AND `isindex` = 1 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 43 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.003659s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 44 AND `isindex` = 1 [ RunTime:0.000194s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 46 AND `isindex` = 1 [ RunTime:0.000195s ]
[ SQL ] SHOW COLUMNS FROM `goods_type` [ RunTime:0.000647s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 0 [ RunTime:0.000201s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 85 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `gid` = 85 LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` = 4 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 105 [ RunTime:0.003219s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 106 [ RunTime:0.000165s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 107 [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 108 [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 109 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 110 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 111 [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 112 [ RunTime:0.002773s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 113 [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 114 [ RunTime:0.000168s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 115 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 116 [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 86 [ RunTime:0.000186s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `gid` = 86 LIMIT 1 [ RunTime:0.003055s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` = 5 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 93 [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 94 [ RunTime:0.000175s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 95 [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 96 [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 97 [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 98 [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 99 [ RunTime:0.001916s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 100 [ RunTime:0.000213s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 101 [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 102 [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 103 [ RunTime:0.001417s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 104 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `ucid` = 999 LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `status` = '1' AND `adid` = 7 [ RunTime:0.000180s ]
[ SQL ] SHOW COLUMNS FROM `video_type` [ RunTime:0.000653s ]
[ SQL ] SELECT * FROM `video_type` WHERE `status` = '1' ORDER BY `sort` DESC [ RunTime:0.000170s ]
[ SQL ] SHOW COLUMNS FROM `webset` [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `webset` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SHOW COLUMNS FROM `news` [ RunTime:0.000534s ]
[ SQL ] SELECT * FROM `news` WHERE `create_time` BETWEEN '2021-01-01 00:00:00' AND '2021-01-31 23:59:59' ORDER BY `click` DESC LIMIT 5 [ RunTime:0.000195s ]
[ SQL ] SHOW COLUMNS FROM `collection` [ RunTime:0.000503s ]
[ SQL ] SELECT * FROM `collection` WHERE `uid` IS NULL [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `status` = '1' AND `id` = 85 LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `goods_type` WHERE `status` = '1' AND `fid` = 85 [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `status` = '1' AND `fid` = 85 LIMIT 0,12 [ RunTime:0.000278s ]