SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036818 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036818 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762618,920952,346055,954878,917257,95898,732981,828657,4324,827136,84394,309127,561166,835665,639272,733796,1047565,149680,760276,332635,156256,444033,388244,164588,857484,569867,871489,873366,398336,145583,654476,930576,603212,456699,492925,682525,52296,192921,855157,200352,270534,227351,844131,231630,415144,155819,80446,615239,117037,356865,313441,901486,271863,831727,284831,566564,322750,485367,580093,499854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]