SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509830 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509830 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353740,397413,127564,455375,394538,739860,953835,748371,152287,809893,717162,369051,831700,361514,652826,64929,753561,920016,653210,86896,606359,96642,182723,640896,622928,992592,474709,145645,936,372109,28977,846027,984116,605247,923464,625302,407933,305094,207109,865395,608728,480940,105151,52367,386057,437535,347752,729128,504770,148366,425293,367335,10750,919333,194649,1014954,543992,905015,909522,825358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]