SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010880 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010880 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431953,852211,484087,748436,228066,382729,607576,228316,1012175,783095,1010459,336883,619830,28303,624549,350938,750890,862224,867754,769660,90851,422746,319457,140012,143312,743471,85240,504384,1027157,124014,278115,596326,282108,602256,629493,707068,310994,264274,603575,98372,823206,325029,750676,174128,29417,636006,618565,68176,549600,257938,424361,122470,369480,346492,130866,613215,919294,582071,240265,391169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001400s ]