SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548029 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548029 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371541,24382,526529,394389,420046,48903,642144,932229,442074,443769,680600,874906,688611,620620,53107,895045,736593,373430,1006578,960485,882430,658795,1029401,74937,613993,946697,724719,879328,797312,458945,673936,940675,592495,120298,845793,143005,930722,674361,568977,189021,97942,694846,440256,735742,536709,899617,975964,17427,871091,533242,833137,278569,757395,88182,1029103,1030234,1002178,735142,849951,940940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]