SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281481 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281481 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191680,297712,186518,478753,3702,125046,189072,600069,716902,12374,19844,669977,449009,506575,285368,773377,921059,37281,573493,378621,345295,599477,756374,969122,760140,647548,286337,479818,272400,253609,175930,686459,513944,782674,37027,384804,183963,88220,120249,398156,486742,376513,934794,406617,578277,177899,409940,23323,695620,411568,313616,407920,722041,503832,260171,115509,986896,574280,96707,870052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]