SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493541 LIMIT 1 [ RunTime:0.002282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493541 [ RunTime:0.003248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627309,578745,418540,676624,124304,39561,727938,516191,114317,611844,744188,623691,708016,242190,340646,814146,162174,282321,289993,404462,134415,500802,671952,218361,1004081,96655,722914,1037191,438450,726620,53106,208045,617537,174909,845931,321000,603333,297168,650848,1006585,87293,798805,927180,197001,234774,657428,409806,831457,563250,369304,316343,852646,121029,693744,83816,441116,673715,551236,80436,686983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]