SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044440 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044440 [ RunTime:0.002902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286971,370648,587067,831935,517947,333524,383071,343314,958023,302807,556121,29192,795981,999957,491038,935315,572216,7716,858274,593842,226059,99159,930744,740171,818707,135106,322274,602039,850875,489123,216687,386798,168409,980598,114689,1045129,782390,654545,552733,274201,323941,725326,175452,648632,18415,915525,251073,286942,5441,739056,210358,881244,473167,426950,156555,704613,184942,774276,399785,428059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]