SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341578 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341578 [ RunTime:0.002762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829440,615901,123950,65274,345640,482208,163324,961856,233019,750217,172781,90398,6127,853363,519241,883231,650323,882272,76219,1020143,392574,364168,592316,1020564,815758,1038421,636381,226567,922957,993030,346874,312305,871943,838569,833130,9380,837096,218999,372558,787648,781385,1046383,289016,153124,933054,110015,803618,265698,700352,913409,476697,173632,668437,902507,442233,617557,697042,895644,494586,222817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]