SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100818 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100818 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863135,247484,2416,1009111,130682,465083,1000400,482615,973431,986677,33963,327035,692079,689247,815456,760685,687796,214006,924043,237457,341658,8241,547357,101304,891080,471030,123482,521696,359818,298158,2465,383162,833226,68955,618486,984959,915050,214614,237529,345113,627556,109082,388373,275948,219849,623800,446421,164288,329466,674366,244104,288526,654344,702811,1008736,421091,390520,190231,470439,919413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]