SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007053 LIMIT 1 [ RunTime:0.001955s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007053 [ RunTime:0.003221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722619,804753,659856,519253,120852,399839,854117,1006291,1015638,45249,915858,611708,238775,915492,359104,123003,102577,325763,258187,203769,147719,11166,654783,561027,229927,864069,621866,93967,247044,377328,840075,792098,646855,772911,954582,269772,929798,276748,358484,863338,868511,191521,735464,901611,369732,636914,414045,400818,382329,969181,596036,328083,336129,676614,267598,298230,624758,437101,382442,389232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000839s ]