SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291139 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291139 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600262,481840,297294,456249,400122,154979,504575,504634,627006,764537,517725,572782,744193,463444,341995,280168,652590,811801,1022043,900923,341837,63409,963744,821766,222541,110051,494006,783025,318628,181684,904673,128248,514655,115946,673970,593821,658512,664835,940340,995985,675921,619518,695421,462010,775840,709806,277361,216729,920237,635902,536970,124015,696590,841193,972100,838296,940918,943883,435325,427625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]