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-03-08 18:08:07 HTTP/1.1 GET : https://www.ikeyan.cn/index/goods/goodstypelist/id/86.html
[ DB ] CONNECT:[ UseTime:0.000245s ] mysql:host=localhost;port=3306;dbname=www_ikeyan_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `category` [ RunTime:0.000750s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 0 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000252s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 43 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000408s ]
[ SQL ] SHOW COLUMNS FROM `ad` [ RunTime:0.000643s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 43 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SHOW COLUMNS FROM `goods_img` [ RunTime:0.007699s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 46 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 44 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000183s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 67 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.001356s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 63 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 64 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.007983s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 64 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 69 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 70 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.001796s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 65 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.008999s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 65 LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 76 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.001734s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 34 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.001540s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 34 LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.000130s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 79 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.001950s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 80 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.003728s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 40 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.008550s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 40 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` = 6 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 41 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 84 AND `isindex` = 1 AND `iss` = '1' ORDER BY `sort` DESC [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 0 AND `isindex` = 1 AND `iss` = '0' ORDER BY `sort` DESC [ RunTime:0.001325s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 66 AND `isindex` = 1 AND `iss` = '0' ORDER BY `sort` DESC [ RunTime:0.003704s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `tid` = 66 LIMIT 1 [ RunTime:0.001927s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.000137s ]
[ SQL ] SELECT * FROM `category` WHERE `fid` = 81 AND `isindex` = 1 AND `iss` = '0' ORDER BY `sort` DESC [ RunTime:0.000173s ]
[ SQL ] SHOW COLUMNS FROM `goods_type` [ RunTime:0.000721s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 0 [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 85 [ RunTime:0.000189s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `gid` = 85 LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` = 4 [ RunTime:0.000168s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 105 [ RunTime:0.010348s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 106 [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 107 [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 108 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 109 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 110 [ RunTime:0.003702s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 111 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 112 [ RunTime:0.009198s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 113 [ RunTime:0.000224s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 114 [ RunTime:0.000173s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 115 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 116 [ RunTime:0.004019s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 86 [ RunTime:0.000189s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `gid` = 86 LIMIT 1 [ RunTime:0.001768s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` = 5 [ RunTime:0.001708s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 93 [ RunTime:0.006717s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 94 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 95 [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 96 [ RunTime:0.001606s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 97 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 98 [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 99 [ RunTime:0.003689s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 100 [ RunTime:0.003726s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 101 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 102 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 103 [ RunTime:0.003606s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 104 [ RunTime:0.001749s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `fid` = 117 [ RunTime:0.001564s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `gid` = 117 LIMIT 1 [ RunTime:0.000189s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `adid` IS NULL [ RunTime:0.001391s ]
[ SQL ] SELECT * FROM `ad` WHERE `status` = '1' AND `ucid` = 999 LIMIT 1 [ RunTime:0.009598s ]
[ SQL ] SELECT * FROM `goods_img` WHERE `status` = '1' AND `adid` = 7 [ RunTime:0.000233s ]
[ SQL ] SHOW COLUMNS FROM `video_type` [ RunTime:0.000642s ]
[ SQL ] SELECT * FROM `video_type` WHERE `status` = '1' ORDER BY `sort` DESC [ RunTime:0.000183s ]
[ SQL ] SHOW COLUMNS FROM `webset` [ RunTime:0.000538s ]
[ SQL ] SELECT * FROM `webset` WHERE `id` = 5 LIMIT 1 [ RunTime:0.001705s ]
[ SQL ] SHOW COLUMNS FROM `news` [ RunTime:0.008013s ]
[ SQL ] SELECT * FROM `news` WHERE `create_time` BETWEEN '2021-03-01 00:00:00' AND '2021-03-31 23:59:59' ORDER BY `click` DESC LIMIT 5 [ RunTime:0.000234s ]
[ SQL ] SHOW COLUMNS FROM `collection` [ RunTime:0.000761s ]
[ SQL ] SELECT * FROM `collection` WHERE `uid` IS NULL [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `status` = '1' AND `id` = 86 LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `goods_type` WHERE `status` = '1' AND `fid` = 86 [ RunTime:0.005950s ]
[ SQL ] SELECT * FROM `goods_type` WHERE `status` = '1' AND `fid` = 86 LIMIT 0,12 [ RunTime:0.000275s ]