SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41914 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41914 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410309,629434,1004357,145073,772092,1001398,975561,975780,475897,529425,178709,451185,414521,875357,258327,512308,459372,205049,63472,810409,455930,956900,916369,261192,899597,628769,111340,965920,277070,927049,308149,123498,646059,120691,471585,868812,115080,302176,455461,1048681,854931,756878,465268,247846,217207,724167,295056,152692,37022,472384,673525,232605,760745,916838,127486,150010,327846,839783,432019,151123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]