SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559823 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559823 [ RunTime:0.003059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41218,475370,273235,611554,320162,56888,417434,157542,311297,650958,966358,678084,960148,942106,235067,387901,728637,808712,337441,633030,873454,764795,815454,734934,69063,148058,224607,91195,170090,261842,143045,598499,624157,864120,441751,420565,860499,897239,251085,527226,543030,487528,249982,746682,970964,979525,51274,1047417,96587,325554,61734,768798,470032,710834,17431,781013,702055,836464,939604,229891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]