SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412278 LIMIT 1 [ RunTime:0.001604s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412278 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40765,53311,46173,207596,296281,266954,485547,797183,114722,239404,561216,57106,941569,783854,922679,541763,317100,1040097,326307,1009687,738248,591540,362514,931721,339459,106064,547219,279579,549418,344379,998952,419762,193938,243334,487639,486538,142003,563251,818297,358702,54582,720305,325889,329995,733577,49428,26141,800109,724183,841348,297510,545388,116431,479996,739628,825059,844939,303870,685723,35873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]