SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291471 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291471 [ RunTime:0.003825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772241,792389,916294,344849,800730,112682,67423,416149,874046,919144,1044071,431566,960158,783125,745252,846296,957781,98327,432712,852369,558192,24064,853813,684448,673667,113886,702380,770504,839939,285091,408620,1046477,169825,60981,736131,684035,168040,5956,264199,226388,901384,661541,360557,450795,1048176,1010331,183073,208337,151501,638711,1032387,1039424,460278,977573,835249,760589,971435,178051,937672,960458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]