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` = 83612 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 83612 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509852,11989,922315,162481,914367,345541,500389,258465,275441,898748,699104,783277,592462,291902,277644,572239,998078,549453,1028837,827592,739499,1046102,922428,512846,209084,17588,124947,445186,941347,579581,1017260,1009922,719555,480828,657668,713344,956658,256201,933827,419461,1043183,320993,538593,149332,1017221,416572,78325,180089,139574,1005301,215748,875162,834262,928753,901941,1027995,476485,1044907,252339,372230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 83612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 83612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]