SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045629 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045629 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464248,918154,732100,270445,155942,359652,164239,865368,588787,382795,128444,815914,252289,572082,490057,396009,997125,769690,304424,680351,7788,1494,436278,772957,611875,269866,82668,209678,370375,723344,373873,823245,208759,684581,565996,580032,85266,764338,1018614,437142,8689,948726,473339,456329,793133,160057,747567,521760,955319,378876,24624,99095,235260,538982,518219,216181,178487,7707,1043186,1000548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]