SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42035 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42035 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43550,975251,815757,218258,838723,510050,239974,138485,373683,97036,11671,640745,33371,1012532,12629,774545,847564,866356,798013,983214,359524,485898,19413,917274,568388,726642,818142,82345,912520,293743,844029,555269,188763,962598,515591,31043,718944,183077,325591,726270,944300,228011,391267,439755,732264,137860,856000,618366,499508,29656,273883,1012439,182016,871550,386401,246215,528597,693865,19474,537121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]