SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424191 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424191 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377025,795767,441032,672269,580545,501083,152269,942076,1002835,778380,171143,145654,81209,291061,81243,1001450,56014,544018,405041,109467,859265,270386,990991,882847,777111,738484,107801,394143,897971,90836,72315,558304,904852,296024,788126,994573,391982,927001,468931,172171,688513,450635,893685,594200,448619,531068,729513,99075,530023,902321,673100,764179,275727,843656,292796,834331,272045,821869,704782,345821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]