SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545054 LIMIT 1 [ RunTime:0.000769s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545054 [ RunTime:0.003426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991966,988742,532165,140212,123479,389592,793179,373935,11386,93778,817854,716366,790813,401873,15613,697546,299905,442544,501419,853140,479756,33648,702165,953650,98960,597668,228968,898850,236590,988229,663503,248574,383289,13302,1005673,792277,917425,929458,973622,957640,393584,1013456,917618,412383,279615,1034186,510361,727451,329389,659118,502359,455605,731563,533310,375066,435564,722777,282722,256982,1010361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]