SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481959 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481959 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237378,343475,1020356,652612,636168,351949,565196,224517,882503,173595,711302,73716,156417,343806,106776,490391,182002,209738,48101,246529,443362,261530,635928,775395,93163,619957,142407,682728,710433,230454,475069,610907,789253,987179,808121,917827,984864,1046956,275581,391948,445516,935054,249134,991270,620052,909720,72410,708772,303114,232351,670133,770353,761754,140393,306131,1042208,234530,351678,160234,797941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]