SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504178 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504178 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292505,445910,953772,681729,714653,123410,656753,93249,810529,528153,193855,50054,929830,60307,427546,503721,426998,222315,791442,591101,301547,83875,384896,138476,457936,730236,726825,551928,429160,744303,769450,6488,1009553,549993,429603,1043653,6737,699291,444699,774386,636275,483940,825483,692372,183410,329450,747491,683503,834853,316671,34037,241484,568734,630273,269864,791164,171976,739836,477311,668729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]