SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5072 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5072 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502364,391979,991160,1026360,82737,203566,109957,183076,835962,991769,213668,516750,46435,386317,538662,791759,837413,801035,170307,291142,208661,662646,840387,1026672,470214,841914,753693,1004533,336691,642652,315947,86877,257035,778554,791375,422295,576029,754749,430326,803299,801381,889368,292486,262461,936311,942992,372196,1014353,475499,985865,528141,154423,543128,757981,610117,690693,861707,106340,616200,585386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]