SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114941 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114941 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699711,698042,103619,10606,606457,1031988,35234,418808,550140,746395,700407,578942,579107,425538,19308,678543,990492,923080,18012,285029,241775,315294,47721,163668,861099,1042235,193660,424612,134114,783838,158251,235347,154213,237930,287374,687089,915931,490806,801249,362951,365613,473333,931895,942381,808247,744354,852485,867111,241350,929106,92630,367000,191051,134401,1035847,1014945,743815,1036993,412841,1022217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]