SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534190 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534190 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72013,13165,96716,452008,445423,11274,414570,621686,512817,668158,87598,200293,349567,616422,12513,110760,583649,442690,64937,564389,985102,979239,1014153,502969,778014,202222,949902,188887,223196,736901,907123,927231,563488,489838,580140,299277,505249,32707,429525,1037477,470975,949135,1022463,87168,759515,56242,306685,913830,885391,848589,541102,163362,390393,114384,389711,322632,789428,265990,867843,169097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]