SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502665 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502665 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624119,345419,445016,318009,716189,186542,573038,779185,372194,87146,184824,411583,62228,809422,924104,141893,951348,239821,750192,132736,449451,330066,378813,829240,1008493,731594,806015,76119,353866,917815,300574,213370,149742,932151,801157,265425,693812,597251,306130,265101,1001576,652866,789921,175930,102646,604886,580793,945360,1031148,883159,306621,449353,623188,888865,1023456,916722,275973,275686,953338,526090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502665 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502665 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]