SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981036 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981036 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915388,759543,994281,507439,44533,722626,436006,173454,433709,472215,99160,152981,316259,648144,678319,394605,527447,609866,788558,615186,364462,97827,590240,381599,179751,235589,237335,736645,209486,200089,713429,439229,192152,562653,66554,435768,996539,40656,657460,215760,364183,76656,350996,1015771,363553,855516,295608,186766,728899,868279,417158,969568,309375,638174,1019547,410107,891792,891830,273893,726563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]