SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508545 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508545 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914008,872047,594005,54434,1000843,172412,680950,821722,630969,161372,843972,1011227,512281,315685,427140,193683,623082,756110,96589,529124,87641,798190,290012,745254,464130,438236,493016,673260,209099,347190,221602,467630,262636,463749,807379,146952,719407,804183,487867,188927,315190,94818,678558,214719,405125,274332,567229,972238,97936,132277,119200,921891,614651,270110,601479,985141,664139,602217,594847,686710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]