SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398568 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398568 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581180,994268,183837,473539,538970,150684,482355,375180,874241,258541,509457,129476,449763,927918,339261,456051,104305,433188,521374,473099,385393,995417,981466,867723,108517,1011631,581954,75515,994960,431050,711270,803153,902624,531874,800617,642765,871990,947329,657971,468800,68845,675801,118672,45463,692747,96080,422474,153041,813444,510244,292949,866947,563137,151458,719996,70962,785368,460867,709219,469267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]