SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340511 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340511 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951471,1031283,203125,862653,652567,338708,165025,439965,994125,1028132,986497,373154,413181,923423,478003,301612,739681,298322,572610,441231,174443,468856,458987,248791,331313,591932,351012,407417,923136,566910,1006332,716314,479253,699251,853952,88316,764677,957841,39289,340942,973485,990518,171666,1009201,1023580,718547,104058,554838,553004,1047610,634357,810645,760839,651590,351270,532347,121060,162613,252854,934634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]